Is it possible to create DB2 temporary tables in DB2 stage

zulfi123786 · Post by **zulfi123786** » Sun Oct 18, 2009 1:09 am

Hi,

I am using DB2 Enterprise Stage and want to create temporary tables and load them with some data before my actual query runs, i tried it using the Open command but no luck..... Can any one help???

and also if a job contains more than one DB2 stage, i guess a seperate session is created for each DB2 stage, is it possible to create only one session for a job and force all Stages to use the same session so that the temporary tables are accessed by all stages???

chulett · Post by **chulett** » Sun Oct 18, 2009 7:03 am

Can't help with the first (no DB2 anywhere I've been) but the answer to the second question is a definite 'no' regardless of DBMS.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 18, 2009 1:50 pm

Your diagnosis "with no luck" is not helpful. What actual command did you issue, did you also issue GRANT commands, and what error message (if any) was returned from the Open command?