Hi,

I have 5 files in a directory.

emp1_usage.txt
emp2_usage.txt
emp3_usage.txt
emp4_usage.txt
emp5_usage.txt

I am using sqlldr to get the contents of the above 5 files and store it in a temp table and update my original table using temp table.

for f in *emp*.txt
do
sqlldr usr/passwd control=data.ctl data=$f
done


Now, the problem i got is:

I have a table called 'emdc' in which one column has the values:

emp_name
------------
emp1
emp2
emp3

I should dynamically check what are the values in the emdc table and pass to the sqlldr those file-names which have the values in the emdc table.

Let me explain Clearly:

I should now process only emp1_usage.txt, emp2_usage.txt, emp3_usage.txt into the sqlloader.

The script should automatically check for the values in emdc table and process only the 3 files among the 5 files present in the directory.

Please send me the snippet of the code.

Thanks in advance...........

Check this out...

There are somethings which you need to re-write. I will say what those are, at the end.


#! /bin/sh

while read line
do
emdc_value=${emdc_value}" "`echo $line | awk -F"[ ]*" '{ printf $1 }'`
done < emdc.table

for f in $emdc
do
sqlldr usr/passwd control=data.ctl data=$f
done

emdc.table contains

emp_name
------------
emp1
emp2
emp3

In the awk part of the script, you will need to modify the argument passed to printf. Right now I am assuming that in line 1, emp1 is the first field; line 2 , emp2 is the first field. Also the other assumption, the delimiters between the different fields of each line is space.
You will need to change those to suit your emdc.table configuration.

Havent tested it. Didnt have an input file.

Post the results if the script breaks somewhere.

Vino

Hi,

I am not clear with variables u have used in the shell script.

emdc_value, emdc.table, $emdc

The script again is,


Hope this makes it more clear.

After the while loop is read completely, emdc_value should contain the values, emp1, emp2 emp3.. i.e. entries from the input file ( your emdc table).

vino