Re: how create table as in qtemp with data under commitment control?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I don't think you can use commitment control to a table in QTEMP...

But try Rob's suggestion of DECLARE GLOBAL TEMPORARY TABLE...

Otherwise, simply leave commitment control on for the program and add WITH
NC to the statements that write to the temp table.

Charles



On Fri, Jun 21, 2019 at 6:50 AM Steve Richter <stephenrichter@xxxxxxxxx>
wrote:

> I have code in an RPG program that uses SQL to create a table in qtemp  as
> another table with data:
> CREATE TABLE  qtemp/abc as ( select * from  efg * ) with data
>
> but now I have changed the compile option to always compile  ACTGRP(name)
> Commit(*CHG).
>
> Tables created in QTEMP are not journaled.  So inserts into a table in
> qtemp fail when the program is running under commitment control.
>
> I can use the "with none" clause to insert a row into a table in QTEMP
> using SQL INSERT.  But CREATE TABLE AS does not support "with none"?
>
> I can use EXEC SQL SET OPTION COMMIT = *NONE.  But that removes commitment
> control from the entire program.   And besides, this CREATE TABLE AS code
> runs in a service program procedure.   Running SET OPTION COMMIT = *NONE
> appears to force all the procedures in the module to run as COMMIT *NONE.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com