I have a situation where I have a list of ID’s that reside on a SQLServer, and I need to match those ID’s to records in a table on a DB2 server. I have created a global temp table using the below code on the DB2 server, but when I try to run the import wizard to import my query from SQLServer, I can not find my temp table anywhere. I do this regularly between SQLServers that I can not open row set between and have to adjust to show the tempdb. This did not seem to be the case for DB2. I am new to DB2 so any help you can provide is appreciated.
This is how I am creating the temp table:
DECLARE GLOBAL TEMPORARY TABLE SESSION.TempTable
ID VARCHAR(21) NOT NULL
) ON COMMIT PRESERVE ROWS