During scanning, if the scanned SQL statement is used to create or modify a temporary table, the SQL will be automatically executed if the Create Scanner Temp Table checkbox in the Options is selected. The created Scanner Temp Tables will be dropped after the job has finished scanning.
declare global temporary table session.ABC
like EMPLOYEE
on commit delete rows
not logged
select *
from session.ABC
After scanning in the Scanned SQL Viewer, you will see the SQL statement displayed in the Scanned SQL pane as:
select *
from session.ABC
The DDL for creating the temporary tables is displayed under the Scanner Temp Table tab in the SQL Information. This includes the DDL found by the SQL Scanner or the DDL used to create the User-Defined Temp Table.
declare global temporary table session.ABC
like EMPLOYEE
on commit delete rows
not logged
Note: To create or modify temporary tables SQL Scanner, the logon user needs the following privileges:
Connection to DB2 LUW 7 or above
USE privilege on the USER TEMPORARY table space or SYSADM or DBADM authority.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center