Re: Dates Higher Than 2050?

[MKirkpatrick@xxxxxxxxxxxxxxxxx]

Check your syntax maybe?

This free-form works for me:

       exec sql
        Set Option
            Naming    = *Sys,
            Commit    = *None,
            UsrPrf    = *User,
            DynUsrPrf = *User,
            Datfmt    = *iso,
            CloSqlCsr = *EndMod; 
 




From:
Mike <koldark@xxxxxxxxx>
To:
"RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Date:
07/20/2009 12:04 PM
Subject:
Re: Dates Higher Than 2050?
Sent by:
rpg400-l-bounces@xxxxxxxxxxxx



So, why can't I use SET OPTION in free-format SQL? It errors out on me 
every
time. It is the first SQL statement in the source.