Prepare a statement to execute.
- You will only need to prepare a statement if you have markers in the WHERE clause within the statement. You can use pjs.executeDirect() otherwise.
- You must connect to the database first.
Parameters
- SQL statement string.
Return Value
This method will return a handle which much be used again in other statements.
Exception Handling
An Error instance will be thrown with the following properties:
- message - The IBM i message text.
- error - The message id.
- help - The message help text.
Example
pjs.connect("*LOCAL");
var _stm = pjs.prepare("SELECT * FROM PJSTEST/PRODUCTSP WHERE PRID like ?");
Requirements
This API requires the Profound.js Connector module.