× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Can you show us the code being this problem? I have never had an issue
getting date data, except for two reasons.  One, the date format is to short
for dates outside IBM's window for short dates like *MDY.  Two, the result
field data was NULL.  In the latter case you also have to specify the null
indicator field, structure.  

Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kurt Anderson
Sent: Friday, July 15, 2005 10:50 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL - fetching a date

Our default is *ISO.
Added in the Set statement to change it to *ISO explicitly, but the
program still doesn't like putting the date into the Date data structure
subfield.

The subfield is defined off the same field I'm retrieving the date from,
so there shouldn't be any format discrepancies there.  


Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tyler, Matt
Sent: Friday, July 15, 2005 10:30 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Embedded SQL - fetching a date

Did you create the program or set the option like this?

C/EXEC SQL                 
C+ SET OPTION DATFMT = *USA
C/END-EXEC                 

Or

C/EXEC SQL                 
C+ SET OPTION DATFMT = *ISO
C/END-EXEC                 

The default is *MDY. 

Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Kurt Anderson
Sent: Friday, July 15, 2005 9:23 AM
To: RPG programming on the AS400 / iSeries
Subject: Embedded SQL - fetching a date

I can't seem to fetch a date format field and place it in a date format
field in a Data Structure.  If I change the field in the DS to be 10A
instead of D, then it works.
 
Is there something I can do so I can drop the value right into a date
format field instead of having to drop it into an Alpha field and then
move it to a date format field myself?
 
I don't seem to have this problem when I do a simple Select Into
statement.
 
Thanks,
 
Kurt Anderson
Application Developer
Highsmith Inc.
W5527 State Road 106, P.O. Box 800
Fort Atkinson, WI 53538-0800
TEL (920) 563-9571  FAX (920) 563-7395
EMAIL kjanderson@xxxxxxxxxxxxx
 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.