Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 10 Next »

This API sets an attribute of an SQL connection.

Parameters
  1. Attribute to change.
  2. New attribute value
Attributes and their valid values
  • profound.SQL_ATTR_AUTOCOMMIT
    • profound.SQL_TRUE
    • profound.SQL_FALSE

  • profound.SQL_ATTR_INFO_USERID
    • JavaScript string

  • profound.SQL_ATTR_DATE_FMT
    • 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


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.

  • No labels