ALL,

My update query wouldnt work because the number of parameters in IN clause exceeds 1000 parameters.

Could someone suggest an alternative to IN clause.

P.S. : I do not have permissions to create a temp table.

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)"

You could insert the values into a temporary table, then use a subselect against that table: "... WHERE emplid NOT IN ( SELECT ... FROM temp-table )"

Thank you for the reply.
I do not have the permissions to create TMP tables in database.
My database do not have any existing TMP tables.

Then you may have to break this down as:

I don't know much about Shell script.
I guessed $emplid was made like 'emplid1','emplid2', ... ,'emplidn'.
If you can modify it like 'emplid1,emplid2, ... ,emplidn'.
You can try this:
where LOCATE(emplid,$emplid) = 0
I assumed column emplid doesn't include comma(',').
If length of emplid is 6, you can make about 4500 emplid list.

The Temp table concept is more feasible for such cases. If you have privilege to CONNECT to the database, you should also have Privilege to DECLARE A TEMP TABLE.

Its very simple: just DECLARE TEMP TABLE (COL1) inside your shell script.
Insert into the TEMP TABLE
and then use the same script.

DB2 Version 9 for Linux, UNIX, and Windows SQL Reference Volume 2
Does it mean that Privilege to DECLARE A TEMP TABLE is not automatically given at the time of CONNECT?