This API sets an attribute of an SQL connection.
Parameters
- Attribute to change.
- New attribute value
Attributes and their valid values
See the IBM i SQL CLI documentation for a list of attributes and their values.
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");
//Use SQL naming convention
pjs.setConnectAttr(SQL_ATTR_DBC_SYS_NAMING, SQL_FALSE);
var c1 = pjs.allocStmt();
pjs.executeDirect(c1, "select prid from demolib.productsp order by prid");
pjs.fetchLast(c1, prid);
pjs.close(c1);
pjs.disconnect();
Requirements
This API requires the Profound.js Connector module.