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


  FROM employee  

 WHERE emp_id = ?

    OR emp_salary < ?



  FROM employee  

 WHERE emp_id = ?1

    OR emp_salary < ?2


Related Documents