The string representation of a datetime value is out of rang

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sunil2020
Participant
Posts: 9
Joined: Fri Sep 21, 2012 9:10 am

The string representation of a datetime value is out of rang

Post by sunil2020 »

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
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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?
Post Reply