Ok, what's the trick?

To use DECLARED TEMPORARY TABLES, the USER (whoever that might be) needs to be able to access some Temporary Tablespace.

So I went to the control center and used the wizard to create some. Even with the permissions for my currently logged in db2admin. The same guy who owns the schema for my stored procedure.

But my stored procedure complains that it can't find a tablespace assigned to db2admin with 4096k of space.

Now I know I'm there as db2admin and he owns the schema, and the tablespace I created has got some basic large space to spare.

So what's the trick?

Thanks,

Kimball

This is what I've found so far:

DECLARE GLOBAL TEMPORARY TABLE SLDETAIL
(
structure varchar(3),
entry varchar(6),
sequencer decimal(3),
amount decimal,
risk decimal
) not logged on commit preserve rows IN USER_TEMP_TABLES;

doesn't work, even though it is part of the syntax.

DB2 asks for the properly qualified reference to USER_TEMP_TABLES, but I cant' figure out what that is.

also, the docs say to 'issue this statement' before running the create proc:

CREATE USER TEMPORARY TABLESPACE ts1
MANAGED BY SYSTEM USING ('ts1file');

so it's still running (3min) I don't know what it's doing... actually it's a 90% at 5 minutes.

What I need to do is create a 'permanent' temporary user tablespace to be used by all the users logging into db2 to run this stored proc.

any help out there? I'm dyin here...

Thanks,

Kimball

Hi Kimball:

I solve that problem...let me know if you still need help.

Cheers...