DSXchange

I have to delete from db2 table where db2 timestamp column is defined as 26,6 and its value is as follows:
2008-09-03 13:42:10.333

While extracting from the db2 table and passing to a dataset, same timestamp column is giving value as follows:
2008-09-03 13:42:10

When i try to delete from the table with above key its not matching and doesnt delete rows. Any suggestion.

DB2 has somewhat of an odd default timestamp format (if you are more from an Oracle background). It is yyyy-mm-dd-hh24.mi.ss.nnnnnn

Notice the hyphen between the day and hour, and the decimal points between the minutes, second and milliseconds. Try using a timestamp in this format if you can.

John

Server job (as marked) or parallel job (as posted)?