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.
Datetime field overflow
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Your target database is expecting Timestamp in a different format. You might have to to format it according the expecting format.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Tue Jun 20, 2006 10:22 pm