Shell script and sql

Shell Programming and Scripting
1

Hi,

I have an issue. There is a file that has got some values seperated by commas. I have to write a shell script that would extrct these values and insert them into a table. How can this be done

Thanx in advance

2

Use sqlldr

I use something as follows in my shell script.

        sqlldr $\{DBUSER\}/$\{DBPASS\}@$\{ORACLE_SID\} \\
                    data=$\{INFILE\}.data \\
                    bad=$\{INFILE\}.bad \\
                    control=$\{CTLFILE\} \\
                    log=$\{INFILE\}.log > /dev/null 2>&1

Here, DBUSER,DBPASS and ORACLE_SID are self explanatory.

${INFILE}.data is the actual data file that you have with comma separated values.
${INFILE}.bad will be the file generated with records which were not inserted in the table.
${CTLFILE} is the control file which contains information about how the data is to be loaded. One example is as follows.
my_table.ctl
-----------------------------------------------------
LOAD DATA
INFILE 'use_parameter_value'
BADFILE 'use_parameter_value'
APPEND
INTO TABLE My_Table
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(
name
,address
,username
,password
)
-------------------------------------------------------

${INFILE}.log is the file where the logs for the operations done by sqlldr are written.

Rahul.

3

I have my values in a file called 'val'. when I followed the same procedure It tells me that "unable to open val.dat : No such file or directory." I'm trying to do this from the same directory where my file with values and control file are there.
Please help me out.

Thanx in advance

4

Please specify the command yu are giving. I assume you are passing data=val.dat, but you should pass 'val' as your filename is val itself.

Rahul.