...
You only need to prepare a statement if you have parameter markers, identified by ? (question mark) symbols, in the SQL. You may use pjs.executeDirect() otherwise.
Parameter
| Info |
|---|
This API can accept an optional database connection definition object to select between multiple database connections. To select the database connection, call pjs.getDB() and pass the result as the first parameter, followed by the parameters documented below. If a database connection definition object is not passed, the default database connection is used. |
- SQL statement string
- The SQL statement must be valid for the database you are using
Return Value
This method will return a handle which much be used again in other statements.
...
| Code Block | ||
|---|---|---|
| ||
var table = "productsp";
pjs.define("productsp_out", { type: 'data structure', qualified: true, dim: 50, extName: table });
pjs.define("searchQuery", { type: "char", length: 30 });
pjs.clear(productsp_out);
searchQuery = '%' + 'Garmin' + '%';
var c1 = pjs.prepare("SELECT * FROM productsp WHERE prdesc LIKE ? ORDER BY prid");
c1.bindParameters(searchQuery.trim());
c1.execute();
pjs.fetch(c1, productsp_out, 50);
c1.close(); |
Requirements
This When using an IBM i database, this API requires the Profound.js Connector module.