Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

External Parameter Conversion

For some source code, ? is used to define external parameters, therefore to enable unique referencing, the SQL Scanner adds a number so that each parameter has a unique name within the SQL statement.

For example:

Original SQL statement

SELECT EMP_ID

FROM EMPLOYEE

WHERE EMP_ID = ?

AND EMP_NAME = ?

After conversion

SELECT EMP_ID

FROM EMPLOYEE

WHERE EMP_ID = ?1

AND EMP_NAME = ?2

 

Related Topic

SQL Conversion Overview

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating