Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The handle which is created from pjs.prepare().
  2. 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.

Return Value

None.

Exception Handling

If there is a problem creating the data area, an Error will be thrown with the following properties:

  • message - The IBM i message text.
  • error - The message id.
  • help - The message help text.
Examples
Code Block
languagejavascript
pjs.connect("*LOCAL");  
var _stm = pjs.prepare("SELECT * FROM PJSTEST/PRODUCTSP WHERE PRID = ?");
pjs.bindParameters(_stm, [
  [gPrid, pjs.SQL_PARAM_INPUT]
]);