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
LLOGIN(1)						      General Commands Manual							 LLOGIN(1)

NAME
llogin - Connect to a LAT service SYNOPSIS
llogin [options] service Options: [-dvcpblhQ] [-H node] [-R port] [-n name] [-w password | -W] [-q quit char] DESCRIPTION
llogin connects your terminal to a LAT service via latd, the service name must be known to latd for this to work. OPTIONS
-d Shows learned services. This is the same as latcp -d -l -d -v Verbose form of -d. -v without -d is ignored. -H <node> Remote nodename. If the service is advertised by more than one node and you want to connect to a particular node then use this switch. By default you will be connected to the node with the highest rating. -R <port> Connect to a specific port on (usually) a terminal server. This is the port NAME on the server and not the port number. -c Do not convert typed LF to CR. By default the enter key generates LF and llogin converts it CR as it is the most generically useful translation. This switch will cause the enter key to send LF instead. Occasionally useful for connecting to Unix consoles. -b Convert typed DEL to BS. By default the DEL key (keyboard, top right usually) send DEL (ASCII 0x7f) to the remote system. This switch will cause the DEL key to send BS (ASCII 8) instead. Useful for some Unix systems connected via terminal servers. -l Convert output LF to VT. By default LF output is sent as CRLF which can cause output formatting problems. Changing this to VT should preserve the output formatting on most devices or terminal emulators. -q <char> Change the quit character. By default CTRL-] will quit the terminal session. Entering a character after -q will cause CTRL-<char> to be the quit character for that session. -q0 will disable the quit character. If you use the latter, make sure you are connecting to a service that will disconnect you when you log out or you will have to kill llogin from another session to get out of it! -Q Tells latd that the service you are connecting to is queued service and not a normal login service or port service. Unfortunately latd cannot tell whether a remote service needs to be queued or not so the onus is on the user to specify this switch when connect- ing to a queued service. -n <name> Sets the local connection name. By default this will be your local TTY name. In most cases this simply affects the display of the terminal on the remote end so you shouldn't need to change it. -w <password> Sends the password for the service. Only needed for services that require a password for access. If the password given is "-" then you will be prompted for a password and it will not be echoed. This avoids having passwords visible on the screen. -W Prompts for the service password. This is the same as -w- (see above). -p Tells llogin to connect to the device named instead of a LAT service. This would usually be a /dev/lat pseudo-terminal but could be any other device you like really. This switch does not make the program useful as a terminal program because there is no way to set any serial parameters, nor am I going to add them. This is just a convenient way to use the /dev/lat ports without the overhead of programs such as minicom. -h Displays a brief usage description. This is the same as invoking llogin without any parameters at all. SEE ALSO latcp(8), latd(8) LAT utilities January 3 2002 LLOGIN(1)
All times are GMT -4. The time now is 03:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy