DSXchange

SQL0181N The string representation of a datetime value is out of range. SQLSTATE=22007

I am using a transformer stage -- which has 2 inputs ( 1 seq file and ref look up)

This is a migration project from 7.5 to 8.7 . It worked fine in 7.5

I have lot of date fields. Is there a way to track this field

I usually end a up making a copy of the job, then progressively delete columns until the error goes away and hopefully having written down the last deletion so that I know which column is at fault.

What is your target date datatype and database?