PROC DB2UTIL, Issue while Insert

[NitinDwivedi]

Hi,

I am using this procedure to insert a record into my DB2 table.

The issue is that I am getting cutoff date when the row gets updated in DB2, whereas I am passing date from SAS dataset  and Current timestamp.

VERS_NR                                     2,801
VERS_DATO                                01.01.1960
VERS_CLIENT_ID                        301
VERS_TYPE                                 LOAD_CST
VERS_TS                                      1960-01-01-00.00.00.253692

Please let me know why it is happening and how to sort out the issue.

Output from SAS Dataset  :

VTYPE      VERSNR    VDATO    VCLIENT       VTS

LOAD_CST     2801     21331      301      1760887609

Excerpt from Code :

proc db2util data=abcd SSID=db0t
table=systemf.tbcrvers function=i;
mapto VERSNR = VERS_NR
VDATO        = VERS_DATO
VCLIENT      = VERS_CLIENT_ID
VTYPE        = VERS_TYPE
VTS          = VERS_TS;
update;
run;

[DartRodrigo]

Hi mate,

This happens sometimes, because if you declare a SAS Date without the correct syntax

it will uderstand that you are making an expression and will print a value close to zero,

the zero if you transform into date format it will be 01/01/1960 that's when SAS was

funded.

Check the working with SAS dates.

Att