Set and change This API sets an attribute of a an SQL connection.
Parameters
| 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. |
- Attribute to change.
- New attribute value
Attributes and their valid values
...
- profound.SQL_FMT_ISO
- profound.SQL_FMT_USA
- profound.SQL_FMT_EUR
- profound.SQL_FMT_JIS
- profound.SQL_FMT_MDY
- profound.SQL_FMT_DMY
- profound.SQL_FMT_JUL
- profound.SQL_FMT_JOB
Return Value
None
Exception Handling
An Error instance will be thrown with the following properties:
...
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
| Code Block | ||
|---|---|---|
| ||
//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.