SQL Optimizer for SAP ASE 3.9.1 - Release Notes

Into Clause Conversion

For some front-end tools, the INTO clause of an SQL statement may be used for variable assignment which violates the syntax of the INTO clause. Therefore, an INTO clause in the SQL statement with more than one variable will be commented.

For example:

Original SQL statement

select EMP_ID,

EMP_NAME       

into a, b  

from EMPLOYEE  

After conversion

select EMP_ID,

EMP_NAME         /* into a, b */ /* Commented by SQL Optimizer*/

from EMPLOYEE  

Related Topic

SQL Conversion Overview