Re: SQL5011 - Why am I getting this?

[Rory Hewitt <rory.hewitt@xxxxxxxxx>]

Can't you use the DATFMT keyword in the H-spec, or does that not work for
SQLRPGLE?

H DATFMT(*ISO)

On Thu, May 12, 2011 at 9:57 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:

> Is your SET OPTION statement the physically first SQL Statement within your
> Source?
> Or is it for example in your *INZSR Subroutine at the end of your program?
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> Im
> Auftrag von Siegrist, Dawn (Penske)
> Gesendet: Thursday, 12. May 2011 18:20
> An: RPG programming on the IBM i / System i
> Cc: Falatko, Jerry (Penske)
> Betreff: RE: SQL5011 - Why am I getting this?
>
> I tried adding the set option at the beginning of my program.
> Exec SQL
>         SET OPTION DATFMT = *ISO;
>
> But when I tried to compile, it still failed.
>
> The only thing that will work is if I prompt the compile command and
> change the date format parameter to *ISO.  I prefer to do that inside of
> the program when I can because I might forget it the next time I have to
> compile the program, but apparently that is the only way the SQL
> precompiler will recognize it.
>
> Dawn Siegrist