サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for SAP ASE 3.8 - Release Notes

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

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択