Re: EXEC SQL CREATE USER TEMPORARY TABLESPACE

Priv Remeni wrote:

Sorry for the all caps in the thread title: it's not me yelling,
it's just the way the phrase is used in the C code I am having
trouble with.

I am using ILE C on V5R4 and I want to use a temporary table in
my program in order to be able to insert things into it that will
remain there independently of whether I COMMIT or ROLLBACK
elsewhere in the program.

<snip>

In addition to Chuck's comments, note that a global temp table is not persistent and is not shared across jobs, so may or may not be suitable for your requirements:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstdgtt.htm

DB2 for i5/OS does support a "No Commit" isolation level (aka "NC"), that (for example) could be specified on an INSERT, such as:
exec sql insert into <table> values() WITH NC
The WITH NC clause essentially overrides the default commit isolation level in effect for the program. If your error logging info itself has no interdependent rows (ie no transaction commit/rollback required for log info), this might be useful.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstbackup.htm
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstisol.htm

--
Karl Hanson
.