DATA Step, Macro, Functions and more

PROC DB2UTIL, Issue while Insert

Reply
Occasional Contributor
Posts: 17

PROC DB2UTIL, Issue while Insert

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;

 

Regular Contributor
Posts: 212

Re: PROC DB2UTIL, Issue while Insert

[ Edited ]
Posted in reply to NitinDwivedi

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

Ask a Question
Discussion stats
  • 1 reply
  • 174 views
  • 0 likes
  • 2 in conversation