While running batch optimizer, when the job encountered a sql statement with bind variables, it stops and waits for values.
Is there a way to tell the sql optimizer to use a script for these variables or ignore them somehow without the need to enter the values for every sql statement?
1) In the Job List window, select the job.
2) Click Input Bind Variables .
3) If you do not want the datatype and value of a variable automatically replicated to all other variables that have the same name, clear the Populate same value for the same variable name checkbox.
4) In the Setting Bind Variables window, select the datatype and enter the value for each variable.
5) Click OK.
The above information can be found in the Help documentation (F1, search for Bind variables).
