Re: SQL fetch

[Tim_Lennon/Thomas_Miller_at_MUTUAL@xxxxxxxxxxxx]

  <<snip>>
>I have a question about imbedded sql (rpgle) and date data types.
>I use RPG to populate a database field with a date in *iso format
(yyyy-mm-dd), and INSERT into a file via imbedded sql.  But when I try
to FETCH the data, I get an invalid date error.
>The date is correct in the file, but the dump says that the sql_000xx
field that sql is trying to move into the field is in mm/dd/yy format.

You may need to check the H spec. in your RPG - look at the definition
of the field that you are fetching **into**, and the definition which
it is given in the dump. I could be wrong, but that would be my, ahem,
knee-jerk reaction.

Tim Lennon.
Analyst/Programmer
Thomas Miller & Co., London.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *