hi, i have fields in tables that we want to convert from date to timestamp.
in the new unload i don't find a way to get out a converted data (not like the old one where we could write a SQL statement).

is there a way i don't know about ?

thanks!

What DB2 platform and release?

os/390

I assume you have DB2 version 7?

You can use DSNTIAUL which is now provided in source code format only and must be assembled (if not already done so). Check out Appendix D of the Version 7 Utility Reference manual.

Using this program you can unload the data with a select statement and then concatenate the date and a string that is the rest of the time stamp.

use this:

timestamp(<date>,<time>)

for example:

timestamp ('2003-01-01','00.00.00')

Abel.