1. In the open command, declare a global temporary table
2. Use the input rows from datastage to insert records into the global temporary table
3. Use a close command to run some sql using that temporary table.
Should this work?
When I use a Write Method of 'Write' and Write Mode of 'Append', I get the following error message:
If I change the Write Mode to 'Create' or 'Replace', will this do what I want?The table: SESSION.GTEMP1 does not exist!; you cannot use the append or truncate modes.
Will the Create/Replace specified in my Write Mode happen before or after I declare my Global Temporary Table in the 'Open command'?
(I've not tried it out, because it would also involve having to grant my db2 user permission to create tables).
Has anyone else done this sort of thing before?
Thanks