RE: Embedded SQL in RPGLE pgm

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

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