Sponsored Content
Full Discussion: DB2 Export and Import Oracle
Homework and Emergencies Homework & Coursework Questions DB2 Export and Import Oracle Post 302989933 by Sonny_103024 on Thursday 19th of January 2017 10:43:43 PM
Old 01-19-2017
DB2 Export and Import Oracle

Hi Guys,

I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle.

Code:
db2 connect to Tablename user id using psswrd

db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA"
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/BBBBB.DEL' OF DEL select * FROM BBBBB"
db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/CCCCC.DEL' OF DEL select * FROM CCCCC"
...
.. 

db2 terminate

is this enough to make the data perfect export into delimited file? there are some posted that i read, they included the table field names.

what is the different of this 2 (with table field names and without?

can anyone suggest for the import script into oracle?

Thank you very much.

Last edited by Don Cragun; 01-19-2017 at 11:45 PM.. Reason: Fix CODE tags.
 

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Local NFS import / re-export using automount?

Hi, Can I do the following: On SunOS 5.8 /etc/vfstab: remote-host:/Volumes/webdata - /export/home/webdata nfs - yes rw,vers=3,soft,intr,bg,timeo=600 In /etc/auto_direct: /home/science $HOST:/export/home/webdata/science /home/science-edu ... (2 Replies)
Discussion started by: bloyall
2 Replies

2. Solaris

Export/import ZFS ACL's

I've been wondering about this one, is there any way to do the following with ZFS ACL's (i.e. "copy" the ACL over to another file)? getfacl /bla/dir1 | setfacl -f - /bla/dir2 I know about inheritence on dirs, it doesn't work in this scenario I'm working on. Just looking to copy the ACL's. ... (3 Replies)
Discussion started by: vimes
3 Replies

3. Shell Programming and Scripting

manipulate text for openldap import/export question.

Hey guys.. I am not sure if this is the right place to post this - but here goes. I need to manipulate an openldap export to match a different schema so that I can import into that system. Basically - its just text manipulation. I have gotten alot of it done just by using simple sed, but I am sorta... (0 Replies)
Discussion started by: i2ambler
0 Replies

4. Shell Programming and Scripting

Error: SQL3100W while export in DB2

Problem has been resolved (7 Replies)
Discussion started by: ustechie
7 Replies

5. Shell Programming and Scripting

export / import

I have a calling script which consists of calls to other scripts via the sh command. ie vi callscript.sh sh smallscript1.sh extra unix commands sh smallscript2.sh exit In smallscript1, I prompt for a filename, which I handle via :- read f1 export f1 I then need... (5 Replies)
Discussion started by: malts18
5 Replies

6. UNIX for Dummies Questions & Answers

Import and export PGP/GnuPG keys

Hi, I need to export an existing PGP key and import it into GnuPG on a different machine. This is how I did the export: pgp -kx myuser _myuser_public pgp -kx myuser _myuser_private secring.skr (this is from the pgp installation directory that contains secring.skr). This produced two... (0 Replies)
Discussion started by: imchi
0 Replies

7. Solaris

Zpool import/export error

A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he... (2 Replies)
Discussion started by: beantownmp
2 Replies

8. Homework & Coursework Questions

DB2 Export and Import Oracle

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: is this enough to make the data perfect export into delimited file? there are some posted that i read, they... (9 Replies)
Discussion started by: Sonny_103024
9 Replies

9. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies

10. Shell Programming and Scripting

Array - Export/Import in global environment variables.

Hello. During startup /etc/bash.bashrc.local generates some array ..... source /.../.../system_common_general_array_env_var ..... The file system_common_general_array_env_var contains : LEAP_VERSION='42.3' ARRAY_MAIN_REPO_LEAP=('zypper_local' 'openSUSE-Leap-'"$LEAP_VERSION"'-Non-Oss' ... (2 Replies)
Discussion started by: jcdole
2 Replies
Import::Into(3) 					User Contributed Perl Documentation					   Import::Into(3)

NAME
Import::Into - import packages into other packages SYNOPSIS
package My::MultiExporter; use Import::Into; use Thing1 (); use Thing2 (); # simple sub import { Thing1->import::into(scalar caller); } # multiple sub import { my $target = caller; Thing1->import::into($target); Thing2->import::into($target, qw(import arguments)); } # by level sub import { Thing1->import::into(1); } # with exporter use base qw(Exporter); sub import { shift->export_to_level(1); Thing1->import::into(1); } # no My::MultiExporter == no Thing1 sub unimport { Thing1->unimport::out_of(scalar caller); } People wanting to re-export your module should also be using Import::Into. Any exporter or pragma will work seamlessly. Note: You do not need to make any changes to Thing1 to be able to call "import::into" on it. This is a global method, and is callable on any package (and in fact on any object as well, although it's rarer that you'd want to do that). DESCRIPTION
Writing exporters is a pain. Some use Exporter, some use Sub::Exporter, some use Moose::Exporter, some use Exporter::Declare ... and some things are pragmas. Exporting on someone else's behalf is harder. The exporters don't provide a consistent API for this, and pragmas need to have their import method called directly, since they effect the current unit of compilation. "Import::Into" provides global methods to make this painless. METHODS
$package->import::into( $target, @arguments ); A global method, callable on any package. Imports the given package into $target. @arguments are passed along to the package's import method. $target can be an package name to export to, an integer for the caller level to export to, or a hashref with the following options: package The target package to export to. filename The apparent filename to export to. Some exporting modules, such as autodie or strictures, care about the filename they are being imported to. line The apparent line number to export to. To be combined with the "filename" option. level The caller level to export to. This will automatically populate the "package", "filename", and "line" options, making it the easiest most constent option. version A version number to check for the module. The equivalent of specifying the version number on a "use" line. $package->unimport::out_of( $target, @arguments ); Equivalent to "import::into", but dispatches to $package's "unimport" method instead of "import". WHY USE THIS MODULE
The APIs for exporting modules aren't consistent. Exporter subclasses provide export_to_level, but if they overrode their import method all bets are off. Sub::Exporter provides an into parameter but figuring out something used it isn't trivial. Pragmas need to have their "import" method called directly since they affect the current unit of compilation. It's ... annoying. However, there is an approach that actually works for all of these types. eval "package $target; use $thing;" will work for anything checking caller, which is everything except pragmas. But it doesn't work for pragmas - pragmas need: $thing->import; because they're designed to affect the code currently being compiled - so within an eval, that's the scope of the eval itself, not the module that just "use"d you - so sub import { eval "use strict;" } doesn't do what you wanted, but sub import { strict->import; } will apply strict to the calling file correctly. Of course, now you have two new problems - first, that you still need to know if something's a pragma, and second that you can't use either of these approaches alone on something like Moose or Moo that's both an exporter and a pragma. So, a solution for that is: my $sub = eval "package $target; sub { shift->import(@_) }"; $sub->($thing, @import_args); which means that import is called from the right place for pragmas to take effect, and from the right package for caller checking to work - and so behaves correctly for all types of exporter, for pragmas, and for hybrids. Additionally, some import routines check the filename they are being imported to. This can be dealt with by generating a #line directive in the eval, which will change what "caller" reports for the filename when called in the importer. The filename and line number to use in the directive then need to be fetched using "caller": my ($target, $file, $line) = caller(1); my $sub = eval qq{ package $target; #line $line "$file" sub { shift->import(@_) } }; $sub->($thing, @import_args); And you need to switch between these implementations depending on if you are targetting a specific package, or something in your call stack. Remembering all this, however, is excessively irritating. So I wrote a module so I didn't have to anymore. Loading Import::Into creates a global method "import::into" which you can call on any package to import it into another package. So now you can simply write: use Import::Into; $thing->import::into($target, @import_args); This works because of how perl resolves method calls - a call to a simple method name is resolved against the package of the class or object, so $thing->method_name(@args); is roughly equivalent to: my $code_ref = $thing->can('method_name'); $code_ref->($thing, @args); while if a "::" is found, the lookup is made relative to the package name (i.e. everything before the last "::") so $thing->Package::Name::method_name(@args); is roughly equivalent to: my $code_ref = Package::Name->can('method_name'); $code_ref->($thing, @args); So since Import::Into defines a method "into" in package "import" the syntax reliably calls that. For more craziness of this order, have a look at the article I wrote at <http://shadow.cat/blog/matt-s-trout/madness-with-methods> which covers coderef abuse and the "${...}" syntax. Final note: You do still need to ensure that you already loaded $thing - if you're receiving this from a parameter, I recommend using Module::Runtime: use Import::Into; use Module::Runtime qw(use_module); use_module($thing)->import::into($target, @import_args); And that's it. ACKNOWLEDGEMENTS
Thanks to Getty for asking "how can I get "use strict; use warnings;" turned on for all consumers of my code?" and then "why is this not a module?!". AUTHOR
mst - Matt S. Trout (cpan:MSTROUT) <mst@shadowcat.co.uk> CONTRIBUTORS
haarg - Graham Knop (cpan:HAARG) <haarg@haarg.org> COPYRIGHT
Copyright (c) 2012 the Import::Into "AUTHOR" and "CONTRIBUTORS" as listed above. LICENSE
This library is free software and may be distributed under the same terms as perl itself. perl v5.18.2 2013-12-10 Import::Into(3)
All times are GMT -4. The time now is 01:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy