Re: RPG SQL error...

["JJW" <rpgilejjw@xxxxxxxxxxx>]

Another option you could use instead of setting the
compile option COMMIT(*NONE) just insert the following
statement after the WHERE statement within the SQL
statement.

With NC


On Fri, 9 Aug 2002 11:45:50 -0400
  "Joel R. Cochran" <jrc@masi-brac.com> wrote:
>As if I haven't been messing around with new satuff
>enough recently I'm
>trying to write my first SQLRPGLE program.  I use SQL
>frequently in Java for
>JDBC access, so I am not new to it just to doing so in
>RPG.
>
>I have the following SQL Statement:
>
>c/Exec SQL
>c+              Update    VMLOCAXES2
>c+                 Set    XBEGDATE = :sqlBegDate,
>c+                        XENDDATE = :sqlEndDate
>c+               Where    XCLIENT = :clientId and
>XPACKAGE = :AXLOC
>c/End-Exec
>
>All variables are populated correctly (according to
>Debug) just prior to
>executing this statement.  I am receiving the following
>error information:
>
>SQLCOD = -7008
>
>The description for this is:
>&1 in &2 not valid for operation.
>
>SQLERM = VMLOCAXES2 CGILIB2
>
>This is the correct library, so why would the file not be
>valid for UPDATE?
>Could it have something to do with Commitment control?
>
>TIA,
>
>Joel R. Cochran
>Director of Internet Services
>VamaNet.com
>(800)480-8810
>mailto:webmaster@vamanet.com
>
>_______________________________________________
>This is the RPG programming on the AS400 / iSeries
>(RPG400-L) mailing list
>To post a message email: RPG400-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit:
>http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>or email: RPG400-L-request@midrange.com
>Before posting, please take a moment to review the
>archives
>at http://archive.midrange.com/rpg400-l.
>

<TEXTAREA NAME="Signature" ROWS="4" COLS="60"><TEXTAREA
NAME="Signature" ROWS="4" COLS="60">