Re: Actually using commitment control and QTEMP

I had always assumed global temporary tables were just an SQL standard way
of referring to QTEMP, so it wasn't any different. I found the "with NC"
syntax at the same time as someone mentioned the global temporary tables,
and the "with NC" worked, so I didn't try the other.

Are there really performance improvements to using global temporary tables,
compared to creating a QTEMP/TBL table?



From: Alan Campin <alan0307d@xxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 12/17/2015 03:55 PM
Subject: Re: Actually using commitment control and QTEMP
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



Why are you not using Global Temporary Tables? They don't get registered
with the database and are fast.

On Thu, Dec 17, 2015 at 12:50 PM, <darren@xxxxxxxxx> wrote:

I think I've found something that works. I can add a "with NC", as long

as

its not part of the create table. This works:

exec sql create table QTEMP/PARTLIST like FRT;

exec sql commit;

exec sql insert into QTEMP/PARTLIST
(select *
from FRTL01 FRT
where exists
(select * from FRTL01 b
where RWRKC in (31380,31385)
and RPROD=FRT.RPROD and RTWHS=FRT.RTWHS)
) with NC;

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (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 (AS/400 and iSeries) (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.