RE: SQL5011 - Why am I getting this?

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Dawn,

Overriding the compiler to default to *ISO formatted dates corresponds to:

H DatFmt(*ISO)

In this case, you need to ensure that both defaults (RPG default Date format, and SQL default Date format) are identical.  Add the H spec and try your compile again.

Hth,
-Eric DeLong

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Siegrist, Dawn (Penske)
Sent: Thursday, May 12, 2011 11:20 AM
To: RPG programming on the IBM i / System i
Cc: Falatko, Jerry (Penske)
Subject: 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