Search Results

You may delete the records in Table2 first where the common columns in two Tables are matched and condition on date field of first table is satisfied.

(I'm not sure with the DB2 would accept...

First off: i am more or less on my vacation and writing this on a Windows-machine, lacking a *NIX-system to test my words against. Please bear with me that i will give you untested instead of working...

Are you by any chance using a Solaris system? If so, use /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk instead of just awk.