Page Comparison

...

The API can also be called in the form of a method attached to a statement object as follows: stmt.setAttr().

Parameters

1. The handle which is created from pjs.prepare() or pjs.allocStmt(). This parameter is omitted if the API is called as a statement method.

2. Attribute to change

3. New attribute value

Attributes and their valid values

• profound.SQL_ATTR_CURSOR_SENSITIVITY

  • profound.SQL_INSENSITIVE

  • profound.SQL_SENSITIVE

• preciseDecimal

  • Set to string or boolean value before executing query to override global preciseDecimal setting for statement result sets.

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.

  
  
  

Examples

Called directly

var c1 = pjs.allocStmt(); 
pjs.setStmtAttr(c1, SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE);
// ...

Called as a method

var c1 = pjs.prepare("SELECT * FROM productsp WHERE prid = ?");
c1.setAttr(SQL_ATTR_CURSOR_SCROLLABLE, SQL_TRUE);
// ...

Requirements

This API requires the Profound.js Connector module.