UNIX for Dummies Questions & Answers

ALL,

My shell script takes a employee file as input.
I have to identify the list of employees not in the input file and update their status in the database.

Approach I followed:
by traversing through the input file add all the emplid's to a variable.
update the status of employees not in the lsit.

Point where my code woudnt work:
when the number of employees in the input file is more than 1000,
DB2 update query fails.The reason being DB2 not IN clause accepts only 1000 parameters.

Could someone suggest a better approach.

my code snippet is as follows(Shell : KSH):


$EMPLIST=""
cat $FILEDIR/exec.csv | tr -d '\r' | while read emplid
do
EMPLIST=$EMPLIST,"'"$emplid"'"
done

db2 -x "update employee set modifiedtstmp = current timestamp,xec_fl='N' where emplid not IN ($emplid)"


Thanks In Advance

Use a temp table - insert each empid into the temp table.

Code:

.......emplid  Not In (select emplid from tmptab);

Then delete the records in tmptab

Thank you for the reply.
I do not have permissions to create temp tables :-(