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

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