RE: SQL fetch

[Scott Johnson <sjohnson@xxxxxxxxxxxxx>]

On the CRTSQLRPGI and CRTSQLRPG commands check the DATFMT option.  
We had to change ours to *ISO when we started using Date Data Types.

--  Hope this helps.....
------------------------------------------------------
Scott P. Johnson                sjohnson@highsmith.com
Programmer/Analyst
Highsmith Inc.
W5527 Hwy 106, PO BOX 800
Fort Atkinson, WI 53538-0800
TEL:  414-563-9571              FAX:  414-563-7395
------------------------------------------------------



----------
From:  Rick Baird[SMTP:rbbaird@premsys.com]
Sent:  Wednesday, July 30, 1997 12:00 AM
To:  MIDRANGE-L@midrange.com
Subject:  SQL fetch

Hey, all.

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.

What gives?  Any ideas?   Do I need to specify some job/session level
date format?

Thanks in advance.

Rick



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *