EXEC SQL CREATE USER TEMPORARY TABLESPACE

Hi,

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.

I've tried to adapt IBM's sample code (http://tinyurl.com/3c4pgn)
for that use, however, the precompiler breaks on the very first
statement, this one:

EXEC SQL CREATE USER TEMPORARY TABLESPACE

....reporting that "USER" is not a valid token.


1. Does anyone know how to make this work?
2. Is there an alternative solution? I am trying to log errors
into a table, but I want the errors to remain in the table even
when program ROLLBACKs.
.