RE: Embedded SQL in RPGLE pgm

This is my preferred method for setting the options!!

much better than depending on the compiler option or specifying with nc on all 
SQL statements.

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Thursday, August 04, 2005 1:02 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Embedded SQL in RPGLE pgm


Alternative option is to use SQL's version of the Hspec:

     C/EXEC SQL
     C+ Set Option
     C+     Naming    = *Sys,
     C+     Commit    = *None,
     C+     UsrPrf    = *User,
     C+     DynUsrPrf = *User,
     C+     Datfmt    = *iso,
     C+     CloSqlCsr = *EndMod
     C/END-EXEC

Notice the commit=*none?


Rob Berendt