Versions Compared

Key

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

...

  1. The handle created by pjs.prepare().
  2. An array of arraysparameters for each SQL parameter marker. Each element in the array must be another array, where the first element is the value of the parameter and the second is the parameter type. For example:
    • [[paramA, profound.SQL_PARAM_INPUT], [paramB, profound.SQL_PARAM_INPUT]]
      For each marker, there must be another element in the top array.
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]
]);

...