inserting current time stamp and date



IBM's flagship relational database management system

inserting current time stamp and date

Postby gauravfrankly » Tue Sep 01, 2015 12:31 pm

LOAD DATA
REPLACE
RESUME NO
INTO TABLE XXXX.TABLE1
( INDV_ID POSITION(1:10) INTEGER,
SURNAME POSITION(11:74) VARCHAR(64) STRIP BOTH,
FORENAME POSITION(79:138) VARCHAR(60) STRIP BOTH,
FORENAME_LEN POSITION(75:77) SMALLINT,
FORENAME_FCHAR POSITION(78:78) VARCHAR(1) STRIP BOTH,
MIDDLENAME POSITION(143:202) VARCHAR(60) STRIP BOTH,
MIDDLENAME_LEN POSITION(139:141) SMALLINT,
MIDDLENAME_FCHAR POSITION(142:142) VARCHAR(1) STRIP BOTH,
INDV_DOB POSITION(284:293) EXTERNAL(10) STRIP BOTH,
GENDER POSITION(203:203) VARCHAR(1) STRIP BOTH,
KEY_INFO POSITION(204:263) VARCHAR(60) STRIP BOTH,
CASE_REF POSITION(264:283) VARCHAR(20) STRIP BOTH,
LAST_UPDATE_DTTM CURRENT_TIMESTAMP TIMESTAMP EXTERNAL(26),
)

GETTING EXTERNAL AS INVALID KEYWORD
what would be my datatype for LAST_update_DTTM column in table
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: inserting current time stamp and date

Postby NicC » Tue Sep 01, 2015 6:38 pm

TIMESTAMP?
Why are you coding EXTERNAL? Is it in the documentation?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post