RE: SQL0180 on SQL insert

Birgitta,

If SQL "cannot handle character representations with 2 digit years (except
the current job's date format)", which of my date's is set up as a two digit
year? One is an *ISO and the others are *USA. Nowhere am I using *MDY (or
*YMD, or *DMY). Are you saying that RPG is forcing a date to be represented
as a character representation, which happens to be a two digit year? If so,
where is that done? How do I see that? All the compile references show
them as 10 characters.

Thanks

Tom Garvey

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, July 10, 2012 12:15 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL0180 on SQL insert

Birgitta,

You are right, of course. Somehow in all the coming and goings of messages I
erased the original post and had forgotten how Thomas was inserting his
data. I'm not very sure if I have any (SQL) programs inserting the whole
record at a time (opposed as doing it as a list of columns) but, at the same
time, all my dates are defined as *ISO.

I'm pretty sure you "hit the nail on the head" regarding Thomas's problem.
Thanks for your help.

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert ? eServer i5 iSeries