Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Scanning Source Code with Temp Tables

Scan Source Code with Temp Tables

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:

Source Code

select EMP_ID,

EMP_NAME

into #a

from EMPLOYEE

 

select *

from #a

After scanning

SQL1

select EMP_ID,

EMP_NAME

into #a

from EMPLOYEE

SQL2

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating