Hi,

Can anyone let me know how to load a field in a table with CURRENT DATE using DSNUTILB .

Thanks in Advance.

Thank you,
Rajan Babu.

high,

you can't specify this in the load-control-statement.

If the column is NOT NULL WITH DEFAULT, just omit that column in the load-control-statement, as CURRENT DATE is the default value.

otherwise, you have to modify the load dataset before loading it into the table

Thank you Umayer,

Can you please let me know is there anyway to load CURRENT DATE - 1 DAY ?

"CURRENT DATE - 1 DAY" cannot be specified as a default value.

Best way is, to modify the load dataset before loading it into the table

Thank you!!! Umayer