Datetime field overflow

prmuttireddy · Post by **prmuttireddy** » Thu Sep 27, 2007 2:17 am

Hi,

I am using the following scenario

DRS--->Trans------>DRS

In the job i have changed all Date fileds to Timestamp.
while i am running it has been giving the following warnings.........

Serv_hr89_epm89_job_jr_ins_after_upd..TRNAddSubRecVal: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008

Please help on this?

Regards,
Reddy.

JoshGeorge · Post by **JoshGeorge** » Thu Sep 27, 2007 2:58 am

Your target database is expecting Timestamp in a different format. You might have to to format it according the expecting format.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 27, 2007 3:25 am

What is the highest legal date in the database? Have you supplied a date later than this?

prmuttireddy · Post by **prmuttireddy** » Fri Sep 28, 2007 12:22 am

Thanks, I got it.

Regards,
Reddy.