Timestamp datatype with TPump / Fastload

[Sridharan]

Hello,

Is it possible to load file with Timestamp(0) datatype through TPump Or Fastload....the input file was created from bteq...... I'm able to do use that as input file in Mulltiload but not in TPump or FastLoad.....

I also found that we should define Timestamp(0) field as

TIMESTAMP
TIMESTAMP
where n is the number of digits after the decimal point, 1 through 6. (Default = 6.)
Convert to: CHAR(19 + n + (1 if n > 0, otherwise 0))

from V2r4 documentation....

I tried, but this is the error that i'm getting in TPump

12:09:33 UTY6610 Logged on 4 sessions.
**** 12:09:34 UTY8001 RDBMS failure in Packing Test: 5407, Invalid operation on an ANSI

I have defined the field as CHAR(19) coz if i say Timestamp(0) TPump says unrecognized name....

While inserting I've cast that variable like this

load_dt = castload_dt as timestamp(0))

thanks for ur replies

regds

sridharan