Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4 - 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

SQL Scanner Conversions Overview

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating