...
- Before using this method, you must use pjs.prepare() and pass in the handle from that call.
Parameters
- The handle which is created from pjs.prepare().
- An array which has an array. Each element in the array must be another array, where the first element is the value of the parameter and the second is what parameter type it is.
[[paramA, profound.SQL_PARAM_INPUT], [paramB, profound.SQL_PARAM_INPUT]]
For each marker, there must be another element in the top array.
...
- message - The IBM i message text.
- error - The message id.
- help - The message help text.
Examples
Code Block | ||
---|---|---|
| ||
pjs.connect("*LOCAL"); var _stm = pjs.prepare("SELECT * FROM PJSTEST/PRODUCTSP WHERE PRID = ?"); pjs.bindParameters(_stm, [ [gPrid, pjs.SQL_PARAM_INPUT] ]); |