Re: SQL Table and RPGLE Error message

[Alan Campin <alan0307d@xxxxxxxxx>]

Thought you were doing SQL for I/O. Is the table journaled?

On Wed, Jun 8, 2011 at 1:19 PM, Bill Hopkins <bhopkins@xxxxxxxx> wrote:

> So does that mean every RPGLE program that I want to use SQL created
> tables with commit *none have to be changed to SQLRPGLE types? Even
> though the programs will not be executing any SQL statements?
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Walter
> Sent: Wednesday, June 08, 2011 2:59 PM
> To: RPG programming on the IBM i / System i
> Subject: RE: SQL Table and RPGLE Error message
>
> 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.
>
> --
> 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.