Re: SQL Table and RPGLE Error message

[Alan Campin <alan0307d@xxxxxxxxx>]

As said above, how the table is created has nothing to do with how the table
is opened. You either have to specify it when you create the rpg program or
through a set options.

On Wed, Jun 8, 2011 at 12:58 PM, Mark Walter <mwalter@xxxxxxxxxxxxxxx>wrote:

> Your other option is to create the SQLRPG program object with the
> COMMIT(*NONE) option. The default is COMMIT(*CHG). If you don't use
> commitment control on your system, change the command default to
> COMMIT(*NONE).
>
>
> Mark Walter
> Business to Business Data Integration Specialist
> Certified IBM System i Specialist
> Paragon Consulting Services, Inc.
> mwalter@xxxxxxxxxxxxxxx
> 717-764-7909 ext. 126
> ________________________________________
> From: rpg400-l-bounces@xxxxxxxxxxxx [rpg400-l-bounces@xxxxxxxxxxxx] On
> Behalf Of Bill Hopkins [bhopkins@xxxxxxxx]
> Sent: Wednesday, June 08, 2011 2:49 PM
> To: RPG programming on the IBM i / System i
> Subject: RE: SQL Table and RPGLE Error message
>
> Alan
>
> Can you explain why this needs to be in the program "set option commit
> *none" when the SQL Table I'm opening was already define with "commit
> *none"
>
> Thanks
> Bill
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
> Sent: Wednesday, June 08, 2011 2:22 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: RE: SQL Table and RPGLE Error message
>
> Hi Bill
> Do you have the following in your RPGLE program
> /free
>  exec sql Set Option Commit = *None;
> /end-free
> If not, make sure to insert this in the early (low numbered ) c-specs
>
> Alan Shore
> Programmer/Analyst, Direct Response
> E:AShore@xxxxxxxx
> P:(631) 200-5019
> C:(631) 880-8640
> "If you're going through Hell, keep going" - Winston Churchill
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bill Hopkins
> Sent: Wednesday, June 08, 2011 11:41 AM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: SQL Table and RPGLE Error message
>
> Hi All,
>
>
>
> I have an SQL Table created with "commit *none".
>
>
>
> When the RPGLE that uses the table is called it fails when it tries to
> open the SQL Table.
>
>
>
> Message given CPF4326- "Commitment definition   not valid for open of
> ."
>
>
>
> I understand getting this message with poor activation group planning,
> bad scope, etc. but never had this issue.
>
>
>
> V5R4
>
>
>
> Thanks
>
> Bill
>
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.