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

On Fri, Jun 21, 2019 at 9:12 AM Rob Berendt <rob@xxxxxxxxx> wrote:

What happens if you replace
CREATE TABLE qtemp/abc...
with
DECLARE GLOBAL TEMPORARY TABLE
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/db2/rbafzdgtt.htm

very nice. that worked.

exec sql
create table qtemp/steve (
cucode char(6) not null default ' ',
ordnum decimal(9,0) not null default 0
) ;

exec sql
insert into qtemp/steve ( cucode, ordnum )
values( 'abc', 25 ) with none ;

exec sql
declare global temporary table steve2 as (
select a.* from qtemp/steve a )
with data ;

commit ;