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???
Is it possible to create DB2 temporary tables in DB2 stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.