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.


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].