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

Check the manual for your shell for the 'read' command. If you need to turn off echoing of characters when the user puts in the password it can be turned off and on using the 'stty' command.