05-23-2007
sqlldr help
1.The below script works perfectly fine in dev. However, i have been told that i cannot hardcode the password into the file during production impementation. Is their way i could ask the user to enter the password when the script is executed
2. I have seven different files each of which needs to be loaded to a different table.
eg
file table
a 845
b 123
( i am just making this up )
Like that there are seven differnt file and tables
If i have to use control file, sql ldr to load data, i would have to have a ctrl file,data file and a shell script shown below. which means 7*3 = 21 files in total
Is there a way i could use just one shell script that has all the ctrl files info and data file location to process all the files ?
SHELL SCRIPT
export USERID=schema@username/password
export CTRL_FILE_HOME=/SrcFiles/
export DATA_FILE_HOME=/SrcFiles/
#************ Load Data Elements info ******************************
export CTRL_FILE_NAME=DEA.CTL
export DATA_FILE_NAME=DEA.DEL
sqlldr control=$CTRL_FILE_HOME$CTRL_FILE_NAME userid=$USERID skip=0 ERRORS=20000 data=$DATA_FILE_HOME$DATA_FILE_NAME
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am a newbie to Linux(Suse).I am facing a problem with 'sqlldr' utility while trying to upload data to Database tables.My backend is Oracle and is using the UTF8 encoding format.I am trying to load a datafile which contains some Western European Characters.While loading am getting an error... (1 Reply)
Discussion started by: DILEEP410
1 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
Can anyone know how to get the error codes from 'sqlldr' ?While am trying to load some 'ISO-8859-1' data file into 'utf8' oracle database,some records are rejected.I want to know the reason,whether it is due to charset mismatch or some other issues.How come i to know that ?
... (3 Replies)
Discussion started by: DILEEP410
3 Replies
3. Shell Programming and Scripting
Dear expert,
Can we invoke sqlldr command remotely.
When I try rsh command in machine 10.1.65.116, it's failed on sqlloader command. However, nothing wrong on the shell scripts or environment setting of the remote environment, I able to execute in the scripts in remote machine.
in machine... (8 Replies)
Discussion started by: epall
8 Replies
4. Shell Programming and Scripting
Hi,
I've a batch program that load data from a file like:
00000013|FERRAN|JULIAN|GONZALEZ|1|
00000014|FRANCESC|NARVAEZ|PAZOS|1|
00000015|INMACULADA|MAYOL|BELTRAN|2|
I used the sqlldr command in this way:
sqlldr userid=U/P control=$SCRIPTS/CTRL.WCT data=$DATA/FILE log=$LOGS/FILE.LOG... (2 Replies)
Discussion started by: raippl
2 Replies
5. Shell Programming and Scripting
Hola,
Genere un proceso en proC que me inserta registros a oracle, el cual ejecuto desde un shell en Unix. Por otro lado tengo un sqlldr que me hace el trabajo en un 25 % de tiempo que mi proceso en C.
Se que puedo ejecutar mi sqlldr desde un shell, pero no se como hacer, alguien tiene un... (0 Replies)
Discussion started by: marcoinxs
0 Replies
6. Shell Programming and Scripting
Hi
I'm using SQL*Loader in shell script as below
sqlldr $uname/$pword@$ORACLE_SID parfile=$test.par
for e.g. if $test is 'file1'
and getting the below error
LRM-00109: could not open parameter file 'file1'
LRM-00113: error when processing file 'file1'
SQL*Loader: Release... (7 Replies)
Discussion started by: vinoth_kumar
7 Replies
7. Linux
Hi All
I am trying to modifying SQLLDR file in Linux, I’m getting the below error
"counterparty.sqlldr" E506: Can't write to backup file (add ! to override)
Press ENTER or type command to continue
Can someone help me resove this issue.
Thank (1 Reply)
Discussion started by: na.dharma
1 Replies
8. Shell Programming and Scripting
I am using SQLLDR to load data in DB.For parallel loading I'm using nohup command.
The requirement is:
I have different files within a directories.
Ex: 1) Dir/folder_A/AE.txt
2) Dir/folder_A/DM.txt
3) Dir/folder_B/CM.txt
I need to loop through directories and load the data... (1 Reply)
Discussion started by: Pratiksha Mehra
1 Replies
9. Shell Programming and Scripting
Hi ,
I am using below control file
LOAD DATA
APPEND
INTO TABLE LSHADMIN.EG
TRAILING NULLCOLS
(
STUDY CHAR
)
and the text file to load data is
CACZ885M2301
When I run below command:
sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies
10. Shell Programming and Scripting
Hi all,
I'm loading data in database through sqlldr.
I want to know the total record count
And the number of records inserted in table..
what is the logic to achieve that.
Thanks (5 Replies)
Discussion started by: Pratiksha Mehra
5 Replies
LEARN ABOUT CENTOS
db2ldif
DB2LDIF(8) System Manager's Manual DB2LDIF(8)
NAME
db2ldif - Directory Server script for exporting the database
SYNOPSIS
db2ldif [-Z serverID] {-n backend_instance}* | {-s includeSuffix}* [{-x excludeSuffix}*] [-a outputFile] [-m] [-M] [-r] [-u] [-U] [-C] [-N]
[-E] [-1] [-q] [-h]
DESCRIPTION
Exports the contents of the database to a LDIF file. This script can be executed while the server is still running, except when using the
-r option.
OPTIONS
A summary of options is included below:
-Z Server Identifier
The server ID of the Directory Server instance. If there is only one instance on the system, this option can be skipped.
-n Backend Name
The name of the LDBM database to reindex. Example: userRoot
-s includeSuffix
Specifies suffixes to be included in the LDIF file.
-x excludeSuffix
Specifies suffixes to be excluded from the LDIF file.
-a Output File
The name for the LDIF file.
-m
Minimize the base64 encodings in the exported LDIF file.
-M
Exported ldif is stored in multiple files. These files are named : <instance>_<filename>
By default, all instances are stored in the filename specified by the -a option.
-r
Export replication data(information required to initialize a replica when the LDIF is imported).
-u
Do not export the unique-id attribute.
-U
Requests that the output LDIF is not folded.
-C
Uses only the main database file.
-N
Suppress printing sequential number
-E
Decrypts any encrypted data during export.
-1
Deletes, for reasons of backward compatibility, the first line of the LDIF file that gives the version of the LDIF standard.
-q
Quiet mode. Suppresses output of the script.
-h
Display the usage.
EXAMPLE
db2ldif -Z instance3 -n userRoot -a /LDAP/ldif/export.ldif
db2ldif -s 'dc=example,dc=com' -a /LDAP/ldif/export.ldif -m -E -q
DIAGNOSTICS
Exit status is zero if no errors occur. Errors result in a non-zero exit status and a diagnostic message being written to standard error.
AUTHOR
db2ldif was written by the 389 Project.
REPORTING BUGS
Report bugs to http://bugzilla.redhat.com.
COPYRIGHT
Copyright (C) 2013 Red Hat, Inc.
Mar 5, 2013 DB2LDIF(8)