Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

This API binds parameters to a prepared SQL statement.

Before using this API, you must call pjs.prepare(), so that you can pass in the handle from that call.

The API can also be called in the form of a method attached to a statement handle object as follows: stmt.bindParameters(). pjs.bindParameters() can accept field names for parameter values, stmt.bindParameters() cannot.

  1. The handle created by pjs.prepare(). This parameter is omitted if the API is called as a statement method.
  2. An array of parameters 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, SQL_PARAM_INPUT], [paramB, SQL_PARAM_INPUT]]

      If an array is not used, the parameter is automatically converted to an array to be processed by the API. If the parameter type is not passed, SQL_PARAM_INPUT is assumed.

Code Block
pjs.define("productsp_out", { type: 'data structure', qualified: true, dim: 50, elements: {
  "prid": { type: "packed decimal", length: 5, decimals: 0, initValue: 105 },
  "prname": { type: "char", length: 30 },
  "prdesc": { type: "char", length: 60 }
pjs.define("searchQuery", { type: "char", length: 30 });
searchQuery = '%' + 'Garmin' + '%';
var c1 = pjs.prepare("select prid, prname, prdesc from demolib/productsp where prdesc like ? order by prid");
pjs.bindParameters(c1, [
  [searchQuery.trim(), SQL_PARAM_INPUT]
]);  // example of alternate simplified syntax: c1.bindParameters(searchQuery.trim());
pjs.fetch(c1, productsp_out, 50);


When using an IBM i database, this API requires the Profound.js Connector module.