During scanning, if the scanned SQL statement is used to create or modify a temp table these SQL statements are automatically executed if the Create Scanner Temp Table option in the Preferences is selected. The created Scanner Temp Tables are dropped after the Job finishes scanning.
For example:
select EMP_ID,
EMP_NAME
into #a
from EMPLOYEE
select *
from #a
select EMP_ID,
EMP_NAME
into #a
from EMPLOYEE
select *
from #2
The DDL for creating the temporary tables displays under Scanner Temp Table in the bottom pane. This includes the DDL found by the SQL Scanner or the DDL used to create the User-Defined Temp Table.
select EMP_ID,
EMP_NAME
into #a
from EMPLOYEE
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center