Dataloading between two DB2 databases
Posted: Thu Apr 28, 2005 8:57 am
I am trying to load data between two databases. Both are DB2 databases and the table structure is exactly same. The ETL map is very straighforward.
This particular ETL makes use of Dynamic RDBS stage for source and target.
When I execute the map, I am getting the following error.
[IBM][CLI Driver][DB2/AIX64] SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007
I am able to execute an insert statement outside of ETL fine with proper date values. I have also checked the date value in source database and it looks fine to me.
Any ideas?
Thanks in advance,
-Anil
This particular ETL makes use of Dynamic RDBS stage for source and target.
When I execute the map, I am getting the following error.
[IBM][CLI Driver][DB2/AIX64] SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007
I am able to execute an insert statement outside of ETL fine with proper date values. I have also checked the date value in source database and it looks fine to me.
Any ideas?
Thanks in advance,
-Anil