RE: Embedded SQL date in DS array problem

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