Re: Invalid dates in data transfer

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

I don't use iSeries Access file transfer (so why am I replying to this? 
not sure.)

But, that error usually crops up when you have a date like 0001-01-01 
(the year 1) and you try to convert it to a 2-digit year.  Since the 
system doesn't want it to convert to 01-01-01 (since that would be 
perceived as 2001) it throws the error message.

Is it possible to set your transfer options to include a 4-digit year?


James Rich wrote:
> Hi list,
>
> We're trying to use data transfer in iSeries Access to transfer a file 
> from the i to the PC.  The file includes date fields.  Some of the dates 
> are *LOVAL and when transferring we get error SQL0181 "Value in date, 
> time, or timestamp field not valid".  Any solution to getting the file 
> transferred?
>
> James Rich