RE: RPG SQL error...

["Joel R. Cochran" <jrc@xxxxxxxxxxxxx>]

Thanks Rob, that was it!

Of course, the question does come to mind: if the command name is
CRTSQLRPGI, indicating an RPGILE module, and almost all RPG runs on an
AS/400, and I'd be willing to bet that the majority of them are NOT
journaling, shouldn't the command default be *NONE?  Either that or my view
of the world is far too simplistic...

:-)

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


> -----Original Message-----
> From: rob@dekko.com [mailto:rob@dekko.com]
> Sent: Friday, August 09, 2002 11:54 AM
> To: rpg400-l@midrange.com
> Subject: Re: RPG SQL error...
>
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> Unless you have the file journaled you must compile your program with
> COMMIT(*NONE)
>
> 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 10:45 AM
> Please respond to rpg400-l
>
>
>         To:     "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
>         cc:
>         Fax to:
>         Subject:        RPG SQL error...
>
>
> 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.
>
>
>
> _______________________________________________
> 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.
>