Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SAP ASE 3.8 - 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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation