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

SQL Optimizer for DB2 LUW 4.3.1 - Release Notes

Parameter Marker Conversion

Parameter Marker Conversion

For some source code, the ? is used to define parameter markers, therefore to enable unique referencing we have changed the name so it is unique within the SQL statement.

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 Topics

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択