Chat now with support
Chat with Support

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes

Convert Parameter Markers

Your SQL statement may have several question marks "?" as parameter markers.

To enable unique referencing of parameter markers

Click image\B_ParameterMarkersConvert.gif from the SQL Editor pane.

This will assign a unique number to all parameter markers within the SQL statement, for example:

Original SQL

SELECT *

  FROM employee  

 WHERE emp_id = ?

    OR emp_salary < ?

 

SELECT *

  FROM employee  

 WHERE emp_id = ?1

    OR emp_salary < ?2

 

Related Documents