RE: RPG SQL error...

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Me too, as much as I don't like changing command defaults.  And I do like
the H spec options in RPGLE versus command defaults.
The only problem I see with this is if you do start journalling.  Oh well,
you'd have to recompile the programs anyway.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Joel R. Cochran" <jrc@masi-brac.com>
Sent by: rpg400-l-admin@midrange.com
08/09/2002 11:46 AM
Please respond to rpg400-l


        To:     "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: RPG SQL error...


Thanks, I'll tuck that one away for future use!

Joel R. Cochran
Director of Internet Services
VamaNet.com
(800)480-8810
mailto:webmaster@vamanet.com


> -----Original Message-----
> From: JJW [mailto:rpgilejjw@charter.net]
> Sent: Friday, August 09, 2002 12:34 PM
> To: rpg400-l@midrange.com
> Subject: Re: RPG SQL error...
>
>
> 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">
> _______________________________________________
> 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.
>
_______________________________________________
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.