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
SQL diagnostics are reported in the SQLCA:
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/db2/rbafzfielddescsqlca.htm
SQLCA fields are defined in Profound.js programs with the names in lowercase. sqlcode will be set to zero if execution was successful.
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.