RE: Embedded SQL date in DS array problem

Hi Martin,

No go. It was one of the first things I tried - even though SET
OPTION DATFMT = *ISO overrides the compile options.

Feel free to copy/paste the program I included and try it :-)

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 Hillier, Martin
Sent: 19 January 2008 21:02
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL date in DS array problem

Hi Paul,

Try DATFMT(*ISO) DATSEP(-)

Martin
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Tuohy
Sent: 19 January 2008 20:52
To: 'RPG programming on the AS400 / iSeries'
Subject: 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