defining Timestamp in Fastload?

Tools & Utilities
Enthusiast

defining Timestamp in Fastload?

hi ,

how do u set Timestamp in a fastload script?

2 REPLIES
Enthusiast

Re: defining Timestamp in Fastload?

Hi,

To set Timestamp in ur Fastload script, U sud define the Character Type in Define statments.

example:
Define: datetime (char(19),Nullif=0000-00-00b00:00:00),
..............................................)

when inserting the data like
Insert into dbname.tname values(
:datetime (format 'yyyy-mm-ddbhh:mm:ss')

I hope this will help u.

regards,
B Mohan Kumar
Teradata Certified Advanced Professional
Enthusiast

Re: defining Timestamp in Fastload?

hi Mohan

Thank you for ur timely answer. It sure did help.

Regards,
Shwetha