DSXchange

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???

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.

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?