× 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.



Yes, both fields (i.e. the date filed in the DS and the date field on the
table are *ISO).

Changing the compile option makes no difference - BTW that is what the SET
OPTION DATFMT = *ISO is doing so you don't have to change the compile
defaults.

I think Birgitta has identified it as a problem - or at least something that
needs to be documented. BTW Anyone should be able to copy/paste the code I
included and see if it compiles.

Regards

Paul Tuohy
ComCon
www.comconadvisor.com
www.systemideveloper.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of CRPence
Sent: 19 January 2008 19:07
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Embedded SQL date in DS array problem

Both fields? Regardless, ...
Specify DATFMT(*ISO) on the compile. I am not clear on why
specifying DatFmt(*ISO) on MyDate would not suffice instead, but it
seems not to help. The default from the compile is DATFMT(*JOB), but I
change my default compiles to *ISO.

Regards, Chuck

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.