idb-pconnector - npm Package Compare versions

Comparing version 0.1.1 to 1.0.0

docs/dbPool.md

@@ -1,65 +0,5 @@
-# Class: DBPoolConnection
-Constructor to instantiate a new instance of a DBPoolConnection class given the `poolIndex` and `config`
+# Class: DBPool
 
-
-## Constructor: DBPoolConnection(poolIndex , config)
-**Parameters**
-
-**poolIndex**: `number`, An identifier for debug purposes
-
-**config**: `object`, Object includes `database`
-
-
-### DBPoolConnection.newConnection()
-
-Instantiates a new Connection instance
-
-
-### DBPoolConnection.newStatement()
-
-Instantiates a new Statement instance for the Connection if one is not set and returns it.
-Otherwise will close the previous Statement and return a new Statement.
-
-**Returns**: `Statement`, new statement from the connection
-
-### DBPoolConnection.getStatement()
-
-Constructor to instantiate a new instance of a DBPoolConnection class given the `poolIndex` and `config`
-
-**Returns**: `Statement`, returns the handle to the Statement.
-
-### DBPoolConnection.close()
-
-Closes the connection
-
-
-### DBPoolConnection.detach(retire)
-
-Creates a new statement
-
-**Parameters**
-
-**retire**: `boolean`, If true, retires the connection so it can be removed from the pool
-
-**Returns**: `boolean | object`, True if retiring, or the detached connection
-
-### DBPoolConnection.isAvailable()
-
-Constructor to instantiate a new instance of a DBPoolConnection class given the `poolIndex` and `config`
-
-**Returns**: `boolean`, true if the connection is available , false if the connection is unavailable.
-
-### DBPoolConnection.setAvailable(availability)
-
-Constructor to instantiate a new instance of a DBPoolConnection class given the `poolIndex` and `config`
-
-**Parameters**
-
-**availability**: `boolean`, true or false to set the availability flag of the connection.
-
-- - -
-
-# Class: DBPool
 Manages a list of DBPoolConnection instances.
-Constructor to instantiate a new instance of a DBPool class given the `database` and `config`
+Constructor to instantiate a new instance of a DBPool class given the `database` and `config`.
 
@@ -69,20 +9,22 @@
 
-**Parameters**
+**Parameters**:
 
-**database**: `object`, Object includes the `url`(database name) defaults to *LOCAL, `username`, and `password`. `username` and `password` assumed blank if not specified with non-local URL.
+- **database**: `object` includes the `url` defaults to "*LOCAL", `username`, and `password`. Username & password is optional when connecting to "*LOCAL".
 
-**config**: `object` , Object includes the `incrementSize` and `debug`. IncrementSize sets the desired size of the DBPool. If none specified, defaults to 8 connections. Setting debug = true will display message logs.
+- **config**: `object` with the properties: `incrementSize` and `debug`. IncrementSize is a integer `Number` that sets the desired size of the DBPool defaults to 8 connections. Debug is a `boolean` setting it to true will display verbose output to the console, defaults to false.
 
+**Example**: [Here](#markdown-header-dbpool)
 
-### DBPool.createConnection(index)
 
+## DBPool.createConnection(index)
+
 Instantiates a new instance of DBPoolConnection with an `index` and appends it to the pool.
 Assumes the database of the pool when establishing the connection.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, An identifier to id the connection for debug purposes.
+**index**: `Number` an optional identifier to id the connection for debug purposes.
 
 
-### DBPool.detachAll()
+## DBPool.detachAll()
 
@@ -92,92 +34,93 @@ Frees all connections in the pool (Sets "Available" back to true for all)
 
-**Returns**: `boolean`, - true if all were detached successfully
+**Returns**: `true` if all were detached successfully or will return `String` error message if an error occurred.
 
-### DBPool.retireAll()
+## DBPool.retireAll()
 
 Retires (Removes) all connections from being used again
 
-**Returns**: `boolean`, - true if all were retired successfully
+**Returns**: `true` if all were retired successfully, or will return `String` error message if an error occurred.
 
-### DBPool.detach(connection)
+## DBPool.detach(connection)
 
-Frees a connection (Returns the connection "Available" back to true)
-closes any statements and gets a new statement.
+Frees a connection (Returns the connection "Available" back to true) closes any statements and gets a new statement.
 
-**Parameters**
+**Parameters**:
 
-**connection**: `DBPoolConnection`, Frees a connection (Returns the connection "Available" back to true)
+- **connection**: `DBPoolConnection`, Frees a connection (Returns the connection "Available" back to true)
 closes any statements and gets a new statement.
 
 
-### DBPool.retire(connection)
+**Returns**: `String` error message if an error occurred.
 
-Retires a connection from being used and removes it from the pool
+## DBPool.retire(connection)
 
-**Parameters**
+Retires a connection from being used and removes it from the pool.
 
-**connection**: `DBPoolConnection`, Retires a connection from being used and removes it from the pool
+**Parameters**:
 
+- **connection**: `DBPoolConnection`, Retires a connection from being used and removes it from the pool
 
-### DBPool.attach()
+**Returns**: `String` error message if an error occurred.
 
+## DBPool.attach()
+
 Finds and returns the first available Connection.
 
-**Returns**: `DBPoolConnection`, - one connection from the DBPool.
+**Returns**: `DBPoolConnection` connection from the `DBPool`.
 
-### DBPool.log(message)
 
-Internal function used to log debug information.
 
-**Parameters**
+## DBPool.runSql(sql)
 
-**message**: `string`, the message to log.
+An aggregate to run an sql statement, just provide the sql to run. Note that Stored Procedures should use the prepareExecute() aggregate instead.
 
+**Parameters**:
 
-### DBPool.runSql(sql)
+- **sql**: `String`, the sql statement to execute.
 
-Shorthand to exec a statement , just provide the sql to run.
+**Returns**: 
+- `Array` if the sql returns a result set it is returned as an `Array` of `Objects`.
 
-**Parameters**
+- If no result set is available `null` is returned. Caller should check if `null` is returned.
 
-**sql**: `string`, the sql statement to execute.
+**Example**: [Here](#markdown-header-runsql)
 
-**Returns**: `array`, - if the SQL returns a result set it is returned as an array of objects.
-else if no result set is available null is returned. caller should check if null is returned.
 
-### DBPool.prepareExecute(sql, params)
+## DBPool.prepareExecute(sql, params, options)
 
-Shortcut to prepare ,bind, and execute. Just provide the sql and the params as an array.
+Aggregate to prepare, bind, and execute. Just provide the sql and the optional params as an array.
 
-**Parameters**
+An `options` object can now be used for global configuration. This is used to set options on all the parameters within the `params` Array. Currently, the input output indicator `io` is the only available option to set. This will override the default which is `'both'`.
 
-**sql**: `string`, the sql to prepare , include parameter markers (?, ?, ...)
+**Example**: `prepareExecute(sql, parrams, {io: 'in'})`
 
-**params**: `array`, an optional array of values to bind. order of the values in the array must match the
-order of the desired parameter marker in the sql string.
+Also parameters can be customized at an individual level by passing an object within the parameter list.
 
-**Returns**: `array`, - if the Prepared SQL returns result set it is returned as an array of objects.
-else null will be returned indicating that there is no result set.
+The object format: `{value: "string | Number | boolean | null" , io: "in | out | both" , asClob: "true | false"}`
 
-### DBPool.formatParams(params)
+`value` is the only required property others will fallback to defaults.
 
-Internal helper function to format params and set Param Indicator & Bind Type
+If you want to bind a string as a clob you can add `asClob: true` property to the object.
 
-**Parameters**
+**Example**: `{value: 'your string', asClob: true, io: 'in'}`
 
-**params**: `array`, an array of values to bind. type of values should be (string , number , or null)
+**Parameters**::
 
-**Returns**: `array`, - an array of bounded params properly formatted to use.
+- **sql**: `string`, the sql to prepare , include parameter markers (?, ?, ...)
 
+- **params**: `array`, an optional array of values to bind. order of the values in the array must match the order of the desired parameter marker in the sql string.
+- **options**: `Object` with config options to set for all parameters. The format can be: `{io: 'in' | 'out' | 'both'}` where `io` can be set to either the `String` `'in'`, `'out'`, or `'both'`. Indicating that the parameter is an input, output, or inout parameter.
 
+**Returns**: `Object` in the format: `{resultSet: [], outputParams: []}` if the Prepared SQL returns result set it is returned as an array of objects or if the Prepared SQL returns output parameters it is returned as an array of objects. 
 
-* * *
+- If neither were available `null` will be returned indicating that there is no result set or output parameters. Caller should check if `null` is returned.
 
+**Example**: [Here](#markdown-header-prepareexecute)
 
+## DBPool.setConnectionAttribute(attribute)
 
+Sets the connection attribute for each a Connection in the pool.
 
+**Parameters**:
 
-
-
-
-
-
+- **attribute**: `Object` in the format {attribute: Number (integer), value: Number (integer) | String}

docs/main.md

@@ -0,117 +1,142 @@
+# **API Documentation**
+
 # Class: Connection
 
+## Constructor: Connection()
+The Connection constructor accepts an optional `db` parameter which can be used to connect to the database. If `db` is not provided make sure to use the `connect()` before performing any other methods.
 
-## Connection.connect(dbname)
+**Parameters**:
+- **db**: `Object` includes the properties `url` location of the database, use '*LOCAL' for a local database, `username` for the database user, `password` for the databse user. If connecting using '*LOCAL' it is not required to pass the `username` & `password` but ensure that the the object contains `url: '*LOCAL'`.
 
+## Connection.connect(url, username, password)
+
 Establishes a Connection to the database.
 
-**Parameters**
+**Parameters**:
 
-**dbname**: `string`, the name of the database to connect to. If a name is not specified, the dbname is defaulted to "*LOCAL".
+- **url**: `String` the url of the database to connect to. If a url is not specified, it defaults to "*LOCAL".
 
-**Returns**: `object`, - the dbConn Object with an established connection.
+- **username**: `String` the username for the database user.
 
+- **password**: `String` the password for the database user.
+
+**Returns**: `Object` the Connection object with an established connection.
+
 ## Connection.getStatement()
 
-returns a Statement Object initialized to the current dbConn Connection.
+Returns a Statement Object initialized to the current Connection. Ensure that the Connection object is connected first before attempting to  get a Statement. The [isConnected](#markdown-header-connectionisconnected) method can be used to check if the Connection object is currently connected
 
-**Returns**: `object`, - a new Statement initialized with the current dbconn.
+**Returns**: `Object` a new Statement initialized with the current Connection.
 
 ## Connection.close()
 
-closes the Connection to the DB and frees the connection object.
+Closes the Connection to the DB and frees the connection object.
 
-**Returns**: `Promise`, - Promise object represents the closure of the Connection.
+**Returns**: `Promise` when resolved will return `true` indicating successful closure, or the promise will be rejected.
 
 ## Connection.disconn()
 
-disconnects an existing connection to the database.
+Disconnects an existing connection to the database.
 
-**Returns**: `Promise`, - Promise object represents the disconnect of the Connection.
+**Returns**: `Promise` when resolved will return `true` indicating successful disconnection, or the promise will be rejected.
 
 ## Connection.debug(choice)
 
-prints more detailed info if choice = true. Turned off by setting choice = false.
+Prints verbose detailed info to the console if choice is set `true`. Can be turned off by setting choice = false.
 
-**Parameters**
+**Parameters**:
 
-**choice**: `boolean`, the option either true or false to turn on debugging.
+- **choice**: `boolean` the option either true or false to turn debug on/off.
 
-**Returns**: `Promise`, - Promise object represents the debug method being set to the choice specified.
+**Returns**: `Promise` when resolved will return `true | false` indicating the current state of debug, or the promise will be rejected.
 
 ## Connection.getConnAttr(attribute)
 
-if connection attribute exists should return type String or Int depending on the attribute type
+If the `attribute` exists will return the current value of the attribute.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, if connection attribute exists should return type String or Int depending on the attribute type
+- **attribute**: `Number` the attribute to retrieve the current value from.
 
-**Returns**: `Promise`, - Promise object represents the the current settings for the specified connection attribute.
+**Returns**: `Promise` when resolved  will return the specified connection attribute settings either `Number | String`, or the promise will be rejected.
 
 **Link**:
-[Further Documentation ON Connection Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw\_ibm\_i_73/cli/rzadpfnsconx.htm)
+[Connection Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw\_ibm\_i_73/cli/rzadpfnsconx.htm)
+
+## Connection.isConnected()
+
+Checks if the Connection object is currentl connected to the database.
+
+**Returns**: `true` or `false` indicating if the Connection object is currently connected.
+
 ## Connection.setConnAttr(attribute, value)
 
-Sets the ConnAttr , Attribute should be INT.
+Sets the the value for a given `attribute`.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, the attribute to be set refer to the getConAttr example to view available attributes.
+- **attribute**: `Number` the attribute to be set.
 
-**value**: `string | number`, the value to set the attribute to. Can be String or Int depending the attribute.
+- **value**: `string | number` the value to set the attribute to.
 
-**Returns**: `Promise`, - Promise object represents the execution of the setConnAttr().
+**Returns**: `Promise` when resolved will return `true` indicating success or the promise will be rejected.
 
-### Connection.validStmt(sql)
+## Connection.validStmt(sql)
 
 Checks if the given SQL is valid and interprets vendor escape clauses.
 
-**Parameters**
+**Parameters**:
 
-**sql**: `string`, the sql string to be validated.
+- **sql**: `String`, the sql string to be validated.
 
-**Returns**: `Promise`, - Promise object represents the transformed SQL string that is seen by the data source.
+**Returns**: `Promise` when resolved will return the transformed sql string that is seen by the data source, or the promise will be rejected.
 
-- - -
+
 # Class: Statement
 
+## Constructor: Statement(connection)
 
+**Parameters**:
+
+- **connection**: optional `dbconn` Object for the connection to use. If you don't pass a `connection` one will be implicitly created and used for the statement.
+
 ## Statement.bindParam(params)
 
-associates parameter markers in an SQL statement to app variables.
+Associates parameter markers in an sql statement to application variables.
 
-**Parameters**
+**Parameters**:
 
-**params**: `Array`, this should be an Array of the parameter list. Each parameter element will also be an Array with 3 values ( Value, In/out Type ,Indicator ).
+- **params**: `Array` the parameter list in order corresponding to the parameter markers. Each parameter element will also be an Array with 3 values ( value, in/out type ,indicator ).
 
-**Returns**: `Promise`, - Promise object represents the execution of bindParam().
 
-**Example**:
-```js
-statement.bindParam([
-        [2099, dba.SQL_PARAM_INPUT, dba.SQL_BIND_NUMERIC],
-        ['Node.Js', dba.SQL_PARAM_INPUT,dba.SQL_BIND_CHAR]
-		]);
-		
-        IN/OUT TYPE CAN BE:
-            1.SQL_PARAM_INPUT   
-            2.SQL_PARAM_OUTPUT
-            3.SQL_PARAM_INPUT_OUTPUT
-        INDICATORS CAN BE: 
-            1. SQL_BIND_CLOB
-            2. SQL_BIND_CHAR
-            3. SQL_BIND_NUMERIC
-            4. SQL_BIND_NULL_DATA
 ```
+       IN/OUT TYPE CAN BE:
+          - SQL_PARAM_INPUT or PARAM_INPUT
+          - SQL_PARAM_OUTPUT or PARAM_OUTOUT
+          - SQL_PARAM_INPUT_OUTPUT or INPUT_OUTPUT
+          
+       INDICATORS CAN BE:
+           - SQL_BIND_CHAR or BIND_STRING
+           - SQL_BIND_INT or BIND_INT
+           - SQL_BIND_NUMERIC or BIND_NUMERIC
+           - SQL_BIND_BINARY or BIND_BINARY
+           - SQL_BIND_BLOB or BIND_BINARY
+           - SQL_BIND_CLOB or BIND_CLOB
+           - SQL_BIND_BOOLEAN or BIND_BOOLEAN
+           - SQL_BIND_NULL_DATA or BIND_NULL
+      
+```
+These values are constants which are attached to object returned when you `const idbp = require('idb-pconnector')`.
 
-## Statement.bind(params)
+You can access said values like so : `idbp.PARAM_INPUT`
 
-Shorthand for bindParam
+**Returns**: `Promise` when resolved there is no return value but if an error occurred the promise will be rejected.
 
-**Parameters**
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
-**params**: `Array`, this should be an Array of the parameter list. Each parameter element will also be an Array with 3 values ( Value, In/Out Type ,Indicator ).
+## Statement.bind(params)
 
+Shorthand equivalent of bindParam(params) above.
 
+
 ## Statement.close()
@@ -121,147 +146,137 @@
 
-**Returns**: `Promise`, - Promise object represents the execution of close().
+**Returns**: `Promise` when resolved will return true indicating successful closure, or the promise will be rejected.
 
 ## Statement.closeCursor()
 
-closes the cursor associated with the dbstmt object and discards any pending results.
+Closes the cursor associated with the Statement object and discards any pending results.
 
-**Returns**: `Promise`, - Promise object represents the execution of closeCursor().
+**Returns**: `Promise` when resolved will return true indicating successful closure, or the promise will be rejected.
 
 ## Statement.commit()
 
-adds all changes to the database that have been made on the connection since connect time.
+Adds all changes to the database that have been made on the connection since connect time.
 
-**Returns**: `Promise`, - Promise object represents the execution of Commit().
+**Returns**: `Promise` when resolved will return true indicating successful commit, or the promise will be rejected.
 
-## Statement.exec(sqlString)
+## Statement.exec(sql)
 
-performs action of given SQL String. The exec() method does not work with stored procedure calls use execute() instead.
+Directly executes a given sql String. The exec() method does not work with stored procedure use execute() method instead.
 
-**Parameters**
+**Parameters**:
 
-**sqlString**: `string`, performs action of given SQL String. The exec() method does not work with stored procedure calls use execute() instead.
+- **sql**: `String` the sql command to execute.
 
-**Returns**: , the result set as an array.
-**Returns**: `Promise`, - Promise object represents the result set from the execution of exec().
+**Returns**: `Promise` when resolved if available will return the result set as an `Array` , or the promise will be rejected.
 
+**Example**: [Here](#markdown-header-exec)
+
 ## Statement.execute()
 
-Runs a statement that was successfully prepared using prepare().
-Use execute() for stored procedure calls.
+Runs a statement that was successfully prepared using prepare(). Used to call stored procedure calls. Important to note that execute() will return output parameters and not a result set. If available you can retrieve the result set by either running fetch() or fetchAll().
 
-**Returns**: `Promise`, - Promise object represents the execution of execute().
+**Returns**: `Promise` when resolved if available will return output parameters as an `Array`, or the promise will be rejected.
 
-**Example**:
-```js
-- Calling a stored Procedure that returns a result set with execute() & displaying the result set.
-     	
- 	   try{
-     	 let db = require('idb-pconnector');
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
-     	 // note that that calling the new Statement() without the DbConn as a parameter
-     	 // creates a new connection implicitly and uses that for the Statement.
-     	 let statement = new db.Statement(),
-		   sql = 'CALL MYSCHEMA.SAMPLEPROC';
-		   
-     	 await statement.prepare(sql);
-     	 await statement.execute();
-     	 let result = await statement.fetchAll();
-     	 console.log(`Result is\n: ${JSON.stringify(result)}`);
-        }
-        catch(error){
-     	 console.log(error.stack);
-		}
+## Statement.fetch()
 
-- Insert Example With Prepare , Binding Parameter , and Execution
- 	 
- 	  try {
-     	 let db = require('idb-pconnector');
-    
-     	 // note that that calling the new Statement() without the DbConn as a parameter
-     	 // creates a new connection implicitly and uses that for the Statement.
-		 let statement = new db.Statement();
-		  
-     	 await statement.prepare('INSERT INTO MYSCHEMA.MYTABLE VALUES (?,?)');
-     	 await statement.bind([ [2018,db.SQL_PARAM_INPUT,db.SQL_BIND_NUMERIC], [null ,db.PARM_TYPE_INPUT, dba.SQL_BIND_NULL_DATA ] ]);
-		 await dbStmt.execute();
+If a result set exists, fetch() will retrieve a row from the result set. The row is an `Object`. Fetch can be continuously run until there is no data. If there is no data to be fetched null will be returned indicating the end of the result set.
 
-     	 let result = await dbStmt.exec('SELECT * FROM MYSCHEMA.MYTABLE');
-     	 console.log(`Select results: \nJSON.stringify(result)`);
-        }
-        catch (error) {
-     	 console.log(error.stack);
-        }
-```
+**Returns**: `Promise` when resolved will return an `Object` representing the row that was retrieved. If there is no data remaining to be fetched in the result set `null` will be returned indicating the end of the result set. Or if there was never a result set to be fetched the promise will be rejected.
 
-## Statement.fetch()
+**Example Fetching a result set until there is no more data to fetch**:
 
-if a result exists , retrieves a row from the result set
+```javascript
+const {Connection} = require('idb-pconnector');
 
-**Returns**: `Promise | null`, - Promise object represents the row that was retrieved from the execution of fetch(). If there is no data to be fetched null will be returned indicating the end of the result set.
+async function fetch(){
+  try {
+    let sql = 'SELECT * FROM QIWS.QCUSTCDT',
+    connection = new Connection();
 
+    connection.debug(true);
+    let statement = connection.connect().getStatement();
+
+    await statement.prepare(sql);
+    await statement.execute();
+    let result = await statement.fetch();
+
+    while (result !== null ){
+      console.log(`Fetch result:\n ${JSON.stringify(result)}`);
+      result = await statement.fetch();
+    }
+  } catch(error){
+    	console.log(error.stack);
+      }
+}
+
+fetch();
+
+```
+
 ## Statement.fetchAll()
 
-if a result set exists , retrieves all the rows of data from the result set.
+If a result set exists , fetchAll() retrieves all the rows from the result set.
 
-**Returns**: `Promise`, - Promise object represents the the an array containing the result that was retrieved from the execution of fetchAll().
+**Returns**: `Promise` when resolved will return an `Array` of `Objects` representing the result set if its available, or the promise will be rejected.
 
 ## Statement.fieldName(index)
 
-requires an int index parameter. If a valid index is provided, returns the name of the indicated field.
+If a valid index is provided, returns the name of the indicated field.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the String that was retrieved from the execution of fieldName().
+**Returns**: `Promise` when resolved will return `String` name of the field or the promise will be rejected.
 
 ## Statement.fieldNullable(index)
 
-requires an int index parameter. If a valid index is provided, returns t/f if the indicated field can be Null
+If a valid index is provided, returns `true | false` if the indicated field can be set to `null`.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the boolean that was retrieved from the execution of fieldNullable().
+**Returns**: `Promise` when resolved will return `true | false` or the promise will be rejected.
 
 ## Statement.fieldPrecise(index)
 
-requires an int index parameter. If a valid index is provided, returns the precision of the indicated field
+If a valid index is provided, returns the precision of the indicated field
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldPrecisie().
+**Returns**: `Promise` when resolved will return `Number` or the promise will be rejected.
 
 ## Statement.fieldScale(index)
 
-requires an int index parameter. If a valid index is provided, returns the scale of the indicated column
+If a valid index is provided, returns the scale of the indicated column.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldScale().
+**Returns**: `Promise` when resolved will return a `Number` or the promise will be rejected.
 
 ## Statement.fieldType(index)
 
-requires an int index parameter. If a valid index is provided, returns the data type of the indicated field
+If a valid index is provided, returns the data type of the indicated field.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldType().
+**Returns**: `Promise` when resolved will return a `Number` or the promise will be rejected.
 
 ## Statement.fieldWidth(index)
 
-requires an int index parameter. If a valid index is provided, returns the field width of the indicated field
+If a valid index is provided, returns the field width of the indicated field
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldWidth().
+**Returns**: `Promise`, when resolved will return a `Number` or the promise will be rejected.
 
@@ -273,42 +288,41 @@ ## Statement.getStmtAttr(attribute)
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, the statement attribute to get
+- **attribute**: `Number`the attribute to retrieve the current value from.
 
-**Returns**: `Promise`, Promise object represents the the String | Number that was retrieved from the execution of getStmtAttr().
+**Returns**: `Promise`, when resolved will return the specified connection attribute settings as a `Number | String`, or the promise will be rejected.
 
-**Link**:
-[Further Documentaion On Statement Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/cli/rzadpfnsstma.htm)
+**Link**: [Statement Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/cli/rzadpfnsstma.htm)
+
 ## Statement.nextResult()
 
-Determines whether there is more information available on the statement
+Determines whether there is more information available on the statement handle that has been associated with a stored procedure that is returning result sets.
 
-**Returns**: `Promise`, - Promise object represents the execution of nextResult().
+After completely processing the first result set, the application can call nextResult() to determine if another result set is available. If the current result set has unfetched rows, nextResult() discards them by closing the cursor.
 
+**Returns**: `Promise` when resolve `true` will be returned indicating there is another result set or `null` is returned indicating there was not another result set. If an error occurred while processing the promise is rejected.
+
 ## Statement.numFields()
 
-if a result is available , retrieves number of fields contained in result.
+If a result set is available , numFields() retrieves number of fields contained in the result set.
 
-**Returns**: `Promise`, - Promise object represents the Number returned from the execution of numFields().
+**Returns**: `Promise` when resolved `Number` is returned or the promise is rejected.
 
 ## Statement.numRows()
 
-if a query was performed ,retrieves number of rows that were affected by a query
+If a query was performed, retrieves the number of rows that were affected by a query.
 
-**Returns**: `Promise`, - Promise object represents the Number returned from the execution of numRows().
+**Returns**: `Promise` when resolved will return a `Number` or the promise is rejected.
 
-## Statement.prepare(sqlString)
+## Statement.prepare(sql)
 
-If valid SQL is provided . prepares SQL and sends it to the DBMS, if the input SQL Statement cannot be prepared error is thrown.
+If valid sql is provided . prepares the sql and sends it to the DBMS, if the input sql Statement cannot be prepared error is thrown.
 
-**Parameters**
+**Parameters**:
 
-**sqlString**: `string`, the SQL string to be prepared.
+- **sql**: `String`, the SQL string to be prepared.
 
-**Returns**: `Promise`, - Promise object represents the the execution of prepare().
+**Returns**: `Promise` when resolved no value is returned but if an error occurred the promise is rejected.
 
-**Example**:
-```js
-- view the examples located at the execute() method.
-```
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
@@ -319,14 +333,16 @@ ## Statement.rollback()
 
+**Returns**: `Promise` when resolved  `true` is returned or promise is rejected.
 
+
 ## Statement.setStmtAttr(attribute, value)
 
-if a valid attribute and value is provided , sets StmtAttr indicate Attribute. Refer to the example @getStmtAttr for a list of valid Statement Attributes.
+Sets the the value for a given attribute.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, must be an int INT.
+- **attribute**: `Number` the attribute to be set.
 
-**value**: `string | number`, can String or Int depending on the attribute
+- **value**: `string | number` the value to set the attribute to.
 
-**Returns**: `Promise`, - Promise object represents the execution of setStmtAttr().
+- **Returns**: `Promise` when resolved will return `true` indicating success or the promise will be rejected..
 
@@ -337,28 +353,15 @@ ## Statement.stmtError(hType, recno)
 
-**Parameters**
+**Parameters**:
 
-**hType**: `number`, indicates the handler type of diagnostic information.
+- **hType**: `Number`, indicates the handler type of diagnostic information.
 
-**recno**: `number`, indicates which error should be retrieved. The first error record is number 1.
+- **recno**: `Number`, indicates which error should be retrieved. The first error record is number 1.
 
-**Returns**: `Promise`, - Promise object represents Number retrieved from the execution of stmtError().
-
-**Example**:
-```js
+```
 hType can be following values:
-	  SQL_HANDLE_ENV:  Retrieve the environment diagnostic information
- 	  SQL_HANDLE_DBC:  Retrieve the connection diagnostic information
-      SQL_HANDLE_STMT: Retrieve the statement diagnostic information
+ 	 SQL_HANDLE_ENV:  Retrieve the environment diagnostic information
+	 SQL_HANDLE_DBC:  Retrieve the connection diagnostic information
+     SQL_HANDLE_STMT: Retrieve the statement diagnostic information
 ```
 
-* * *
-
-
-
-
-
-
-
-
-
-
+**Returns**: `Promise` when resolved returns `String` or the promise is rejected.

lib/dbPool.js

@@ -19,3 +19,4 @@ const idbp = require('./idb-pconnector');
       {
-        database
+        database,
+        options
       } = config;
@@ -27,6 +28,7 @@
     };
+    me.options = options || {
+      debug :false
+    };
     me.poolIndex = poolIndex;
     me.available = true;
-    me.SQL_PARAM_INPUT = idbp.SQL_PARAM_INPUT;
-    me.SQL_HANDLE_STMT = idbp.SQL_HANDLE_STMT;
     me.newConnection();
@@ -46,11 +48,17 @@ me.newStatement();
       } = me.database,
-      isLocal = url === '*LOCAL';
+      {
+        debug
+      } = me.options;
 
     me.connection = new idbp.Connection();
-    if (isLocal) {
+
+    if (!username && !password) {
+      // should be connecting '*LOCAL',that's the only way to connect w/o username, password.
       me.connection.connect(url);
     } else {
-      // Username and Password are assumed blank if not specified with non-local URL.
+      // connecting to remote url or username, password was provided.
       me.connection.connect(url, username, password);
     }
+    // if debug = true, turn it on @ the idb level.
+    debug ? me.connection.debug(true) : debug = false;
   }
@@ -145,4 +153,4 @@
    * Constructor to instantiate a new instance of a DBPool class given the `database` and `config`
-   * @param {object} database - Object includes the `url`, `username`, and `password`. `username` and `password` assumed blank if not specified with non-local URL.
-   * @param {object} config - Object includes the `incrementSize` and `debug`. Setting debug = true will display message logs.
+   * @param {object} database - Object includes the `url`, `username`, and `password`.
+   * @param {object} config - Object includes the `incrementSize` and `debug`.
    * @constructor
@@ -194,3 +202,5 @@ */
       database: me.database,
-      debug: me.debug
+      options: {
+        debug: me.debug
+      }
     }));
@@ -369,6 +379,8 @@ me.log(`Connection ${index} created`);
    * order of the desired parameter marker in the sql string.
-   * @return {array} - if the Prepared SQL returns result set it is returned as an array of objects.
-   * else null will be returned indicating that there is no result set.
+   * @return {object} - In the Format: {resultSet: [], outputParams: []}
+   * if the Prepared SQL returns result set it is returned as an array of objects.
+   * if the Prepared SQL returns output parameters it is returned as an array of objects/
+   * else null will be returned indicating that there is no result set or outputParams.
    */
-  async prepareExecute(sql = '', params = []) {
+  async prepareExecute(sql = '', params = [], options = {}) {
     let me = this,
@@ -378,3 +390,4 @@ connection = me.attach(),
       resultSet = [],
-      outParams = [];
+      outParams = [],
+      data = {};
 
@@ -386,3 +399,3 @@ try {
         me.log(`Binding Parameters...`);
-        await statement.bindParam(me.formatParams(params));
+        await statement.bindParam(me.setupParams(params, options));
       }
@@ -409,6 +422,12 @@ outParams = await statement.execute();
     }
-    if (!resultSet.length){
+    if (!resultSet.length && !outParams.length){
       return null;
     }
-    return resultSet;
+    if (resultSet.length){
+      data.resultSet = resultSet;
+    }
+    if (outParams.length){
+      data.outputParams = outParams;
+    }
+    return data;
   }
@@ -419,26 +438,30 @@
    * @param {array} params - an array of values to bind. type of values should be (string , number , or null)
+   * @param {object} options - an object with config options to set for all parameters.
+   * Currently, the input/output indicatior is the only available option to set. {io: in | out | both}.
+   * This will overide the default which is to bind as 'both'.
    * @returns {array} - an array of bounded params properly formated to use.
    */
-  formatParams(params) {
+  setupParams(params, options) {
     let boundParams = [],
       me = this,
-      parameter,
-      SQL_PARAM_INPUT_OUTPUT = idbp.SQL_PARAM_INPUT_OUTPUT;
+      {io} = options,
+      parameter;
 
+    io = io || 'both';
+
     for ( parameter of params  ){
-      if (typeof parameter === 'string'){ //String
-        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_CHAR]);
-      } else if (typeof parameter === 'number') { //Number
-        let indicator;
-        Number.isInteger(parameter) ? indicator = idbp.SQL_BIND_INT : indicator = idbp.SQL_BIND_NUMERIC;
-        boundParams.push( [parameter, SQL_PARAM_INPUT_OUTPUT, indicator] );
-      } else if (typeof parameter === null) { //Null
-        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_NULL_DATA]);
-      } else if (Buffer.isBuffer(parameter)){ //Binary/blob
-        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_BINARY]);
-      } else if (typeof parameter === 'boolean'){ //Boolean
-        boundParams.push([parameter, SQL_PARAM_INPUT_OUTPUT, idbp.SQL_BIND_BOOLEAN]);
+      if (typeof parameter === 'object'){
+        let {value, asClob = false} = parameter;
+
+        if (typeof value === 'undefined' ){
+          throw Error('The parameter object must define a value property');
+        }
+        // assigning the value of io from the parameter object to the io variable declared before.
+        // if io from parameter object is undefined default back to value of io from before.
+        ({io = io} = parameter);
+        // allows customization of io for an individual parameter.
+        me.formatParams(boundParams, value, {io, asClob});
       } else {
-        me.log(`Parameter that caused error was ${JSON.stringify(parameter)}`);
-        throw TypeError('Parameters to bind should be String, Number, null, or Buffer');
+        // when just passing values but would like to overide default io (INPUT_OUTPUT)
+        me.formatParams(boundParams, parameter, {io});
       }
@@ -449,4 +472,63 @@ }
   }
+  /**
+   *Internal helper function to format params and set Param Indicator & Bind Type
+   * @param {array} boundParams - the array to push the formatted parmeter.
+   * @param {object} options - an object with config options {io: in | out | both, asClob: true | false}.
+   */
+  formatParams(boundParams, value, options){
+    let {io, asClob} = options;
+
+    io = idbp[`SQL_PARAM_${io === 'both' ? 'INPUT_OUTPUT': (io.toUpperCase() + 'PUT')}`];
+
+    if (typeof value === 'string'){ //String
+      if (asClob){ //as clob
+        boundParams.push([value, io, idbp.BIND_CLOB]);
+      } else { // as string
+        boundParams.push([value, io, idbp.BIND_STRING]);
+      }
+    } else if (typeof value === 'number') { //Number
+      boundParams.push([value, io, idbp[`SQL_BIND_${Number.isInteger(value) ? 'INT' : 'NUMERIC'}`]]);
+    } else if (value === null) { //Null
+      boundParams.push([value, io, idbp.SQL_BIND_NULL_DATA]);
+    } else if (Buffer.isBuffer(value)){ //Binary/blob
+      boundParams.push([value, io, idbp.SQL_BIND_BINARY]);
+    } else if (typeof value === 'boolean'){ //Boolean
+      boundParams.push([value, io, idbp.SQL_BIND_BOOLEAN]);
+    } else {
+      me.log(`Parameter that caused error was ${JSON.stringify(value)}`);
+      throw TypeError('Parameters to bind should be String, Number, null, boolean or Buffer');
+    }
+  }
+
+  /**
+   * Sets the connection attribute for each a DBPoolConnection in the pool.
+   * @param {object} connectionAttribute with the properties {attribute: integer, value: integer | String}
+   */
+  async setConnectionAttribute(connectionAttribute = null){
+    let me = this;
+
+    if (!connectionAttribute instanceof Object){
+      throw Error('Connection Attribute should be an Object');
+    }
+
+    let {attribute = null, value = null} = connectionAttribute;
+
+    //it is possbile for value to equal 0 which would evaluate to false incorrectly.
+    if (attribute !== null && value !== null){
+      for ( let poolConnection of me.connections){
+        //from the poolConnection get access to the underlying idb-p Connection() object.
+        let {connection} = poolConnection;
+
+        await connection.setConnAttr(attribute, value)
+          .catch( () => {
+            throw Error('Setting Connection Attributes failed, check your parameters');
+          });
+      }
+    } else {
+      throw Error('Provide a valid Connection Attribute and Value');
+    }
+  }
+
 }
 exports.DBPool = DBPool;
 exports.DBPoolConnection = DBPoolConnection;

lib/idb-pconnector.js

@@ -1,2 +0,2 @@
-const dba = require('idb-connector');
+const idb = require('idb-connector');
 
@@ -8,7 +8,14 @@ /**
 class Connection {
-  constructor() {
-    let me = this;
+  constructor(db = {url: '', username: '', password: ''}) {
+    let me = this,
+      {url, username, password} = db,
+      isLocal = url === '*LOCAL';
 
-    me.dbconn = new dba.dbconn();
-    console.log(`constructed, dbconn=${JSON.stringify(me.dbconn)}`);
+    me.dbconn = new idb.dbconn();
+
+    if (isLocal && !username && !password){
+      me.connect();
+    } else if (url && username && password){
+      me.connect(url, username, password);
+    }
   }
@@ -18,11 +25,18 @@
      * Establishes a Connection to the database.
-     * @param {string} [database] - The name of the database to connect to. Defaults to "*LOCAL".
+     * @param {string} [url] - The url of the database to connect to, which Defaults to '*LOCAL'.
+     * @param {string} [username] - The user name for the database user.
+     * @param {string} [password] - The password for the database user.
      * @returns {object} - The dbConn Object with an established connection.
      * @memberof Connection
      */
-  connect(database = '*LOCAL') {
+  connect(url = '*LOCAL', username = '', password = '') {
     let me = this;
 
-    me.dbconn.conn(database);
-
+    //connecting to '*LOCAL' and username, password was not provided.
+    if (url && !username && !password){
+      me.dbconn.conn(url);
+    } else {
+      //connecting to remote url or username, password was provided.
+      me.dbconn.conn(url, username, password);
+    }
     return me;
@@ -179,2 +193,9 @@ }
   }
+  /**
+     * Checks if the Connection object is connected to the db.
+     * @returns {boolean} - true or false indicating if the Connection object is currently connected.
+     */
+  isConnected(){
+    return this.dbconn.isConnected();
+  }
 }
@@ -192,3 +213,3 @@
     me.dbc = dbconn;
-    me.stmt = new dba.dbstmt(me.dbc);
+    me.stmt = new idb.dbstmt(me.dbc);
   }
@@ -200,4 +221,4 @@
      * @example dbStmt.bindParam([
-     *              [2099, dba.SQL_PARAM_INPUT, dba.SQL_BIND_NUMERIC],
-     *              ['Node.Js', dba.SQL_PARAM_INPUT,dba.SQL_BIND_CHAR]
+     *              [2099, idb.SQL_PARAM_INPUT, idb.SQL_BIND_NUMERIC],
+     *              ['Node.Js', idb.SQL_PARAM_INPUT,idb.SQL_BIND_CHAR]
      *          ]);
@@ -321,7 +342,7 @@ * IN/OUT TYPE CAN BE:
 
-     const dba = require('idb-pconnector');
+     const idb = require('idb-pconnector');
      try {
 		  // note that that calling the new Statement() without the DbConn as a parameter
 		  // creates a new connection automatically and uses that for the Statement.
-		  let dbStmt = new dba.Statement();,
+		  let dbStmt = new idb.Statement();,
 		      sql = 'call QIWS.sampleProc',
@@ -340,7 +361,7 @@ response;
 
-     const dba = require('idb-pconnector');
+     const idb = require('idb-pconnector');
      try {
 		  // note that that calling the new Statement() without the DbConn as a parameter
 		  // creates a new connection automatically and uses that for the Statement.
-		  let dbStmt = new dba.Statement(),
+		  let dbStmt = new idb.Statement(),
 		      response;
@@ -350,4 +371,4 @@
 		  await dbStmt.bind([
-		      [2018, dba.SQL_PARAM_INPUT, dba.SQL_BIND_NUMERIC],
-		      [null, dba.PARM_TYPE_INPUT, dba.SQL_BIND_NULL_DATA]
+		      [2018, idb.SQL_PARAM_INPUT, idb.SQL_BIND_NUMERIC],
+		      [null, idb.PARM_TYPE_INPUT, idb.SQL_BIND_NULL_DATA]
 		  ]);
@@ -389,5 +410,5 @@ await dbStmt.execute();
       stmt.fetch((result, rc) => {
-        if (rc === dba.SQL_SUCCESS ){ //dba.SQL_SUCCESS == 0
+        if (rc === idb.SQL_SUCCESS ){ //idb.SQL_SUCCESS == 0
           resolve(result);
-        } else if (rc === dba.SQL_NO_DATA_FOUND){
+        } else if (rc === idb.SQL_NO_DATA_FOUND){
           resolve(null); //Indicates the end of the Data Set
@@ -701,807 +722,819 @@ }
 exports.SQL_BIND_BOOLEAN = 5;
-exports.SQL_BIND_BINARY = dba.SQL_BINARY;
-exports.SQL_BIND_BLOB = dba.SQL_BLOB;
+exports.SQL_BIND_BINARY = idb.SQL_BINARY;
+exports.SQL_BIND_BLOB = idb.SQL_BLOB;
+//alias variables
+exports.BIND_CLOB = idb.BIND_CLOB;
+exports.BIND_STRING = idb.BIND_STRING;
+exports.BIND_INT = idb.BIND_INT;
+exports.BIND_NULL = idb.BIND_NULL;
+exports.BIND_NUMERIC = idb.BIND_NUMERIC;
+exports.BIND_BOOLEAN = idb.BIND_BOOLEAN;
+exports.BIND_BINARY = idb.BIND_BINARY;
+exports.BIND_BLOB = idb.BIND_BLOB;
+exports.PARAM_INPUT = idb.SQL_PARAM_INPUT;
+exports.PARAM_OUTPUT = idb.SQL_PARAM_OUTPUT;
+exports.PARAM_INPUT_OUTPUT = idb.SQL_PARAM_INPUT_OUTPUT;
 
 // export variables from original idb-connector
-exports.SQL_FALSE = dba.SQL_FALSE;
-exports.SQL_TRUE = dba.SQL_TRUE;
-exports.SQL_NTS = dba.SQL_NTS;
-exports.SQL_SQLSTATE_SIZE = dba.SQL_SQLSTATE_SIZE;
-exports.SQL_MAX_MESSAGE_LENGTH = dba.SQL_MAX_MESSAGE_LENGTH;
-exports.SQL_MAX_OPTION_STRING_LENGTH = dba.SQL_MAX_OPTION_STRING_LENGTH;
+exports.SQL_FALSE = idb.SQL_FALSE;
+exports.SQL_TRUE = idb.SQL_TRUE;
+exports.SQL_NTS = idb.SQL_NTS;
+exports.SQL_SQLSTATE_SIZE = idb.SQL_SQLSTATE_SIZE;
+exports.SQL_MAX_MESSAGE_LENGTH = idb.SQL_MAX_MESSAGE_LENGTH;
+exports.SQL_MAX_OPTION_STRING_LENGTH = idb.SQL_MAX_OPTION_STRING_LENGTH;
 
-exports.SQL_SUCCESS = dba.SQL_SUCCESS;
-exports.SQL_SUCCESS_WITH_INFO = dba.SQL_SUCCESS_WITH_INFO;
-exports.SQL_NO_DATA_FOUND = dba.SQL_NO_DATA_FOUND;
-exports.SQL_NEED_DATA = dba.SQL_NEED_DATA;
-exports.SQL_NO_DATA = dba.SQL_NO_DATA;
-exports.SQL_ERROR = dba.SQL_ERROR;
-exports.SQL_INVALID_HANDLE = dba.SQL_INVALID_HANDLE;
-exports.SQL_STILL_EXECUTING = dba.SQL_STILL_EXECUTING;
+exports.SQL_SUCCESS = idb.SQL_SUCCESS;
+exports.SQL_SUCCESS_WITH_INFO = idb.SQL_SUCCESS_WITH_INFO;
+exports.SQL_NO_DATA_FOUND = idb.SQL_NO_DATA_FOUND;
+exports.SQL_NEED_DATA = idb.SQL_NEED_DATA;
+exports.SQL_NO_DATA = idb.SQL_NO_DATA;
+exports.SQL_ERROR = idb.SQL_ERROR;
+exports.SQL_INVALID_HANDLE = idb.SQL_INVALID_HANDLE;
+exports.SQL_STILL_EXECUTING = idb.SQL_STILL_EXECUTING;
 
-exports.SQL_CLOSE = dba.SQL_CLOSE;
-exports.SQL_DROP = dba.SQL_DROP;
-exports.SQL_UNBIND = dba.SQL_UNBIND;
-exports.SQL_RESET_PARAMS = dba.SQL_RESET_PARAMS;
+exports.SQL_CLOSE = idb.SQL_CLOSE;
+exports.SQL_DROP = idb.SQL_DROP;
+exports.SQL_UNBIND = idb.SQL_UNBIND;
+exports.SQL_RESET_PARAMS = idb.SQL_RESET_PARAMS;
 
-exports.SQL_C_DEFAULT = dba.SQL_C_DEFAULT;
+exports.SQL_C_DEFAULT = idb.SQL_C_DEFAULT;
 
-exports.SQL_COMMIT = dba.SQL_COMMIT;
-exports.SQL_ROLLBACK = dba.SQL_ROLLBACK;
-exports.SQL_COMMIT_HOLD = dba.SQL_COMMIT_HOLD;
-exports.SQL_ROLLBACK_HOLD = dba.SQL_ROLLBACK_HOLD;
-exports.SQL_SAVEPOINT_NAME_RELEASE = dba.SQL_SAVEPOINT_NAME_RELEASE;
-exports.SQL_SAVEPOINT_NAME_ROLLBACK = dba.SQL_SAVEPOINT_NAME_ROLLBACK;
+exports.SQL_COMMIT = idb.SQL_COMMIT;
+exports.SQL_ROLLBACK = idb.SQL_ROLLBACK;
+exports.SQL_COMMIT_HOLD = idb.SQL_COMMIT_HOLD;
+exports.SQL_ROLLBACK_HOLD = idb.SQL_ROLLBACK_HOLD;
+exports.SQL_SAVEPOINT_NAME_RELEASE = idb.SQL_SAVEPOINT_NAME_RELEASE;
+exports.SQL_SAVEPOINT_NAME_ROLLBACK = idb.SQL_SAVEPOINT_NAME_ROLLBACK;
 
-exports.SQL_DRIVER_COMPLETE = dba.SQL_DRIVER_COMPLETE;
-exports.SQL_DRIVER_COMPLETE_REQUIRED = dba.SQL_DRIVER_COMPLETE_REQUIRED;
-exports.SQL_DRIVER_NOPROMPT = dba.SQL_DRIVER_NOPROMPT;
-exports.SQL_DRIVER_PROMPT = dba.SQL_DRIVER_PROMPT;
+exports.SQL_DRIVER_COMPLETE = idb.SQL_DRIVER_COMPLETE;
+exports.SQL_DRIVER_COMPLETE_REQUIRED = idb.SQL_DRIVER_COMPLETE_REQUIRED;
+exports.SQL_DRIVER_NOPROMPT = idb.SQL_DRIVER_NOPROMPT;
+exports.SQL_DRIVER_PROMPT = idb.SQL_DRIVER_PROMPT;
 
-exports.SQL_ACTIVE_CONNECTIONS = dba.SQL_ACTIVE_CONNECTIONS;
-exports.SQL_MAX_DRIVER_CONNECTIONS = dba.SQL_MAX_DRIVER_CONNECTIONS;
-exports.SQL_MAX_CONCURRENT_ACTIVITIES = dba.SQL_MAX_CONCURRENT_ACTIVITIES;
-exports.SQL_ACTIVE_STATEMENTS = dba.SQL_ACTIVE_STATEMENTS;
-exports.SQL_PROCEDURES = dba.SQL_PROCEDURES;
-exports.SQL_DRIVER_NAME = dba.SQL_DRIVER_NAME;
-exports.SQL_ODBC_API_CONFORMANCE = dba.SQL_ODBC_API_CONFORMANCE;
-exports.SQL_ODBC_SQL_CONFORMANCE = dba.SQL_ODBC_SQL_CONFORMANCE;
-exports.SQL_DBMS_NAME = dba.SQL_DBMS_NAME;
-exports.SQL_DBMS_VER = dba.SQL_DBMS_VER;
-exports.SQL_DRIVER_VER = dba.SQL_DRIVER_VER;
-exports.SQL_IDENTIFIER_CASE = dba.SQL_IDENTIFIER_CASE;
-exports.SQL_IDENTIFIER_QUOTE_CHAR = dba.SQL_IDENTIFIER_QUOTE_CHAR;
-exports.SQL_MAX_COLUMN_NAME_LEN = dba.SQL_MAX_COLUMN_NAME_LEN;
-exports.SQL_MAX_CURSOR_NAME_LEN = dba.SQL_MAX_CURSOR_NAME_LEN;
-exports.SQL_MAX_OWNER_NAME_LEN = dba.SQL_MAX_OWNER_NAME_LEN;
-exports.SQL_MAX_SCHEMA_NAME_LEN = dba.SQL_MAX_SCHEMA_NAME_LEN;
-exports.SQL_MAX_TABLE_NAME_LEN = dba.SQL_MAX_TABLE_NAME_LEN;
-exports.SQL_MAX_COLUMNS_IN_GROUP_BY = dba.SQL_MAX_COLUMNS_IN_GROUP_BY;
-exports.SQL_MAX_COLUMNS_IN_ORDER_BY = dba.SQL_MAX_COLUMNS_IN_ORDER_BY;
-exports.SQL_MAX_COLUMNS_IN_SELECT = dba.SQL_MAX_COLUMNS_IN_SELECT;
-exports.SQL_MAX_COLUMNS_IN_TABLE = dba.SQL_MAX_COLUMNS_IN_TABLE;
-exports.SQL_MAX_TABLES_IN_SELECT = dba.SQL_MAX_TABLES_IN_SELECT;
-exports.SQL_COLUMN_ALIAS = dba.SQL_COLUMN_ALIAS;
-exports.SQL_DATA_SOURCE_NAME = dba.SQL_DATA_SOURCE_NAME;
-exports.SQL_DATASOURCE_NAME = dba.SQL_DATASOURCE_NAME;
-exports.SQL_MAX_COLUMNS_IN_INDEX = dba.SQL_MAX_COLUMNS_IN_INDEX;
-exports.SQL_PROCEDURE_TERM = dba.SQL_PROCEDURE_TERM;
-exports.SQL_QUALIFIER_TERM = dba.SQL_QUALIFIER_TERM;
-exports.SQL_TXN_CAPABLE = dba.SQL_TXN_CAPABLE;
-exports.SQL_OWNER_TERM = dba.SQL_OWNER_TERM;
-exports.SQL_DATA_SOURCE_READ_ONLY = dba.SQL_DATA_SOURCE_READ_ONLY;
-exports.SQL_DEFAULT_TXN_ISOLATION = dba.SQL_DEFAULT_TXN_ISOLATION;
-exports.SQL_MULTIPLE_ACTIVE_TXN = dba.SQL_MULTIPLE_ACTIVE_TXN;
-exports.SQL_QUALIFIER_NAME_SEPARATOR = dba.SQL_QUALIFIER_NAME_SEPARATOR;
-exports.SQL_CORRELATION_NAME = dba.SQL_CORRELATION_NAME;
-exports.SQL_NON_NULLABLE_COLUMNS = dba.SQL_NON_NULLABLE_COLUMNS;
-exports.SQL_DRIVER_ODBC_VER = dba.SQL_DRIVER_ODBC_VER;
-exports.SQL_GROUP_BY = dba.SQL_GROUP_BY;
-exports.SQL_ORDER_BY_COLUMNS_IN_SELECT = dba.SQL_ORDER_BY_COLUMNS_IN_SELECT;
-exports.SQL_OWNER_USAGE = dba.SQL_OWNER_USAGE;
-exports.SQL_QUALIFIER_USAGE = dba.SQL_QUALIFIER_USAGE;
-exports.SQL_QUOTED_IDENTIFIER_CASE = dba.SQL_QUOTED_IDENTIFIER_CASE;
-exports.SQL_MAX_ROW_SIZE = dba.SQL_MAX_ROW_SIZE;
-exports.SQL_QUALIFIER_LOCATION = dba.SQL_QUALIFIER_LOCATION;
-exports.SQL_MAX_CATALOG_NAME_LEN = dba.SQL_MAX_CATALOG_NAME_LEN;
-exports.SQL_MAX_STATEMENT_LEN = dba.SQL_MAX_STATEMENT_LEN;
-exports.SQL_SEARCH_PATTERN_ESCAPE = dba.SQL_SEARCH_PATTERN_ESCAPE;
-exports.SQL_OUTER_JOINS = dba.SQL_OUTER_JOINS;
-exports.SQL_LIKE_ESCAPE_CLAUSE = dba.SQL_LIKE_ESCAPE_CLAUSE;
-exports.SQL_CATALOG_NAME = dba.SQL_CATALOG_NAME;
-exports.SQL_DESCRIBE_PARAMETER = dba.SQL_DESCRIBE_PARAMETER;
-exports.SQL_STRING_FUNCTIONS = dba.SQL_STRING_FUNCTIONS;
-exports.SQL_NUMERIC_FUNCTIONS = dba.SQL_NUMERIC_FUNCTIONS;
-exports.SQL_CONVERT_FUNCTIONS = dba.SQL_CONVERT_FUNCTIONS;
-exports.SQL_TIMEDATE_FUNCTIONS = dba.SQL_TIMEDATE_FUNCTIONS;
-exports.SQL_SQL92_PREDICATES = dba.SQL_SQL92_PREDICATES;
-exports.SQL_SQL92_VALUE_EXPRESSIONS = dba.SQL_SQL92_VALUE_EXPRESSIONS;
-exports.SQL_AGGREGATE_FUNCTIONS = dba.SQL_AGGREGATE_FUNCTIONS;
-exports.SQL_SQL_CONFORMANCE = dba.SQL_SQL_CONFORMANCE;
-exports.SQL_CONVERT_CHAR = dba.SQL_CONVERT_CHAR;
-exports.SQL_CONVERT_NUMERIC = dba.SQL_CONVERT_NUMERIC;
-exports.SQL_CONVERT_DECIMAL = dba.SQL_CONVERT_DECIMAL;
-exports.SQL_CONVERT_INTEGER = dba.SQL_CONVERT_INTEGER;
-exports.SQL_CONVERT_SMALLINT = dba.SQL_CONVERT_SMALLINT;
-exports.SQL_CONVERT_FLOAT = dba.SQL_CONVERT_FLOAT;
-exports.SQL_CONVERT_REAL = dba.SQL_CONVERT_REAL;
-exports.SQL_CONVERT_DOUBLE = dba.SQL_CONVERT_DOUBLE;
-exports.SQL_CONVERT_VARCHAR = dba.SQL_CONVERT_VARCHAR;
-exports.SQL_CONVERT_LONGVARCHAR = dba.SQL_CONVERT_LONGVARCHAR;
-exports.SQL_CONVERT_BINARY = dba.SQL_CONVERT_BINARY;
-exports.SQL_CONVERT_VARBINARY = dba.SQL_CONVERT_VARBINARY;
-exports.SQL_CONVERT_BIT = dba.SQL_CONVERT_BIT;
-exports.SQL_CONVERT_TINYINT = dba.SQL_CONVERT_TINYINT;
-exports.SQL_CONVERT_BIGINT = dba.SQL_CONVERT_BIGINT;
-exports.SQL_CONVERT_DATE = dba.SQL_CONVERT_DATE;
-exports.SQL_CONVERT_TIME = dba.SQL_CONVERT_TIME;
-exports.SQL_CONVERT_TIMESTAMP = dba.SQL_CONVERT_TIMESTAMP;
-exports.SQL_CONVERT_LONGVARBINARY = dba.SQL_CONVERT_LONGVARBINARY;
-exports.SQL_CONVERT_INTERVAL_YEAR_MONTH = dba.SQL_CONVERT_INTERVAL_YEAR_MONTH;
-exports.SQL_CONVERT_INTERVAL_DAY_TIME = dba.SQL_CONVERT_INTERVAL_DAY_TIME;
-exports.SQL_CONVERT_WCHAR = dba.SQL_CONVERT_WCHAR;
-exports.SQL_CONVERT_WLONGVARCHAR = dba.SQL_CONVERT_WLONGVARCHAR;
-exports.SQL_CONVERT_WVARCHAR = dba.SQL_CONVERT_WVARCHAR;
-exports.SQL_CONVERT_BLOB = dba.SQL_CONVERT_BLOB;
-exports.SQL_CONVERT_CLOB = dba.SQL_CONVERT_CLOB;
-exports.SQL_CONVERT_DBCLOB = dba.SQL_CONVERT_DBCLOB;
-exports.SQL_CURSOR_COMMIT_BEHAVIOR = dba.SQL_CURSOR_COMMIT_BEHAVIOR;
-exports.SQL_CURSOR_ROLLBACK_BEHAVIOR = dba.SQL_CURSOR_ROLLBACK_BEHAVIOR;
-exports.SQL_POSITIONED_STATEMENTS = dba.SQL_POSITIONED_STATEMENTS;
-exports.SQL_KEYWORDS = dba.SQL_KEYWORDS;
-exports.SQL_CONNECTION_JOB_NAME = dba.SQL_CONNECTION_JOB_NAME;
-exports.SQL_USER_NAME = dba.SQL_USER_NAME;
-exports.SQL_DATABASE_NAME = dba.SQL_DATABASE_NAME;
-exports.SQL_CONVERT_DECFLOAT7 = dba.SQL_CONVERT_DECFLOAT7;
-exports.SQL_CONVERT_DECFLOAT16 = dba.SQL_CONVERT_DECFLOAT16;
-exports.SQL_CONVERT_DECFLOAT34 = dba.SQL_CONVERT_DECFLOAT34;
-exports.SQL_LOCK_TYPES = dba.SQL_LOCK_TYPES;
-exports.SQL_POS_OPERATIONS = dba.SQL_POS_OPERATIONS;
+exports.SQL_ACTIVE_CONNECTIONS = idb.SQL_ACTIVE_CONNECTIONS;
+exports.SQL_MAX_DRIVER_CONNECTIONS = idb.SQL_MAX_DRIVER_CONNECTIONS;
+exports.SQL_MAX_CONCURRENT_ACTIVITIES = idb.SQL_MAX_CONCURRENT_ACTIVITIES;
+exports.SQL_ACTIVE_STATEMENTS = idb.SQL_ACTIVE_STATEMENTS;
+exports.SQL_PROCEDURES = idb.SQL_PROCEDURES;
+exports.SQL_DRIVER_NAME = idb.SQL_DRIVER_NAME;
+exports.SQL_ODBC_API_CONFORMANCE = idb.SQL_ODBC_API_CONFORMANCE;
+exports.SQL_ODBC_SQL_CONFORMANCE = idb.SQL_ODBC_SQL_CONFORMANCE;
+exports.SQL_DBMS_NAME = idb.SQL_DBMS_NAME;
+exports.SQL_DBMS_VER = idb.SQL_DBMS_VER;
+exports.SQL_DRIVER_VER = idb.SQL_DRIVER_VER;
+exports.SQL_IDENTIFIER_CASE = idb.SQL_IDENTIFIER_CASE;
+exports.SQL_IDENTIFIER_QUOTE_CHAR = idb.SQL_IDENTIFIER_QUOTE_CHAR;
+exports.SQL_MAX_COLUMN_NAME_LEN = idb.SQL_MAX_COLUMN_NAME_LEN;
+exports.SQL_MAX_CURSOR_NAME_LEN = idb.SQL_MAX_CURSOR_NAME_LEN;
+exports.SQL_MAX_OWNER_NAME_LEN = idb.SQL_MAX_OWNER_NAME_LEN;
+exports.SQL_MAX_SCHEMA_NAME_LEN = idb.SQL_MAX_SCHEMA_NAME_LEN;
+exports.SQL_MAX_TABLE_NAME_LEN = idb.SQL_MAX_TABLE_NAME_LEN;
+exports.SQL_MAX_COLUMNS_IN_GROUP_BY = idb.SQL_MAX_COLUMNS_IN_GROUP_BY;
+exports.SQL_MAX_COLUMNS_IN_ORDER_BY = idb.SQL_MAX_COLUMNS_IN_ORDER_BY;
+exports.SQL_MAX_COLUMNS_IN_SELECT = idb.SQL_MAX_COLUMNS_IN_SELECT;
+exports.SQL_MAX_COLUMNS_IN_TABLE = idb.SQL_MAX_COLUMNS_IN_TABLE;
+exports.SQL_MAX_TABLES_IN_SELECT = idb.SQL_MAX_TABLES_IN_SELECT;
+exports.SQL_COLUMN_ALIAS = idb.SQL_COLUMN_ALIAS;
+exports.SQL_DATA_SOURCE_NAME = idb.SQL_DATA_SOURCE_NAME;
+exports.SQL_DATASOURCE_NAME = idb.SQL_DATASOURCE_NAME;
+exports.SQL_MAX_COLUMNS_IN_INDEX = idb.SQL_MAX_COLUMNS_IN_INDEX;
+exports.SQL_PROCEDURE_TERM = idb.SQL_PROCEDURE_TERM;
+exports.SQL_QUALIFIER_TERM = idb.SQL_QUALIFIER_TERM;
+exports.SQL_TXN_CAPABLE = idb.SQL_TXN_CAPABLE;
+exports.SQL_OWNER_TERM = idb.SQL_OWNER_TERM;
+exports.SQL_DATA_SOURCE_READ_ONLY = idb.SQL_DATA_SOURCE_READ_ONLY;
+exports.SQL_DEFAULT_TXN_ISOLATION = idb.SQL_DEFAULT_TXN_ISOLATION;
+exports.SQL_MULTIPLE_ACTIVE_TXN = idb.SQL_MULTIPLE_ACTIVE_TXN;
+exports.SQL_QUALIFIER_NAME_SEPARATOR = idb.SQL_QUALIFIER_NAME_SEPARATOR;
+exports.SQL_CORRELATION_NAME = idb.SQL_CORRELATION_NAME;
+exports.SQL_NON_NULLABLE_COLUMNS = idb.SQL_NON_NULLABLE_COLUMNS;
+exports.SQL_DRIVER_ODBC_VER = idb.SQL_DRIVER_ODBC_VER;
+exports.SQL_GROUP_BY = idb.SQL_GROUP_BY;
+exports.SQL_ORDER_BY_COLUMNS_IN_SELECT = idb.SQL_ORDER_BY_COLUMNS_IN_SELECT;
+exports.SQL_OWNER_USAGE = idb.SQL_OWNER_USAGE;
+exports.SQL_QUALIFIER_USAGE = idb.SQL_QUALIFIER_USAGE;
+exports.SQL_QUOTED_IDENTIFIER_CASE = idb.SQL_QUOTED_IDENTIFIER_CASE;
+exports.SQL_MAX_ROW_SIZE = idb.SQL_MAX_ROW_SIZE;
+exports.SQL_QUALIFIER_LOCATION = idb.SQL_QUALIFIER_LOCATION;
+exports.SQL_MAX_CATALOG_NAME_LEN = idb.SQL_MAX_CATALOG_NAME_LEN;
+exports.SQL_MAX_STATEMENT_LEN = idb.SQL_MAX_STATEMENT_LEN;
+exports.SQL_SEARCH_PATTERN_ESCAPE = idb.SQL_SEARCH_PATTERN_ESCAPE;
+exports.SQL_OUTER_JOINS = idb.SQL_OUTER_JOINS;
+exports.SQL_LIKE_ESCAPE_CLAUSE = idb.SQL_LIKE_ESCAPE_CLAUSE;
+exports.SQL_CATALOG_NAME = idb.SQL_CATALOG_NAME;
+exports.SQL_DESCRIBE_PARAMETER = idb.SQL_DESCRIBE_PARAMETER;
+exports.SQL_STRING_FUNCTIONS = idb.SQL_STRING_FUNCTIONS;
+exports.SQL_NUMERIC_FUNCTIONS = idb.SQL_NUMERIC_FUNCTIONS;
+exports.SQL_CONVERT_FUNCTIONS = idb.SQL_CONVERT_FUNCTIONS;
+exports.SQL_TIMEDATE_FUNCTIONS = idb.SQL_TIMEDATE_FUNCTIONS;
+exports.SQL_SQL92_PREDICATES = idb.SQL_SQL92_PREDICATES;
+exports.SQL_SQL92_VALUE_EXPRESSIONS = idb.SQL_SQL92_VALUE_EXPRESSIONS;
+exports.SQL_AGGREGATE_FUNCTIONS = idb.SQL_AGGREGATE_FUNCTIONS;
+exports.SQL_SQL_CONFORMANCE = idb.SQL_SQL_CONFORMANCE;
+exports.SQL_CONVERT_CHAR = idb.SQL_CONVERT_CHAR;
+exports.SQL_CONVERT_NUMERIC = idb.SQL_CONVERT_NUMERIC;
+exports.SQL_CONVERT_DECIMAL = idb.SQL_CONVERT_DECIMAL;
+exports.SQL_CONVERT_INTEGER = idb.SQL_CONVERT_INTEGER;
+exports.SQL_CONVERT_SMALLINT = idb.SQL_CONVERT_SMALLINT;
+exports.SQL_CONVERT_FLOAT = idb.SQL_CONVERT_FLOAT;
+exports.SQL_CONVERT_REAL = idb.SQL_CONVERT_REAL;
+exports.SQL_CONVERT_DOUBLE = idb.SQL_CONVERT_DOUBLE;
+exports.SQL_CONVERT_VARCHAR = idb.SQL_CONVERT_VARCHAR;
+exports.SQL_CONVERT_LONGVARCHAR = idb.SQL_CONVERT_LONGVARCHAR;
+exports.SQL_CONVERT_BINARY = idb.SQL_CONVERT_BINARY;
+exports.SQL_CONVERT_VARBINARY = idb.SQL_CONVERT_VARBINARY;
+exports.SQL_CONVERT_BIT = idb.SQL_CONVERT_BIT;
+exports.SQL_CONVERT_TINYINT = idb.SQL_CONVERT_TINYINT;
+exports.SQL_CONVERT_BIGINT = idb.SQL_CONVERT_BIGINT;
+exports.SQL_CONVERT_DATE = idb.SQL_CONVERT_DATE;
+exports.SQL_CONVERT_TIME = idb.SQL_CONVERT_TIME;
+exports.SQL_CONVERT_TIMESTAMP = idb.SQL_CONVERT_TIMESTAMP;
+exports.SQL_CONVERT_LONGVARBINARY = idb.SQL_CONVERT_LONGVARBINARY;
+exports.SQL_CONVERT_INTERVAL_YEAR_MONTH = idb.SQL_CONVERT_INTERVAL_YEAR_MONTH;
+exports.SQL_CONVERT_INTERVAL_DAY_TIME = idb.SQL_CONVERT_INTERVAL_DAY_TIME;
+exports.SQL_CONVERT_WCHAR = idb.SQL_CONVERT_WCHAR;
+exports.SQL_CONVERT_WLONGVARCHAR = idb.SQL_CONVERT_WLONGVARCHAR;
+exports.SQL_CONVERT_WVARCHAR = idb.SQL_CONVERT_WVARCHAR;
+exports.SQL_CONVERT_BLOB = idb.SQL_CONVERT_BLOB;
+exports.SQL_CONVERT_CLOB = idb.SQL_CONVERT_CLOB;
+exports.SQL_CONVERT_DBCLOB = idb.SQL_CONVERT_DBCLOB;
+exports.SQL_CURSOR_COMMIT_BEHAVIOR = idb.SQL_CURSOR_COMMIT_BEHAVIOR;
+exports.SQL_CURSOR_ROLLBACK_BEHAVIOR = idb.SQL_CURSOR_ROLLBACK_BEHAVIOR;
+exports.SQL_POSITIONED_STATEMENTS = idb.SQL_POSITIONED_STATEMENTS;
+exports.SQL_KEYWORDS = idb.SQL_KEYWORDS;
+exports.SQL_CONNECTION_JOB_NAME = idb.SQL_CONNECTION_JOB_NAME;
+exports.SQL_USER_NAME = idb.SQL_USER_NAME;
+exports.SQL_DATABASE_NAME = idb.SQL_DATABASE_NAME;
+exports.SQL_CONVERT_DECFLOAT7 = idb.SQL_CONVERT_DECFLOAT7;
+exports.SQL_CONVERT_DECFLOAT16 = idb.SQL_CONVERT_DECFLOAT16;
+exports.SQL_CONVERT_DECFLOAT34 = idb.SQL_CONVERT_DECFLOAT34;
+exports.SQL_LOCK_TYPES = idb.SQL_LOCK_TYPES;
+exports.SQL_POS_OPERATIONS = idb.SQL_POS_OPERATIONS;
 
-exports.SQL_CB_DELETE = dba.SQL_CB_DELETE;
-exports.SQL_CB_CLOSE = dba.SQL_CB_CLOSE;
-exports.SQL_CB_PRESERVE = dba.SQL_CB_PRESERVE;
+exports.SQL_CB_DELETE = idb.SQL_CB_DELETE;
+exports.SQL_CB_CLOSE = idb.SQL_CB_CLOSE;
+exports.SQL_CB_PRESERVE = idb.SQL_CB_PRESERVE;
 
-exports.SQL_SCHEMA_TERM = dba.SQL_SCHEMA_TERM;
-exports.SQL_SCHEMA_USAGE = dba.SQL_SCHEMA_USAGE;
-exports.SQL_CATALOG_LOCATION = dba.SQL_CATALOG_LOCATION;
-exports.SQL_CATALOG_TERM = dba.SQL_CATALOG_TERM;
-exports.SQL_CATALOG_USAGE = dba.SQL_CATALOG_USAGE;
-exports.SQL_CATALOG_NAME_SEPARATOR = dba.SQL_CATALOG_NAME_SEPARATOR;
-exports.SQL_OAC_NONE = dba.SQL_OAC_NONE;
-exports.SQL_OAC_LEVEL1 = dba.SQL_OAC_LEVEL1;
-exports.SQL_OAC_LEVEL2 = dba.SQL_OAC_LEVEL2;
+exports.SQL_SCHEMA_TERM = idb.SQL_SCHEMA_TERM;
+exports.SQL_SCHEMA_USAGE = idb.SQL_SCHEMA_USAGE;
+exports.SQL_CATALOG_LOCATION = idb.SQL_CATALOG_LOCATION;
+exports.SQL_CATALOG_TERM = idb.SQL_CATALOG_TERM;
+exports.SQL_CATALOG_USAGE = idb.SQL_CATALOG_USAGE;
+exports.SQL_CATALOG_NAME_SEPARATOR = idb.SQL_CATALOG_NAME_SEPARATOR;
+exports.SQL_OAC_NONE = idb.SQL_OAC_NONE;
+exports.SQL_OAC_LEVEL1 = idb.SQL_OAC_LEVEL1;
+exports.SQL_OAC_LEVEL2 = idb.SQL_OAC_LEVEL2;
 
-exports.SQL_OSC_MINIMUM = dba.SQL_OSC_MINIMUM;
-exports.SQL_OSC_CORE = dba.SQL_OSC_CORE;
-exports.SQL_OSC_EXTENDED = dba.SQL_OSC_EXTENDED;
+exports.SQL_OSC_MINIMUM = idb.SQL_OSC_MINIMUM;
+exports.SQL_OSC_CORE = idb.SQL_OSC_CORE;
+exports.SQL_OSC_EXTENDED = idb.SQL_OSC_EXTENDED;
 
-exports.SQL_QU_NOT_SUPPORTED = dba.SQL_QU_NOT_SUPPORTED;
-exports.SQL_QU_DML_STATEMENTS = dba.SQL_QU_DML_STATEMENTS;
-exports.SQL_QU_PROCEDURE_INVOCATION = dba.SQL_QU_PROCEDURE_INVOCATION;
-exports.SQL_QU_TABLE_DEFINITION = dba.SQL_QU_TABLE_DEFINITION;
-exports.SQL_QU_INDEX_DEFINITION = dba.SQL_QU_INDEX_DEFINITION;
-exports.SQL_QU_PRIVILEGE_DEFINITION = dba.SQL_QU_PRIVILEGE_DEFINITION;
-exports.SQL_QL_START = dba.SQL_QL_START;
-exports.SQL_QL_END = dba.SQL_QL_END;
+exports.SQL_QU_NOT_SUPPORTED = idb.SQL_QU_NOT_SUPPORTED;
+exports.SQL_QU_DML_STATEMENTS = idb.SQL_QU_DML_STATEMENTS;
+exports.SQL_QU_PROCEDURE_INVOCATION = idb.SQL_QU_PROCEDURE_INVOCATION;
+exports.SQL_QU_TABLE_DEFINITION = idb.SQL_QU_TABLE_DEFINITION;
+exports.SQL_QU_INDEX_DEFINITION = idb.SQL_QU_INDEX_DEFINITION;
+exports.SQL_QU_PRIVILEGE_DEFINITION = idb.SQL_QU_PRIVILEGE_DEFINITION;
+exports.SQL_QL_START = idb.SQL_QL_START;
+exports.SQL_QL_END = idb.SQL_QL_END;
 
-exports.SQL_OU_DML_STATEMENTS = dba.SQL_OU_DML_STATEMENTS;
-exports.SQL_OU_PROCEDURE_INVOCATION = dba.SQL_OU_PROCEDURE_INVOCATION;
-exports.SQL_OU_TABLE_DEFINITION = dba.SQL_OU_TABLE_DEFINITION;
-exports.SQL_OU_INDEX_DEFINITION = dba.SQL_OU_INDEX_DEFINITION;
-exports.SQL_OU_PRIVILEGE_DEFINITION = dba.SQL_OU_PRIVILEGE_DEFINITION;
+exports.SQL_OU_DML_STATEMENTS = idb.SQL_OU_DML_STATEMENTS;
+exports.SQL_OU_PROCEDURE_INVOCATION = idb.SQL_OU_PROCEDURE_INVOCATION;
+exports.SQL_OU_TABLE_DEFINITION = idb.SQL_OU_TABLE_DEFINITION;
+exports.SQL_OU_INDEX_DEFINITION = idb.SQL_OU_INDEX_DEFINITION;
+exports.SQL_OU_PRIVILEGE_DEFINITION = idb.SQL_OU_PRIVILEGE_DEFINITION;
 
-exports.SQL_TC_NONE = dba.SQL_TC_NONE;
-exports.SQL_TC_DML = dba.SQL_TC_DML;
-exports.SQL_TC_ALL = dba.SQL_TC_ALL;
-exports.SQL_TC_DDL_COMMIT = dba.SQL_TC_DDL_COMMIT;
-exports.SQL_TC_DDL_IGNORE = dba.SQL_TC_DDL_IGNORE;
-exports.SQL_TXN_READ_UNCOMMITTED_MASK = dba.SQL_TXN_READ_UNCOMMITTED_MASK;
-exports.SQL_TXN_READ_COMMITTED_MASK = dba.SQL_TXN_READ_COMMITTED_MASK;
-exports.SQL_TXN_REPEATABLE_READ_MASK = dba.SQL_TXN_REPEATABLE_READ_MASK;
-exports.SQL_TXN_SERIALIZABLE_MASK = dba.SQL_TXN_SERIALIZABLE_MASK;
+exports.SQL_TC_NONE = idb.SQL_TC_NONE;
+exports.SQL_TC_DML = idb.SQL_TC_DML;
+exports.SQL_TC_ALL = idb.SQL_TC_ALL;
+exports.SQL_TC_DDL_COMMIT = idb.SQL_TC_DDL_COMMIT;
+exports.SQL_TC_DDL_IGNORE = idb.SQL_TC_DDL_IGNORE;
+exports.SQL_TXN_READ_UNCOMMITTED_MASK = idb.SQL_TXN_READ_UNCOMMITTED_MASK;
+exports.SQL_TXN_READ_COMMITTED_MASK = idb.SQL_TXN_READ_COMMITTED_MASK;
+exports.SQL_TXN_REPEATABLE_READ_MASK = idb.SQL_TXN_REPEATABLE_READ_MASK;
+exports.SQL_TXN_SERIALIZABLE_MASK = idb.SQL_TXN_SERIALIZABLE_MASK;
 
-exports.SQL_FN_STR_CONCAT = dba.SQL_FN_STR_CONCAT;
-exports.SQL_FN_STR_UCASE = dba.SQL_FN_STR_UCASE;
-exports.SQL_FN_STR_LCASE = dba.SQL_FN_STR_LCASE;
-exports.SQL_FN_STR_SUBSTRING = dba.SQL_FN_STR_SUBSTRING;
-exports.SQL_FN_STR_LENGTH = dba.SQL_FN_STR_LENGTH;
-exports.SQL_FN_STR_POSITION = dba.SQL_FN_STR_POSITION;
-exports.SQL_FN_STR_LTRIM = dba.SQL_FN_STR_LTRIM;
-exports.SQL_FN_STR_RTRIM = dba.SQL_FN_STR_RTRIM;
-exports.SQL_POS_POSITION = dba.SQL_POS_POSITION;
-exports.SQL_POS_REFRESH = dba.SQL_POS_REFRESH;
-exports.SQL_POS_UPDATE = dba.SQL_POS_UPDATE;
-exports.SQL_POS_DELETE = dba.SQL_POS_DELETE;
-exports.SQL_POS_ADD = dba.SQL_POS_ADD;
+exports.SQL_FN_STR_CONCAT = idb.SQL_FN_STR_CONCAT;
+exports.SQL_FN_STR_UCASE = idb.SQL_FN_STR_UCASE;
+exports.SQL_FN_STR_LCASE = idb.SQL_FN_STR_LCASE;
+exports.SQL_FN_STR_SUBSTRING = idb.SQL_FN_STR_SUBSTRING;
+exports.SQL_FN_STR_LENGTH = idb.SQL_FN_STR_LENGTH;
+exports.SQL_FN_STR_POSITION = idb.SQL_FN_STR_POSITION;
+exports.SQL_FN_STR_LTRIM = idb.SQL_FN_STR_LTRIM;
+exports.SQL_FN_STR_RTRIM = idb.SQL_FN_STR_RTRIM;
+exports.SQL_POS_POSITION = idb.SQL_POS_POSITION;
+exports.SQL_POS_REFRESH = idb.SQL_POS_REFRESH;
+exports.SQL_POS_UPDATE = idb.SQL_POS_UPDATE;
+exports.SQL_POS_DELETE = idb.SQL_POS_DELETE;
+exports.SQL_POS_ADD = idb.SQL_POS_ADD;
 
-exports.SQL_FN_NUM_ABS = dba.SQL_FN_NUM_ABS;
-exports.SQL_FN_NUM_ACOS = dba.SQL_FN_NUM_ACOS;
-exports.SQL_FN_NUM_ASIN = dba.SQL_FN_NUM_ASIN;
-exports.SQL_FN_NUM_ATAN = dba.SQL_FN_NUM_ATAN;
-exports.SQL_FN_NUM_ATAN2 = dba.SQL_FN_NUM_ATAN2;
-exports.SQL_FN_NUM_CEILING = dba.SQL_FN_NUM_CEILING;
-exports.SQL_FN_NUM_COS = dba.SQL_FN_NUM_COS;
-exports.SQL_FN_NUM_COT = dba.SQL_FN_NUM_COT;
-exports.SQL_FN_NUM_EXP = dba.SQL_FN_NUM_EXP;
-exports.SQL_FN_NUM_FLOOR = dba.SQL_FN_NUM_FLOOR;
-exports.SQL_FN_NUM_LOG = dba.SQL_FN_NUM_LOG;
-exports.SQL_FN_NUM_MOD = dba.SQL_FN_NUM_MOD;
-exports.SQL_FN_NUM_SIGN = dba.SQL_FN_NUM_SIGN;
-exports.SQL_FN_NUM_SIN = dba.SQL_FN_NUM_SIN;
-exports.SQL_FN_NUM_SQRT = dba.SQL_FN_NUM_SQRT;
-exports.SQL_FN_NUM_TAN = dba.SQL_FN_NUM_TAN;
-exports.SQL_FN_NUM_PI = dba.SQL_FN_NUM_PI;
-exports.SQL_FN_NUM_RAND = dba.SQL_FN_NUM_RAND;
-exports.SQL_FN_NUM_DEGREES = dba.SQL_FN_NUM_DEGREES;
-exports.SQL_FN_NUM_LOG10 = dba.SQL_FN_NUM_LOG10;
-exports.SQL_FN_NUM_POWER = dba.SQL_FN_NUM_POWER;
-exports.SQL_FN_NUM_RADIANS = dba.SQL_FN_NUM_RADIANS;
-exports.SQL_FN_NUM_ROUND = dba.SQL_FN_NUM_ROUND;
-exports.SQL_FN_NUM_TRUNCATE = dba.SQL_FN_NUM_TRUNCATE;
+exports.SQL_FN_NUM_ABS = idb.SQL_FN_NUM_ABS;
+exports.SQL_FN_NUM_ACOS = idb.SQL_FN_NUM_ACOS;
+exports.SQL_FN_NUM_ASIN = idb.SQL_FN_NUM_ASIN;
+exports.SQL_FN_NUM_ATAN = idb.SQL_FN_NUM_ATAN;
+exports.SQL_FN_NUM_ATAN2 = idb.SQL_FN_NUM_ATAN2;
+exports.SQL_FN_NUM_CEILING = idb.SQL_FN_NUM_CEILING;
+exports.SQL_FN_NUM_COS = idb.SQL_FN_NUM_COS;
+exports.SQL_FN_NUM_COT = idb.SQL_FN_NUM_COT;
+exports.SQL_FN_NUM_EXP = idb.SQL_FN_NUM_EXP;
+exports.SQL_FN_NUM_FLOOR = idb.SQL_FN_NUM_FLOOR;
+exports.SQL_FN_NUM_LOG = idb.SQL_FN_NUM_LOG;
+exports.SQL_FN_NUM_MOD = idb.SQL_FN_NUM_MOD;
+exports.SQL_FN_NUM_SIGN = idb.SQL_FN_NUM_SIGN;
+exports.SQL_FN_NUM_SIN = idb.SQL_FN_NUM_SIN;
+exports.SQL_FN_NUM_SQRT = idb.SQL_FN_NUM_SQRT;
+exports.SQL_FN_NUM_TAN = idb.SQL_FN_NUM_TAN;
+exports.SQL_FN_NUM_PI = idb.SQL_FN_NUM_PI;
+exports.SQL_FN_NUM_RAND = idb.SQL_FN_NUM_RAND;
+exports.SQL_FN_NUM_DEGREES = idb.SQL_FN_NUM_DEGREES;
+exports.SQL_FN_NUM_LOG10 = idb.SQL_FN_NUM_LOG10;
+exports.SQL_FN_NUM_POWER = idb.SQL_FN_NUM_POWER;
+exports.SQL_FN_NUM_RADIANS = idb.SQL_FN_NUM_RADIANS;
+exports.SQL_FN_NUM_ROUND = idb.SQL_FN_NUM_ROUND;
+exports.SQL_FN_NUM_TRUNCATE = idb.SQL_FN_NUM_TRUNCATE;
 
-exports.SQL_SVE_CASE = dba.SQL_SVE_CASE;
-exports.SQL_SVE_CAST = dba.SQL_SVE_CAST;
-exports.SQL_SVE_COALESCE = dba.SQL_SVE_COALESCE;
-exports.SQL_SVE_NULLIF = dba.SQL_SVE_NULLIF;
+exports.SQL_SVE_CASE = idb.SQL_SVE_CASE;
+exports.SQL_SVE_CAST = idb.SQL_SVE_CAST;
+exports.SQL_SVE_COALESCE = idb.SQL_SVE_COALESCE;
+exports.SQL_SVE_NULLIF = idb.SQL_SVE_NULLIF;
 
-exports.SQL_SP_EXISTS = dba.SQL_SP_EXISTS;
-exports.SQL_SP_ISNOTNULL = dba.SQL_SP_ISNOTNULL;
-exports.SQL_SP_ISNULL = dba.SQL_SP_ISNULL;
-exports.SQL_SP_MATCH_FULL = dba.SQL_SP_MATCH_FULL;
-exports.SQL_SP_MATCH_PARTIAL = dba.SQL_SP_MATCH_PARTIAL;
-exports.SQL_SP_MATCH_UNIQUE_FULL = dba.SQL_SP_MATCH_UNIQUE_FULL;
-exports.SQL_SP_MATCH_UNIQUE_PARTIAL = dba.SQL_SP_MATCH_UNIQUE_PARTIAL;
-exports.SQL_SP_OVERLAPS = dba.SQL_SP_OVERLAPS;
-exports.SQL_SP_UNIQUE = dba.SQL_SP_UNIQUE;
-exports.SQL_SP_LIKE = dba.SQL_SP_LIKE;
-exports.SQL_SP_IN = dba.SQL_SP_IN;
-exports.SQL_SP_BETWEEN = dba.SQL_SP_BETWEEN;
-exports.SQL_SP_COMPARISON = dba.SQL_SP_COMPARISON;
-exports.SQL_SP_QUANTIFIED_COMPARISON = dba.SQL_SP_QUANTIFIED_COMPARISON;
+exports.SQL_SP_EXISTS = idb.SQL_SP_EXISTS;
+exports.SQL_SP_ISNOTNULL = idb.SQL_SP_ISNOTNULL;
+exports.SQL_SP_ISNULL = idb.SQL_SP_ISNULL;
+exports.SQL_SP_MATCH_FULL = idb.SQL_SP_MATCH_FULL;
+exports.SQL_SP_MATCH_PARTIAL = idb.SQL_SP_MATCH_PARTIAL;
+exports.SQL_SP_MATCH_UNIQUE_FULL = idb.SQL_SP_MATCH_UNIQUE_FULL;
+exports.SQL_SP_MATCH_UNIQUE_PARTIAL = idb.SQL_SP_MATCH_UNIQUE_PARTIAL;
+exports.SQL_SP_OVERLAPS = idb.SQL_SP_OVERLAPS;
+exports.SQL_SP_UNIQUE = idb.SQL_SP_UNIQUE;
+exports.SQL_SP_LIKE = idb.SQL_SP_LIKE;
+exports.SQL_SP_IN = idb.SQL_SP_IN;
+exports.SQL_SP_BETWEEN = idb.SQL_SP_BETWEEN;
+exports.SQL_SP_COMPARISON = idb.SQL_SP_COMPARISON;
+exports.SQL_SP_QUANTIFIED_COMPARISON = idb.SQL_SP_QUANTIFIED_COMPARISON;
 
-exports.SQL_AF_AVG = dba.SQL_AF_AVG;
-exports.SQL_AF_COUNT = dba.SQL_AF_COUNT;
-exports.SQL_AF_MAX = dba.SQL_AF_MAX;
-exports.SQL_AF_MIN = dba.SQL_AF_MIN;
-exports.SQL_AF_SUM = dba.SQL_AF_SUM;
-exports.SQL_AF_DISTINCT = dba.SQL_AF_DISTINCT;
-exports.SQL_AF_ALL = dba.SQL_AF_ALL;
+exports.SQL_AF_AVG = idb.SQL_AF_AVG;
+exports.SQL_AF_COUNT = idb.SQL_AF_COUNT;
+exports.SQL_AF_MAX = idb.SQL_AF_MAX;
+exports.SQL_AF_MIN = idb.SQL_AF_MIN;
+exports.SQL_AF_SUM = idb.SQL_AF_SUM;
+exports.SQL_AF_DISTINCT = idb.SQL_AF_DISTINCT;
+exports.SQL_AF_ALL = idb.SQL_AF_ALL;
 
-exports.SQL_SC_SQL92_ENTRY = dba.SQL_SC_SQL92_ENTRY;
-exports.SQL_SC_FIPS127_2_TRANSITIONAL = dba.SQL_SC_FIPS127_2_TRANSITIONAL;
-exports.SQL_SC_SQL92_INTERMEDIATE = dba.SQL_SC_SQL92_INTERMEDIATE;
-exports.SQL_SC_SQL92_FULL = dba.SQL_SC_SQL92_FULL;
+exports.SQL_SC_SQL92_ENTRY = idb.SQL_SC_SQL92_ENTRY;
+exports.SQL_SC_FIPS127_2_TRANSITIONAL = idb.SQL_SC_FIPS127_2_TRANSITIONAL;
+exports.SQL_SC_SQL92_INTERMEDIATE = idb.SQL_SC_SQL92_INTERMEDIATE;
+exports.SQL_SC_SQL92_FULL = idb.SQL_SC_SQL92_FULL;
 
-exports.SQL_FN_CVT_CONVERT = dba.SQL_FN_CVT_CONVERT;
-exports.SQL_FN_CVT_CAST = dba.SQL_FN_CVT_CAST;
+exports.SQL_FN_CVT_CONVERT = idb.SQL_FN_CVT_CONVERT;
+exports.SQL_FN_CVT_CAST = idb.SQL_FN_CVT_CAST;
 
-exports.SQL_PS_POSITIONED_DELETE = dba.SQL_PS_POSITIONED_DELETE;
-exports.SQL_PS_POSITIONED_UPDATE = dba.SQL_PS_POSITIONED_UPDATE;
-exports.SQL_PS_SELECT_FOR_UPDATE = dba.SQL_PS_SELECT_FOR_UPDATE;
+exports.SQL_PS_POSITIONED_DELETE = idb.SQL_PS_POSITIONED_DELETE;
+exports.SQL_PS_POSITIONED_UPDATE = idb.SQL_PS_POSITIONED_UPDATE;
+exports.SQL_PS_SELECT_FOR_UPDATE = idb.SQL_PS_SELECT_FOR_UPDATE;
 
-exports.SQL_CVT_CHAR = dba.SQL_CVT_CHAR;
-exports.SQL_CVT_NUMERIC = dba.SQL_CVT_NUMERIC;
-exports.SQL_CVT_DECIMAL = dba.SQL_CVT_DECIMAL;
-exports.SQL_CVT_INTEGER = dba.SQL_CVT_INTEGER;
-exports.SQL_CVT_SMALLINT = dba.SQL_CVT_SMALLINT;
-exports.SQL_CVT_FLOAT = dba.SQL_CVT_FLOAT;
-exports.SQL_CVT_REAL = dba.SQL_CVT_REAL;
-exports.SQL_CVT_DOUBLE = dba.SQL_CVT_DOUBLE;
-exports.SQL_CVT_VARCHAR = dba.SQL_CVT_VARCHAR;
-exports.SQL_CVT_LONGVARCHAR = dba.SQL_CVT_LONGVARCHAR;
-exports.SQL_CVT_BINARY = dba.SQL_CVT_BINARY;
-exports.SQL_CVT_VARBINARY = dba.SQL_CVT_VARBINARY;
-exports.SQL_CVT_BIT = dba.SQL_CVT_BIT;
-exports.SQL_CVT_TINYINT = dba.SQL_CVT_TINYINT;
-exports.SQL_CVT_BIGINT = dba.SQL_CVT_BIGINT;
-exports.SQL_CVT_DATE = dba.SQL_CVT_DATE;
-exports.SQL_CVT_TIME = dba.SQL_CVT_TIME;
-exports.SQL_CVT_TIMESTAMP = dba.SQL_CVT_TIMESTAMP;
-exports.SQL_CVT_LONGVARBINARY = dba.SQL_CVT_LONGVARBINARY;
-exports.SQL_CVT_INTERVAL_YEAR_MONTH = dba.SQL_CVT_INTERVAL_YEAR_MONTH;
-exports.SQL_CVT_INTERVAL_DAY_TIME = dba.SQL_CVT_INTERVAL_DAY_TIME;
-exports.SQL_CVT_WCHAR = dba.SQL_CVT_WCHAR;
-exports.SQL_CVT_WLONGVARCHAR = dba.SQL_CVT_WLONGVARCHAR;
-exports.SQL_CVT_WVARCHAR = dba.SQL_CVT_WVARCHAR;
-exports.SQL_CVT_BLOB = dba.SQL_CVT_BLOB;
-exports.SQL_CVT_CLOB = dba.SQL_CVT_CLOB;
-exports.SQL_CVT_DBCLOB = dba.SQL_CVT_DBCLOB;
-exports.SQL_CVT_DECFLOAT7 = dba.SQL_CVT_DECFLOAT7;
-exports.SQL_CVT_DECFLOAT16 = dba.SQL_CVT_DECFLOAT16;
-exports.SQL_CVT_DECFLOAT34 = dba.SQL_CVT_DECFLOAT34;
+exports.SQL_CVT_CHAR = idb.SQL_CVT_CHAR;
+exports.SQL_CVT_NUMERIC = idb.SQL_CVT_NUMERIC;
+exports.SQL_CVT_DECIMAL = idb.SQL_CVT_DECIMAL;
+exports.SQL_CVT_INTEGER = idb.SQL_CVT_INTEGER;
+exports.SQL_CVT_SMALLINT = idb.SQL_CVT_SMALLINT;
+exports.SQL_CVT_FLOAT = idb.SQL_CVT_FLOAT;
+exports.SQL_CVT_REAL = idb.SQL_CVT_REAL;
+exports.SQL_CVT_DOUBLE = idb.SQL_CVT_DOUBLE;
+exports.SQL_CVT_VARCHAR = idb.SQL_CVT_VARCHAR;
+exports.SQL_CVT_LONGVARCHAR = idb.SQL_CVT_LONGVARCHAR;
+exports.SQL_CVT_BINARY = idb.SQL_CVT_BINARY;
+exports.SQL_CVT_VARBINARY = idb.SQL_CVT_VARBINARY;
+exports.SQL_CVT_BIT = idb.SQL_CVT_BIT;
+exports.SQL_CVT_TINYINT = idb.SQL_CVT_TINYINT;
+exports.SQL_CVT_BIGINT = idb.SQL_CVT_BIGINT;
+exports.SQL_CVT_DATE = idb.SQL_CVT_DATE;
+exports.SQL_CVT_TIME = idb.SQL_CVT_TIME;
+exports.SQL_CVT_TIMESTAMP = idb.SQL_CVT_TIMESTAMP;
+exports.SQL_CVT_LONGVARBINARY = idb.SQL_CVT_LONGVARBINARY;
+exports.SQL_CVT_INTERVAL_YEAR_MONTH = idb.SQL_CVT_INTERVAL_YEAR_MONTH;
+exports.SQL_CVT_INTERVAL_DAY_TIME = idb.SQL_CVT_INTERVAL_DAY_TIME;
+exports.SQL_CVT_WCHAR = idb.SQL_CVT_WCHAR;
+exports.SQL_CVT_WLONGVARCHAR = idb.SQL_CVT_WLONGVARCHAR;
+exports.SQL_CVT_WVARCHAR = idb.SQL_CVT_WVARCHAR;
+exports.SQL_CVT_BLOB = idb.SQL_CVT_BLOB;
+exports.SQL_CVT_CLOB = idb.SQL_CVT_CLOB;
+exports.SQL_CVT_DBCLOB = idb.SQL_CVT_DBCLOB;
+exports.SQL_CVT_DECFLOAT7 = idb.SQL_CVT_DECFLOAT7;
+exports.SQL_CVT_DECFLOAT16 = idb.SQL_CVT_DECFLOAT16;
+exports.SQL_CVT_DECFLOAT34 = idb.SQL_CVT_DECFLOAT34;
 
-exports.SQL_FN_TD_NOW = dba.SQL_FN_TD_NOW;
-exports.SQL_FN_TD_CURDATE = dba.SQL_FN_TD_CURDATE;
-exports.SQL_FN_TD_DAYOFMONTH = dba.SQL_FN_TD_DAYOFMONTH;
-exports.SQL_FN_TD_DAYOFWEEK = dba.SQL_FN_TD_DAYOFWEEK;
-exports.SQL_FN_TD_DAYOFYEAR = dba.SQL_FN_TD_DAYOFYEAR;
-exports.SQL_FN_TD_MONTH = dba.SQL_FN_TD_MONTH;
-exports.SQL_FN_TD_QUARTER = dba.SQL_FN_TD_QUARTER;
-exports.SQL_FN_TD_WEEK = dba.SQL_FN_TD_WEEK;
-exports.SQL_FN_TD_YEAR = dba.SQL_FN_TD_YEAR;
-exports.SQL_FN_TD_CURTIME = dba.SQL_FN_TD_CURTIME;
-exports.SQL_FN_TD_HOUR = dba.SQL_FN_TD_HOUR;
-exports.SQL_FN_TD_MINUTE = dba.SQL_FN_TD_MINUTE;
-exports.SQL_FN_TD_SECOND = dba.SQL_FN_TD_SECOND;
-exports.SQL_FN_TD_TIMESTAMPADD = dba.SQL_FN_TD_TIMESTAMPADD;
-exports.SQL_FN_TD_TIMESTAMPDIFF = dba.SQL_FN_TD_TIMESTAMPDIFF;
-exports.SQL_FN_TD_DAYNAME = dba.SQL_FN_TD_DAYNAME;
-exports.SQL_FN_TD_MONTHNAME = dba.SQL_FN_TD_MONTHNAME;
-exports.SQL_FN_TD_CURRENT_DATE = dba.SQL_FN_TD_CURRENT_DATE;
-exports.SQL_FN_TD_CURRENT_TIME = dba.SQL_FN_TD_CURRENT_TIME;
-exports.SQL_FN_TD_CURRENT_TIMESTAMP = dba.SQL_FN_TD_CURRENT_TIMESTAMP;
-exports.SQL_FN_TD_EXTRACT = dba.SQL_FN_TD_EXTRACT;
+exports.SQL_FN_TD_NOW = idb.SQL_FN_TD_NOW;
+exports.SQL_FN_TD_CURDATE = idb.SQL_FN_TD_CURDATE;
+exports.SQL_FN_TD_DAYOFMONTH = idb.SQL_FN_TD_DAYOFMONTH;
+exports.SQL_FN_TD_DAYOFWEEK = idb.SQL_FN_TD_DAYOFWEEK;
+exports.SQL_FN_TD_DAYOFYEAR = idb.SQL_FN_TD_DAYOFYEAR;
+exports.SQL_FN_TD_MONTH = idb.SQL_FN_TD_MONTH;
+exports.SQL_FN_TD_QUARTER = idb.SQL_FN_TD_QUARTER;
+exports.SQL_FN_TD_WEEK = idb.SQL_FN_TD_WEEK;
+exports.SQL_FN_TD_YEAR = idb.SQL_FN_TD_YEAR;
+exports.SQL_FN_TD_CURTIME = idb.SQL_FN_TD_CURTIME;
+exports.SQL_FN_TD_HOUR = idb.SQL_FN_TD_HOUR;
+exports.SQL_FN_TD_MINUTE = idb.SQL_FN_TD_MINUTE;
+exports.SQL_FN_TD_SECOND = idb.SQL_FN_TD_SECOND;
+exports.SQL_FN_TD_TIMESTAMPADD = idb.SQL_FN_TD_TIMESTAMPADD;
+exports.SQL_FN_TD_TIMESTAMPDIFF = idb.SQL_FN_TD_TIMESTAMPDIFF;
+exports.SQL_FN_TD_DAYNAME = idb.SQL_FN_TD_DAYNAME;
+exports.SQL_FN_TD_MONTHNAME = idb.SQL_FN_TD_MONTHNAME;
+exports.SQL_FN_TD_CURRENT_DATE = idb.SQL_FN_TD_CURRENT_DATE;
+exports.SQL_FN_TD_CURRENT_TIME = idb.SQL_FN_TD_CURRENT_TIME;
+exports.SQL_FN_TD_CURRENT_TIMESTAMP = idb.SQL_FN_TD_CURRENT_TIMESTAMP;
+exports.SQL_FN_TD_EXTRACT = idb.SQL_FN_TD_EXTRACT;
 
-exports.SQL_CN_NONE = dba.SQL_CN_NONE;
-exports.SQL_CN_DIFFERENT = dba.SQL_CN_DIFFERENT;
-exports.SQL_CN_ANY = dba.SQL_CN_ANY;
+exports.SQL_CN_NONE = idb.SQL_CN_NONE;
+exports.SQL_CN_DIFFERENT = idb.SQL_CN_DIFFERENT;
+exports.SQL_CN_ANY = idb.SQL_CN_ANY;
 
-exports.SQL_IC_UPPER = dba.SQL_IC_UPPER;
-exports.SQL_IC_LOWER = dba.SQL_IC_LOWER;
-exports.SQL_IC_SENSITIVE = dba.SQL_IC_SENSITIVE;
-exports.SQL_IC_MIXED = dba.SQL_IC_MIXED;
+exports.SQL_IC_UPPER = idb.SQL_IC_UPPER;
+exports.SQL_IC_LOWER = idb.SQL_IC_LOWER;
+exports.SQL_IC_SENSITIVE = idb.SQL_IC_SENSITIVE;
+exports.SQL_IC_MIXED = idb.SQL_IC_MIXED;
 
-exports.SQL_NNC_NULL = dba.SQL_NNC_NULL;
-exports.SQL_NNC_NON_NULL = dba.SQL_NNC_NON_NULL;
+exports.SQL_NNC_NULL = idb.SQL_NNC_NULL;
+exports.SQL_NNC_NON_NULL = idb.SQL_NNC_NON_NULL;
 
-exports.SQL_GB_NO_RELATION = dba.SQL_GB_NO_RELATION;
-exports.SQL_GB_NOT_SUPPORTED = dba.SQL_GB_NOT_SUPPORTED;
-exports.SQL_GB_GROUP_BY_EQUALS_SELECT = dba.SQL_GB_GROUP_BY_EQUALS_SELECT;
-exports.SQL_GB_GROUP_BY_CONTAINS_SELECT = dba.SQL_GB_GROUP_BY_CONTAINS_SELECT;
+exports.SQL_GB_NO_RELATION = idb.SQL_GB_NO_RELATION;
+exports.SQL_GB_NOT_SUPPORTED = idb.SQL_GB_NOT_SUPPORTED;
+exports.SQL_GB_GROUP_BY_EQUALS_SELECT = idb.SQL_GB_GROUP_BY_EQUALS_SELECT;
+exports.SQL_GB_GROUP_BY_CONTAINS_SELECT = idb.SQL_GB_GROUP_BY_CONTAINS_SELECT;
 
-exports.SQL_CHAR = dba.SQL_CHAR;
-exports.SQL_NUMERIC = dba.SQL_NUMERIC;
-exports.SQL_DECIMAL = dba.SQL_DECIMAL;
-exports.SQL_INTEGER = dba.SQL_INTEGER;
-exports.SQL_SMALLINT = dba.SQL_SMALLINT;
-exports.SQL_FLOAT = dba.SQL_FLOAT;
-exports.SQL_REAL = dba.SQL_REAL;
-exports.SQL_DOUBLE = dba.SQL_DOUBLE;
-exports.SQL_DATETIME = dba.SQL_DATETIME;
-exports.SQL_VARCHAR = dba.SQL_VARCHAR;
-exports.SQL_BLOB = dba.SQL_BLOB;
-exports.SQL_CLOB = dba.SQL_CLOB;
-exports.SQL_DBCLOB = dba.SQL_DBCLOB;
-exports.SQL_DATALINK = dba.SQL_DATALINK;
-exports.SQL_WCHAR = dba.SQL_WCHAR;
-exports.SQL_WVARCHAR = dba.SQL_WVARCHAR;
-exports.SQL_BIGINT = dba.SQL_BIGINT;
-exports.SQL_BLOB_LOCATOR = dba.SQL_BLOB_LOCATOR;
-exports.SQL_CLOB_LOCATOR = dba.SQL_CLOB_LOCATOR;
-exports.SQL_DBCLOB_LOCATOR = dba.SQL_DBCLOB_LOCATOR;
-exports.SQL_UTF8_CHAR = dba.SQL_UTF8_CHAR;
-exports.SQL_WLONGVARCHAR = dba.SQL_WLONGVARCHAR;
-exports.SQL_LONGVARCHAR = dba.SQL_LONGVARCHAR;
-exports.SQL_GRAPHIC = dba.SQL_GRAPHIC;
-exports.SQL_VARGRAPHIC = dba.SQL_VARGRAPHIC;
-exports.SQL_LONGVARGRAPHIC = dba.SQL_LONGVARGRAPHIC;
-exports.SQL_BINARY = dba.SQL_BINARY;
-exports.SQL_VARBINARY = dba.SQL_VARBINARY;
-exports.SQL_LONGVARBINARY = dba.SQL_LONGVARBINARY;
-exports.SQL_DATE = dba.SQL_DATE;
-exports.SQL_TYPE_DATE = dba.SQL_TYPE_DATE;
-exports.SQL_TIME = dba.SQL_TIME;
-exports.SQL_TYPE_TIME = dba.SQL_TYPE_TIME;
-exports.SQL_TIMESTAMP = dba.SQL_TIMESTAMP;
-exports.SQL_TYPE_TIMESTAMP = dba.SQL_TYPE_TIMESTAMP;
-exports.SQL_CODE_DATE = dba.SQL_CODE_DATE;
-exports.SQL_CODE_TIME = dba.SQL_CODE_TIME;
-exports.SQL_CODE_TIMESTAMP = dba.SQL_CODE_TIMESTAMP;
-exports.SQL_ALL_TYPES = dba.SQL_ALL_TYPES;
-exports.SQL_DECFLOAT = dba.SQL_DECFLOAT;
-exports.SQL_XML = dba.SQL_XML;
+exports.SQL_CHAR = idb.SQL_CHAR;
+exports.SQL_NUMERIC = idb.SQL_NUMERIC;
+exports.SQL_DECIMAL = idb.SQL_DECIMAL;
+exports.SQL_INTEGER = idb.SQL_INTEGER;
+exports.SQL_SMALLINT = idb.SQL_SMALLINT;
+exports.SQL_FLOAT = idb.SQL_FLOAT;
+exports.SQL_REAL = idb.SQL_REAL;
+exports.SQL_DOUBLE = idb.SQL_DOUBLE;
+exports.SQL_DATETIME = idb.SQL_DATETIME;
+exports.SQL_VARCHAR = idb.SQL_VARCHAR;
+exports.SQL_BLOB = idb.SQL_BLOB;
+exports.SQL_CLOB = idb.SQL_CLOB;
+exports.SQL_DBCLOB = idb.SQL_DBCLOB;
+exports.SQL_DATALINK = idb.SQL_DATALINK;
+exports.SQL_WCHAR = idb.SQL_WCHAR;
+exports.SQL_WVARCHAR = idb.SQL_WVARCHAR;
+exports.SQL_BIGINT = idb.SQL_BIGINT;
+exports.SQL_BLOB_LOCATOR = idb.SQL_BLOB_LOCATOR;
+exports.SQL_CLOB_LOCATOR = idb.SQL_CLOB_LOCATOR;
+exports.SQL_DBCLOB_LOCATOR = idb.SQL_DBCLOB_LOCATOR;
+exports.SQL_UTF8_CHAR = idb.SQL_UTF8_CHAR;
+exports.SQL_WLONGVARCHAR = idb.SQL_WLONGVARCHAR;
+exports.SQL_LONGVARCHAR = idb.SQL_LONGVARCHAR;
+exports.SQL_GRAPHIC = idb.SQL_GRAPHIC;
+exports.SQL_VARGRAPHIC = idb.SQL_VARGRAPHIC;
+exports.SQL_LONGVARGRAPHIC = idb.SQL_LONGVARGRAPHIC;
+exports.SQL_BINARY = idb.SQL_BINARY;
+exports.SQL_VARBINARY = idb.SQL_VARBINARY;
+exports.SQL_LONGVARBINARY = idb.SQL_LONGVARBINARY;
+exports.SQL_DATE = idb.SQL_DATE;
+exports.SQL_TYPE_DATE = idb.SQL_TYPE_DATE;
+exports.SQL_TIME = idb.SQL_TIME;
+exports.SQL_TYPE_TIME = idb.SQL_TYPE_TIME;
+exports.SQL_TIMESTAMP = idb.SQL_TIMESTAMP;
+exports.SQL_TYPE_TIMESTAMP = idb.SQL_TYPE_TIMESTAMP;
+exports.SQL_CODE_DATE = idb.SQL_CODE_DATE;
+exports.SQL_CODE_TIME = idb.SQL_CODE_TIME;
+exports.SQL_CODE_TIMESTAMP = idb.SQL_CODE_TIMESTAMP;
+exports.SQL_ALL_TYPES = idb.SQL_ALL_TYPES;
+exports.SQL_DECFLOAT = idb.SQL_DECFLOAT;
+exports.SQL_XML = idb.SQL_XML;
 
-exports.SQL_UNUSED = dba.SQL_UNUSED;
-exports.SQL_HANDLE_ENV = dba.SQL_HANDLE_ENV;
-exports.SQL_HANDLE_DBC = dba.SQL_HANDLE_DBC;
-exports.SQL_HANDLE_STMT = dba.SQL_HANDLE_STMT;
-exports.SQL_HANDLE_DESC = dba.SQL_HANDLE_DESC;
-exports.SQL_NULL_HANDLE = dba.SQL_NULL_HANDLE;
-exports.SQL_HANDLE_DBC_UNICODE = dba.SQL_HANDLE_DBC_UNICODE;
+exports.SQL_UNUSED = idb.SQL_UNUSED;
+exports.SQL_HANDLE_ENV = idb.SQL_HANDLE_ENV;
+exports.SQL_HANDLE_DBC = idb.SQL_HANDLE_DBC;
+exports.SQL_HANDLE_STMT = idb.SQL_HANDLE_STMT;
+exports.SQL_HANDLE_DESC = idb.SQL_HANDLE_DESC;
+exports.SQL_NULL_HANDLE = idb.SQL_NULL_HANDLE;
+exports.SQL_HANDLE_DBC_UNICODE = idb.SQL_HANDLE_DBC_UNICODE;
 
-exports.SQL_NO_NULLS = dba.SQL_NO_NULLS;
-exports.SQL_NULLABLE = dba.SQL_NULLABLE;
-exports.SQL_NULLABLE_UNKNOWN = dba.SQL_NULLABLE_UNKNOWN;
+exports.SQL_NO_NULLS = idb.SQL_NO_NULLS;
+exports.SQL_NULLABLE = idb.SQL_NULLABLE;
+exports.SQL_NULLABLE_UNKNOWN = idb.SQL_NULLABLE_UNKNOWN;
 
-exports.SQL_NO_TOTAL = dba.SQL_NO_TOTAL;
-exports.SQL_NULL_DATA = dba.SQL_NULL_DATA;
-exports.SQL_DATA_AT_EXEC = dba.SQL_DATA_AT_EXEC;
-exports.SQL_BIGINT_PREC = dba.SQL_BIGINT_PREC;
-exports.SQL_INTEGER_PREC = dba.SQL_INTEGER_PREC;
-exports.SQL_SMALLINT_PREC = dba.SQL_SMALLINT_PREC;
+exports.SQL_NO_TOTAL = idb.SQL_NO_TOTAL;
+exports.SQL_NULL_DATA = idb.SQL_NULL_DATA;
+exports.SQL_DATA_AT_EXEC = idb.SQL_DATA_AT_EXEC;
+exports.SQL_BIGINT_PREC = idb.SQL_BIGINT_PREC;
+exports.SQL_INTEGER_PREC = idb.SQL_INTEGER_PREC;
+exports.SQL_SMALLINT_PREC = idb.SQL_SMALLINT_PREC;
 
-exports.SQL_DEFAULT_PARAM = dba.SQL_DEFAULT_PARAM;
-exports.SQL_UNASSIGNED = dba.SQL_UNASSIGNED;
+exports.SQL_DEFAULT_PARAM = idb.SQL_DEFAULT_PARAM;
+exports.SQL_UNASSIGNED = idb.SQL_UNASSIGNED;
 
-exports.SQL_ATTR_READONLY = dba.SQL_ATTR_READONLY;
-exports.SQL_ATTR_WRITE = dba.SQL_ATTR_WRITE;
-exports.SQL_ATTR_READWRITE_UNKNOWN = dba.SQL_ATTR_READWRITE_UNKNOWN;
+exports.SQL_ATTR_READONLY = idb.SQL_ATTR_READONLY;
+exports.SQL_ATTR_WRITE = idb.SQL_ATTR_WRITE;
+exports.SQL_ATTR_READWRITE_UNKNOWN = idb.SQL_ATTR_READWRITE_UNKNOWN;
 
-exports.SQL_CONCUR_LOCK = dba.SQL_CONCUR_LOCK;
-exports.SQL_CONCUR_READ_ONLY = dba.SQL_CONCUR_READ_ONLY;
-exports.SQL_CONCUR_ROWVER = dba.SQL_CONCUR_ROWVER;
-exports.SQL_CONCUR_VALUES = dba.SQL_CONCUR_VALUES;
+exports.SQL_CONCUR_LOCK = idb.SQL_CONCUR_LOCK;
+exports.SQL_CONCUR_READ_ONLY = idb.SQL_CONCUR_READ_ONLY;
+exports.SQL_CONCUR_ROWVER = idb.SQL_CONCUR_ROWVER;
+exports.SQL_CONCUR_VALUES = idb.SQL_CONCUR_VALUES;
 
-exports.SQL_ATTR_OUTPUT_NTS = dba.SQL_ATTR_OUTPUT_NTS;
-exports.SQL_ATTR_SYS_NAMING = dba.SQL_ATTR_SYS_NAMING;
-exports.SQL_ATTR_DEFAULT_LIB = dba.SQL_ATTR_DEFAULT_LIB;
-exports.SQL_ATTR_SERVER_MODE = dba.SQL_ATTR_SERVER_MODE;
-exports.SQL_ATTR_JOB_SORT_SEQUENCE = dba.SQL_ATTR_JOB_SORT_SEQUENCE;
-exports.SQL_ATTR_ENVHNDL_COUNTER = dba.SQL_ATTR_ENVHNDL_COUNTER;
-exports.SQL_ATTR_ESCAPE_CHAR = dba.SQL_ATTR_ESCAPE_CHAR;
-exports.SQL_ATTR_INCLUDE_NULL_IN_LEN = dba.SQL_ATTR_INCLUDE_NULL_IN_LEN;
-exports.SQL_ATTR_UTF8 = dba.SQL_ATTR_UTF8;
-exports.SQL_ATTR_SYSCAP = dba.SQL_ATTR_SYSCAP;
-exports.SQL_ATTR_REQUIRE_PROFILE = dba.SQL_ATTR_REQUIRE_PROFILE;
-exports.SQL_ATTR_UCS2 = dba.SQL_ATTR_UCS2;
-exports.SQL_ATTR_TRUNCATION_RTNC = dba.SQL_ATTR_TRUNCATION_RTNC;
+exports.SQL_ATTR_OUTPUT_NTS = idb.SQL_ATTR_OUTPUT_NTS;
+exports.SQL_ATTR_SYS_NAMING = idb.SQL_ATTR_SYS_NAMING;
+exports.SQL_ATTR_DEFAULT_LIB = idb.SQL_ATTR_DEFAULT_LIB;
+exports.SQL_ATTR_SERVER_MODE = idb.SQL_ATTR_SERVER_MODE;
+exports.SQL_ATTR_JOB_SORT_SEQUENCE = idb.SQL_ATTR_JOB_SORT_SEQUENCE;
+exports.SQL_ATTR_ENVHNDL_COUNTER = idb.SQL_ATTR_ENVHNDL_COUNTER;
+exports.SQL_ATTR_ESCAPE_CHAR = idb.SQL_ATTR_ESCAPE_CHAR;
+exports.SQL_ATTR_INCLUDE_NULL_IN_LEN = idb.SQL_ATTR_INCLUDE_NULL_IN_LEN;
+exports.SQL_ATTR_UTF8 = idb.SQL_ATTR_UTF8;
+exports.SQL_ATTR_SYSCAP = idb.SQL_ATTR_SYSCAP;
+exports.SQL_ATTR_REQUIRE_PROFILE = idb.SQL_ATTR_REQUIRE_PROFILE;
+exports.SQL_ATTR_UCS2 = idb.SQL_ATTR_UCS2;
+exports.SQL_ATTR_TRUNCATION_RTNC = idb.SQL_ATTR_TRUNCATION_RTNC;
 
-exports.SQL_ATTR_DATE_FMT = dba.SQL_ATTR_DATE_FMT;
-exports.SQL_ATTR_DATE_SEP = dba.SQL_ATTR_DATE_SEP;
-exports.SQL_ATTR_TIME_FMT = dba.SQL_ATTR_TIME_FMT;
-exports.SQL_ATTR_TIME_SEP = dba.SQL_ATTR_TIME_SEP;
-exports.SQL_ATTR_DECIMAL_SEP = dba.SQL_ATTR_DECIMAL_SEP;
-exports.SQL_ATTR_TXN_INFO = dba.SQL_ATTR_TXN_INFO;
-exports.SQL_ATTR_TXN_EXTERNAL = dba.SQL_ATTR_TXN_EXTERNAL;
-exports.SQL_ATTR_2ND_LEVEL_TEXT = dba.SQL_ATTR_2ND_LEVEL_TEXT;
-exports.SQL_ATTR_SAVEPOINT_NAME = dba.SQL_ATTR_SAVEPOINT_NAME;
-exports.SQL_ATTR_TRACE = dba.SQL_ATTR_TRACE;
-exports.SQL_ATTR_MAX_PRECISION = dba.SQL_ATTR_MAX_PRECISION;
-exports.SQL_ATTR_MAX_SCALE = dba.SQL_ATTR_MAX_SCALE;
-exports.SQL_ATTR_MIN_DIVIDE_SCALE = dba.SQL_ATTR_MIN_DIVIDE_SCALE;
-exports.SQL_ATTR_HEX_LITERALS = dba.SQL_ATTR_HEX_LITERALS;
-exports.SQL_ATTR_CORRELATOR = dba.SQL_ATTR_CORRELATOR;
-exports.SQL_ATTR_QUERY_OPTIMIZE_GOAL = dba.SQL_ATTR_QUERY_OPTIMIZE_GOAL;
-exports.SQL_ATTR_CONN_SORT_SEQUENCE = dba.SQL_ATTR_CONN_SORT_SEQUENCE;
-exports.SQL_ATTR_PREFETCH = dba.SQL_ATTR_PREFETCH;
-exports.SQL_ATTR_CLOSEONEOF = dba.SQL_ATTR_CLOSEONEOF;
-exports.SQL_ATTR_ANSI_APP = dba.SQL_ATTR_ANSI_APP;
-exports.SQL_ATTR_INFO_USERID = dba.SQL_ATTR_INFO_USERID;
-exports.SQL_ATTR_INFO_WRKSTNNAME = dba.SQL_ATTR_INFO_WRKSTNNAME;
-exports.SQL_ATTR_INFO_APPLNAME = dba.SQL_ATTR_INFO_APPLNAME;
-exports.SQL_ATTR_INFO_ACCTSTR = dba.SQL_ATTR_INFO_ACCTSTR;
-exports.SQL_ATTR_INFO_PROGRAMID = dba.SQL_ATTR_INFO_PROGRAMID;
-exports.SQL_ATTR_DECFLOAT_ROUNDING_MODE = dba.SQL_ATTR_DECFLOAT_ROUNDING_MODE;
-exports.SQL_ATTR_OLD_MTADTA_BEHAVIOR = dba.SQL_ATTR_OLD_MTADTA_BEHAVIOR;
-exports.SQL_ATTR_NULL_REQUIRED = dba.SQL_ATTR_NULL_REQUIRED;
-exports.SQL_ATTR_FREE_LOCATORS = dba.SQL_ATTR_FREE_LOCATORS;
-exports.SQL_ATTR_EXTENDED_INDICATORS = dba.SQL_ATTR_EXTENDED_INDICATORS;
-exports.SQL_ATTR_NULLT_ARRAY_RESULTS = dba.SQL_ATTR_NULLT_ARRAY_RESULTS;
-exports.SQL_ATTR_NULLT_OUTPUT_PARMS = dba.SQL_ATTR_NULLT_OUTPUT_PARMS;
-exports.SQL_ATTR_TIMESTAMP_PREC = dba.SQL_ATTR_TIMESTAMP_PREC;
-exports.SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION = dba.SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION;
-exports.SQL_CONCURRENT_ACCESS_RESOLUTION_UNSET = dba.SQL_CONCURRENT_ACCESS_RESOLUTION_UNSET;
-exports.SQL_USE_CURRENTLY_COMMITTED = dba.SQL_USE_CURRENTLY_COMMITTED;
-exports.SQL_WAIT_FOR_OUTCOME = dba.SQL_WAIT_FOR_OUTCOME;
-exports.SQL_SKIP_LOCKED_DATA = dba.SQL_SKIP_LOCKED_DATA;
+exports.SQL_ATTR_DATE_FMT = idb.SQL_ATTR_DATE_FMT;
+exports.SQL_ATTR_DATE_SEP = idb.SQL_ATTR_DATE_SEP;
+exports.SQL_ATTR_TIME_FMT = idb.SQL_ATTR_TIME_FMT;
+exports.SQL_ATTR_TIME_SEP = idb.SQL_ATTR_TIME_SEP;
+exports.SQL_ATTR_DECIMAL_SEP = idb.SQL_ATTR_DECIMAL_SEP;
+exports.SQL_ATTR_TXN_INFO = idb.SQL_ATTR_TXN_INFO;
+exports.SQL_ATTR_TXN_EXTERNAL = idb.SQL_ATTR_TXN_EXTERNAL;
+exports.SQL_ATTR_2ND_LEVEL_TEXT = idb.SQL_ATTR_2ND_LEVEL_TEXT;
+exports.SQL_ATTR_SAVEPOINT_NAME = idb.SQL_ATTR_SAVEPOINT_NAME;
+exports.SQL_ATTR_TRACE = idb.SQL_ATTR_TRACE;
+exports.SQL_ATTR_MAX_PRECISION = idb.SQL_ATTR_MAX_PRECISION;
+exports.SQL_ATTR_MAX_SCALE = idb.SQL_ATTR_MAX_SCALE;
+exports.SQL_ATTR_MIN_DIVIDE_SCALE = idb.SQL_ATTR_MIN_DIVIDE_SCALE;
+exports.SQL_ATTR_HEX_LITERALS = idb.SQL_ATTR_HEX_LITERALS;
+exports.SQL_ATTR_CORRELATOR = idb.SQL_ATTR_CORRELATOR;
+exports.SQL_ATTR_QUERY_OPTIMIZE_GOAL = idb.SQL_ATTR_QUERY_OPTIMIZE_GOAL;
+exports.SQL_ATTR_CONN_SORT_SEQUENCE = idb.SQL_ATTR_CONN_SORT_SEQUENCE;
+exports.SQL_ATTR_PREFETCH = idb.SQL_ATTR_PREFETCH;
+exports.SQL_ATTR_CLOSEONEOF = idb.SQL_ATTR_CLOSEONEOF;
+exports.SQL_ATTR_ANSI_APP = idb.SQL_ATTR_ANSI_APP;
+exports.SQL_ATTR_INFO_USERID = idb.SQL_ATTR_INFO_USERID;
+exports.SQL_ATTR_INFO_WRKSTNNAME = idb.SQL_ATTR_INFO_WRKSTNNAME;
+exports.SQL_ATTR_INFO_APPLNAME = idb.SQL_ATTR_INFO_APPLNAME;
+exports.SQL_ATTR_INFO_ACCTSTR = idb.SQL_ATTR_INFO_ACCTSTR;
+exports.SQL_ATTR_INFO_PROGRAMID = idb.SQL_ATTR_INFO_PROGRAMID;
+exports.SQL_ATTR_DECFLOAT_ROUNDING_MODE = idb.SQL_ATTR_DECFLOAT_ROUNDING_MODE;
+exports.SQL_ATTR_OLD_MTADTA_BEHAVIOR = idb.SQL_ATTR_OLD_MTADTA_BEHAVIOR;
+exports.SQL_ATTR_NULL_REQUIRED = idb.SQL_ATTR_NULL_REQUIRED;
+exports.SQL_ATTR_FREE_LOCATORS = idb.SQL_ATTR_FREE_LOCATORS;
+exports.SQL_ATTR_EXTENDED_INDICATORS = idb.SQL_ATTR_EXTENDED_INDICATORS;
+exports.SQL_ATTR_NULLT_ARRAY_RESULTS = idb.SQL_ATTR_NULLT_ARRAY_RESULTS;
+exports.SQL_ATTR_NULLT_OUTPUT_PARMS = idb.SQL_ATTR_NULLT_OUTPUT_PARMS;
+exports.SQL_ATTR_TIMESTAMP_PREC = idb.SQL_ATTR_TIMESTAMP_PREC;
+exports.SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION = idb.SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION;
+exports.SQL_CONCURRENT_ACCESS_RESOLUTION_UNSET = idb.SQL_CONCURRENT_ACCESS_RESOLUTION_UNSET;
+exports.SQL_USE_CURRENTLY_COMMITTED = idb.SQL_USE_CURRENTLY_COMMITTED;
+exports.SQL_WAIT_FOR_OUTCOME = idb.SQL_WAIT_FOR_OUTCOME;
+exports.SQL_SKIP_LOCKED_DATA = idb.SQL_SKIP_LOCKED_DATA;
 
-exports.SQL_TXN_FIND = dba.SQL_TXN_FIND;
-exports.SQL_TXN_CREATE = dba.SQL_TXN_CREATE;
-exports.SQL_TXN_RESUME = dba.SQL_TXN_RESUME;
-exports.SQL_TXN_CLEAR = dba.SQL_TXN_CLEAR;
-exports.SQL_TXN_END = dba.SQL_TXN_END;
-exports.SQL_TXN_HOLD = dba.SQL_TXN_HOLD;
-exports.SQL_TXN_END_FAIL = dba.SQL_TXN_END_FAIL;
+exports.SQL_TXN_FIND = idb.SQL_TXN_FIND;
+exports.SQL_TXN_CREATE = idb.SQL_TXN_CREATE;
+exports.SQL_TXN_RESUME = idb.SQL_TXN_RESUME;
+exports.SQL_TXN_CLEAR = idb.SQL_TXN_CLEAR;
+exports.SQL_TXN_END = idb.SQL_TXN_END;
+exports.SQL_TXN_HOLD = idb.SQL_TXN_HOLD;
+exports.SQL_TXN_END_FAIL = idb.SQL_TXN_END_FAIL;
 
-exports.SQL_FMT_ISO = dba.SQL_FMT_ISO;
-exports.SQL_FMT_USA = dba.SQL_FMT_USA;
-exports.SQL_FMT_EUR = dba.SQL_FMT_EUR;
-exports.SQL_FMT_JIS = dba.SQL_FMT_JIS;
-exports.SQL_FMT_MDY = dba.SQL_FMT_MDY;
-exports.SQL_FMT_DMY = dba.SQL_FMT_DMY;
-exports.SQL_FMT_YMD = dba.SQL_FMT_YMD;
-exports.SQL_FMT_JUL = dba.SQL_FMT_JUL;
-exports.SQL_FMT_HMS = dba.SQL_FMT_HMS;
-exports.SQL_FMT_JOB = dba.SQL_FMT_JOB;
-exports.SQL_SEP_SLASH = dba.SQL_SEP_SLASH;
-exports.SQL_SEP_DASH = dba.SQL_SEP_DASH;
-exports.SQL_SEP_PERIOD = dba.SQL_SEP_PERIOD;
-exports.SQL_SEP_COMMA = dba.SQL_SEP_COMMA;
-exports.SQL_SEP_BLANK = dba.SQL_SEP_BLANK;
-exports.SQL_SEP_COLON = dba.SQL_SEP_COLON;
-exports.SQL_SEP_JOB = dba.SQL_SEP_JOB;
-exports.SQL_HEX_IS_CHAR = dba.SQL_HEX_IS_CHAR;
-exports.SQL_HEX_IS_BINARY = dba.SQL_HEX_IS_BINARY;
-exports.SQL_FIRST_IO = dba.SQL_FIRST_IO;
-exports.SQL_ALL_IO = dba.SQL_ALL_IO;
-exports.ROUND_HALF_EVEN = dba.ROUND_HALF_EVEN;
-exports.ROUND_HALF_UP = dba.ROUND_HALF_UP;
-exports.ROUND_DOWN = dba.ROUND_DOWN;
-exports.ROUND_CEILING = dba.ROUND_CEILING;
-exports.ROUND_FLOOR = dba.ROUND_FLOOR;
-exports.ROUND_HALF_DOWN = dba.ROUND_HALF_DOWN;
-exports.ROUND_UP = dba.ROUND_UP;
+exports.SQL_FMT_ISO = idb.SQL_FMT_ISO;
+exports.SQL_FMT_USA = idb.SQL_FMT_USA;
+exports.SQL_FMT_EUR = idb.SQL_FMT_EUR;
+exports.SQL_FMT_JIS = idb.SQL_FMT_JIS;
+exports.SQL_FMT_MDY = idb.SQL_FMT_MDY;
+exports.SQL_FMT_DMY = idb.SQL_FMT_DMY;
+exports.SQL_FMT_YMD = idb.SQL_FMT_YMD;
+exports.SQL_FMT_JUL = idb.SQL_FMT_JUL;
+exports.SQL_FMT_HMS = idb.SQL_FMT_HMS;
+exports.SQL_FMT_JOB = idb.SQL_FMT_JOB;
+exports.SQL_SEP_SLASH = idb.SQL_SEP_SLASH;
+exports.SQL_SEP_DASH = idb.SQL_SEP_DASH;
+exports.SQL_SEP_PERIOD = idb.SQL_SEP_PERIOD;
+exports.SQL_SEP_COMMA = idb.SQL_SEP_COMMA;
+exports.SQL_SEP_BLANK = idb.SQL_SEP_BLANK;
+exports.SQL_SEP_COLON = idb.SQL_SEP_COLON;
+exports.SQL_SEP_JOB = idb.SQL_SEP_JOB;
+exports.SQL_HEX_IS_CHAR = idb.SQL_HEX_IS_CHAR;
+exports.SQL_HEX_IS_BINARY = idb.SQL_HEX_IS_BINARY;
+exports.SQL_FIRST_IO = idb.SQL_FIRST_IO;
+exports.SQL_ALL_IO = idb.SQL_ALL_IO;
+exports.ROUND_HALF_EVEN = idb.ROUND_HALF_EVEN;
+exports.ROUND_HALF_UP = idb.ROUND_HALF_UP;
+exports.ROUND_DOWN = idb.ROUND_DOWN;
+exports.ROUND_CEILING = idb.ROUND_CEILING;
+exports.ROUND_FLOOR = idb.ROUND_FLOOR;
+exports.ROUND_HALF_DOWN = idb.ROUND_HALF_DOWN;
+exports.ROUND_UP = idb.ROUND_UP;
 
-exports.SQL_DEFAULT = dba.SQL_DEFAULT;
-exports.SQL_ARD_TYPE = dba.SQL_ARD_TYPE;
+exports.SQL_DEFAULT = idb.SQL_DEFAULT;
+exports.SQL_ARD_TYPE = idb.SQL_ARD_TYPE;
 
-exports.SQL_CASCADE = dba.SQL_CASCADE;
-exports.SQL_RESTRICT = dba.SQL_RESTRICT;
-exports.SQL_NO_ACTION = dba.SQL_NO_ACTION;
-exports.SQL_SET_NULL = dba.SQL_SET_NULL;
-exports.SQL_SET_DEFAULT = dba.SQL_SET_DEFAULT;
-exports.SQL_INITIALLY_DEFERRED = dba.SQL_INITIALLY_DEFERRED;
-exports.SQL_INITIALLY_IMMEDIATE = dba.SQL_INITIALLY_IMMEDIATE;
-exports.SQL_NOT_DEFERRABLE = dba.SQL_NOT_DEFERRABLE;
-exports.SQL_PT_UNKNOWN = dba.SQL_PT_UNKNOWN;
-exports.SQL_PT_PROCEDURE = dba.SQL_PT_PROCEDURE;
-exports.SQL_PT_FUNCTION = dba.SQL_PT_FUNCTION;
+exports.SQL_CASCADE = idb.SQL_CASCADE;
+exports.SQL_RESTRICT = idb.SQL_RESTRICT;
+exports.SQL_NO_ACTION = idb.SQL_NO_ACTION;
+exports.SQL_SET_NULL = idb.SQL_SET_NULL;
+exports.SQL_SET_DEFAULT = idb.SQL_SET_DEFAULT;
+exports.SQL_INITIALLY_DEFERRED = idb.SQL_INITIALLY_DEFERRED;
+exports.SQL_INITIALLY_IMMEDIATE = idb.SQL_INITIALLY_IMMEDIATE;
+exports.SQL_NOT_DEFERRABLE = idb.SQL_NOT_DEFERRABLE;
+exports.SQL_PT_UNKNOWN = idb.SQL_PT_UNKNOWN;
+exports.SQL_PT_PROCEDURE = idb.SQL_PT_PROCEDURE;
+exports.SQL_PT_FUNCTION = idb.SQL_PT_FUNCTION;
 
-exports.SQL_PARAM_INPUT = dba.SQL_PARAM_INPUT;
-exports.SQL_PARAM_OUTPUT = dba.SQL_PARAM_OUTPUT;
-exports.SQL_PARAM_INPUT_OUTPUT = dba.SQL_PARAM_INPUT_OUTPUT;
-exports.SQL_ATTR_APP_ROW_DESC = dba.SQL_ATTR_APP_ROW_DESC;
-exports.SQL_ATTR_APP_PARAM_DESC = dba.SQL_ATTR_APP_PARAM_DESC;
-exports.SQL_ATTR_IMP_ROW_DESC = dba.SQL_ATTR_IMP_ROW_DESC;
-exports.SQL_ATTR_IMP_PARAM_DESC = dba.SQL_ATTR_IMP_PARAM_DESC;
-exports.SQL_ATTR_FOR_FETCH_ONLY = dba.SQL_ATTR_FOR_FETCH_ONLY;
-exports.SQL_ATTR_CONCURRENCY = dba.SQL_ATTR_CONCURRENCY;
-exports.SQL_CONCURRENCY = dba.SQL_CONCURRENCY;
-exports.SQL_ATTR_CURSOR_SCROLLABLE = dba.SQL_ATTR_CURSOR_SCROLLABLE;
-exports.SQL_ATTR_ROWSET_SIZE = dba.SQL_ATTR_ROWSET_SIZE;
-exports.SQL_ROWSET_SIZE = dba.SQL_ROWSET_SIZE;
-exports.SQL_ATTR_ROW_ARRAY_SIZE = dba.SQL_ATTR_ROW_ARRAY_SIZE;
-exports.SQL_ATTR_CURSOR_HOLD = dba.SQL_ATTR_CURSOR_HOLD;
-exports.SQL_ATTR_FULL_OPEN = dba.SQL_ATTR_FULL_OPEN;
-exports.SQL_ATTR_EXTENDED_COL_INFO = dba.SQL_ATTR_EXTENDED_COL_INFO;
-exports.SQL_ATTR_BIND_TYPE = dba.SQL_ATTR_BIND_TYPE;
-exports.SQL_BIND_TYPE = dba.SQL_BIND_TYPE;
-exports.SQL_ATTR_CURSOR_TYPE = dba.SQL_ATTR_CURSOR_TYPE;
-exports.SQL_CURSOR_TYPE = dba.SQL_CURSOR_TYPE;
-exports.SQL_ATTR_CURSOR_SENSITIVITY = dba.SQL_ATTR_CURSOR_SENSITIVITY;
-exports.SQL_CURSOR_SENSITIVE = dba.SQL_CURSOR_SENSITIVE;
-exports.SQL_ATTR_ROW_STATUS_PTR = dba.SQL_ATTR_ROW_STATUS_PTR;
-exports.SQL_ATTR_ROWS_FETCHED_PTR = dba.SQL_ATTR_ROWS_FETCHED_PTR;
-exports.SQL_ATTR_ROW_BIND_TYPE = dba.SQL_ATTR_ROW_BIND_TYPE;
-exports.SQL_ATTR_PARAM_BIND_TYPE = dba.SQL_ATTR_PARAM_BIND_TYPE;
-exports.SQL_ATTR_PARAMSET_SIZE = dba.SQL_ATTR_PARAMSET_SIZE;
-exports.SQL_ATTR_PARAM_STATUS_PTR = dba.SQL_ATTR_PARAM_STATUS_PTR;
-exports.SQL_ATTR_PARAMS_PROCESSED_PTR = dba.SQL_ATTR_PARAMS_PROCESSED_PTR;
-exports.SQL_ATTR_NUMBER_RESULTSET_ROWS_PTR = dba.SQL_ATTR_NUMBER_RESULTSET_ROWS_PTR;
-exports.SQL_BIND_BY_ROW = dba.SQL_BIND_BY_ROW;
-exports.SQL_BIND_BY_COLUMN = dba.SQL_BIND_BY_COLUMN;
-exports.SQL_CURSOR_FORWARD_ONLY = dba.SQL_CURSOR_FORWARD_ONLY;
-exports.SQL_CURSOR_STATIC = dba.SQL_CURSOR_STATIC;
-exports.SQL_CURSOR_DYNAMIC = dba.SQL_CURSOR_DYNAMIC;
-exports.SQL_CURSOR_KEYSET_DRIVEN = dba.SQL_CURSOR_KEYSET_DRIVEN;
-exports.SQL_UNSPECIFIED = dba.SQL_UNSPECIFIED;
-exports.SQL_INSENSITIVE = dba.SQL_INSENSITIVE;
-exports.SQL_SENSITIVE = dba.SQL_SENSITIVE;
-exports.SQL_FETCH_NEXT = dba.SQL_FETCH_NEXT;
-exports.SQL_FETCH_FIRST = dba.SQL_FETCH_FIRST;
-exports.SQL_FETCH_LAST = dba.SQL_FETCH_LAST;
-exports.SQL_FETCH_PRIOR = dba.SQL_FETCH_PRIOR;
-exports.SQL_FETCH_ABSOLUTE = dba.SQL_FETCH_ABSOLUTE;
-exports.SQL_FETCH_RELATIVE = dba.SQL_FETCH_RELATIVE;
-exports.SQL_DESC_COUNT = dba.SQL_DESC_COUNT;
-exports.SQL_DESC_TYPE = dba.SQL_DESC_TYPE;
-exports.SQL_DESC_LENGTH = dba.SQL_DESC_LENGTH;
-exports.SQL_DESC_LENGTH_PTR = dba.SQL_DESC_LENGTH_PTR;
-exports.SQL_DESC_PRECISION = dba.SQL_DESC_PRECISION;
-exports.SQL_DESC_SCALE = dba.SQL_DESC_SCALE;
-exports.SQL_DESC_DATETIME_INTERVAL_CODE = dba.SQL_DESC_DATETIME_INTERVAL_CODE;
-exports.SQL_DESC_NULLABLE = dba.SQL_DESC_NULLABLE;
-exports.SQL_DESC_INDICATOR_PTR = dba.SQL_DESC_INDICATOR_PTR;
-exports.SQL_DESC_DATA_PTR = dba.SQL_DESC_DATA_PTR;
-exports.SQL_DESC_NAME = dba.SQL_DESC_NAME;
-exports.SQL_DESC_UNNAMED = dba.SQL_DESC_UNNAMED;
-exports.SQL_DESC_DISPLAY_SIZE = dba.SQL_DESC_DISPLAY_SIZE;
-exports.SQL_DESC_AUTO_INCREMENT = dba.SQL_DESC_AUTO_INCREMENT;
-exports.SQL_DESC_SEARCHABLE = dba.SQL_DESC_SEARCHABLE;
-exports.SQL_DESC_UPDATABLE = dba.SQL_DESC_UPDATABLE;
-exports.SQL_DESC_BASE_COLUMN = dba.SQL_DESC_BASE_COLUMN;
-exports.SQL_DESC_BASE_TABLE = dba.SQL_DESC_BASE_TABLE;
-exports.SQL_DESC_BASE_SCHEMA = dba.SQL_DESC_BASE_SCHEMA;
-exports.SQL_DESC_LABEL = dba.SQL_DESC_LABEL;
-exports.SQL_DESC_MONEY = dba.SQL_DESC_MONEY;
-exports.SQL_DESC_TYPE_NAME = dba.SQL_DESC_TYPE_NAME;
-exports.SQL_DESC_COLUMN_CCSID = dba.SQL_DESC_COLUMN_CCSID;
-exports.SQL_DESC_ALLOC_TYPE = dba.SQL_DESC_ALLOC_TYPE;
-exports.SQL_DESC_ALLOC_AUTO = dba.SQL_DESC_ALLOC_AUTO;
-exports.SQL_DESC_ALLOC_USER = dba.SQL_DESC_ALLOC_USER;
-exports.SQL_COLUMN_COUNT = dba.SQL_COLUMN_COUNT;
-exports.SQL_COLUMN_TYPE = dba.SQL_COLUMN_TYPE;
-exports.SQL_COLUMN_LENGTH = dba.SQL_COLUMN_LENGTH;
-exports.SQL_COLUMN_LENGTH_PTR = dba.SQL_COLUMN_LENGTH_PTR;
-exports.SQL_COLUMN_PRECISION = dba.SQL_COLUMN_PRECISION;
-exports.SQL_COLUMN_SCALE = dba.SQL_COLUMN_SCALE;
-exports.SQL_COLUMN_DATETIME_INTERVAL_CODE = dba.SQL_COLUMN_DATETIME_INTERVAL_CODE;
-exports.SQL_COLUMN_NULLABLE = dba.SQL_COLUMN_NULLABLE;
-exports.SQL_COLUMN_INDICATOR_PTR = dba.SQL_COLUMN_INDICATOR_PTR;
-exports.SQL_COLUMN_DATA_PTR = dba.SQL_COLUMN_DATA_PTR;
-exports.SQL_COLUMN_NAME = dba.SQL_COLUMN_NAME;
-exports.SQL_COLUMN_UNNAMED = dba.SQL_COLUMN_UNNAMED;
-exports.SQL_COLUMN_DISPLAY_SIZE = dba.SQL_COLUMN_DISPLAY_SIZE;
-exports.SQL_COLUMN_AUTO_INCREMENT = dba.SQL_COLUMN_AUTO_INCREMENT;
-exports.SQL_COLUMN_SEARCHABLE = dba.SQL_COLUMN_SEARCHABLE;
-exports.SQL_COLUMN_UPDATABLE = dba.SQL_COLUMN_UPDATABLE;
-exports.SQL_COLUMN_BASE_COLUMN = dba.SQL_COLUMN_BASE_COLUMN;
-exports.SQL_COLUMN_BASE_TABLE = dba.SQL_COLUMN_BASE_TABLE;
-exports.SQL_COLUMN_BASE_SCHEMA = dba.SQL_COLUMN_BASE_SCHEMA;
-exports.SQL_COLUMN_LABEL = dba.SQL_COLUMN_LABEL;
-exports.SQL_COLUMN_MONEY = dba.SQL_COLUMN_MONEY;
-exports.SQL_COLUMN_ALLOC_TYPE = dba.SQL_COLUMN_ALLOC_TYPE;
-exports.SQL_COLUMN_ALLOC_AUTO = dba.SQL_COLUMN_ALLOC_AUTO;
-exports.SQL_COLUMN_ALLOC_USER = dba.SQL_COLUMN_ALLOC_USER;
+exports.SQL_PARAM_INPUT = idb.SQL_PARAM_INPUT;
+exports.SQL_PARAM_OUTPUT = idb.SQL_PARAM_OUTPUT;
+exports.SQL_PARAM_INPUT_OUTPUT = idb.SQL_PARAM_INPUT_OUTPUT;
+exports.SQL_ATTR_APP_ROW_DESC = idb.SQL_ATTR_APP_ROW_DESC;
+exports.SQL_ATTR_APP_PARAM_DESC = idb.SQL_ATTR_APP_PARAM_DESC;
+exports.SQL_ATTR_IMP_ROW_DESC = idb.SQL_ATTR_IMP_ROW_DESC;
+exports.SQL_ATTR_IMP_PARAM_DESC = idb.SQL_ATTR_IMP_PARAM_DESC;
+exports.SQL_ATTR_FOR_FETCH_ONLY = idb.SQL_ATTR_FOR_FETCH_ONLY;
+exports.SQL_ATTR_CONCURRENCY = idb.SQL_ATTR_CONCURRENCY;
+exports.SQL_CONCURRENCY = idb.SQL_CONCURRENCY;
+exports.SQL_ATTR_CURSOR_SCROLLABLE = idb.SQL_ATTR_CURSOR_SCROLLABLE;
+exports.SQL_ATTR_ROWSET_SIZE = idb.SQL_ATTR_ROWSET_SIZE;
+exports.SQL_ROWSET_SIZE = idb.SQL_ROWSET_SIZE;
+exports.SQL_ATTR_ROW_ARRAY_SIZE = idb.SQL_ATTR_ROW_ARRAY_SIZE;
+exports.SQL_ATTR_CURSOR_HOLD = idb.SQL_ATTR_CURSOR_HOLD;
+exports.SQL_ATTR_FULL_OPEN = idb.SQL_ATTR_FULL_OPEN;
+exports.SQL_ATTR_EXTENDED_COL_INFO = idb.SQL_ATTR_EXTENDED_COL_INFO;
+exports.SQL_ATTR_BIND_TYPE = idb.SQL_ATTR_BIND_TYPE;
+exports.SQL_BIND_TYPE = idb.SQL_BIND_TYPE;
+exports.SQL_ATTR_CURSOR_TYPE = idb.SQL_ATTR_CURSOR_TYPE;
+exports.SQL_CURSOR_TYPE = idb.SQL_CURSOR_TYPE;
+exports.SQL_ATTR_CURSOR_SENSITIVITY = idb.SQL_ATTR_CURSOR_SENSITIVITY;
+exports.SQL_CURSOR_SENSITIVE = idb.SQL_CURSOR_SENSITIVE;
+exports.SQL_ATTR_ROW_STATUS_PTR = idb.SQL_ATTR_ROW_STATUS_PTR;
+exports.SQL_ATTR_ROWS_FETCHED_PTR = idb.SQL_ATTR_ROWS_FETCHED_PTR;
+exports.SQL_ATTR_ROW_BIND_TYPE = idb.SQL_ATTR_ROW_BIND_TYPE;
+exports.SQL_ATTR_PARAM_BIND_TYPE = idb.SQL_ATTR_PARAM_BIND_TYPE;
+exports.SQL_ATTR_PARAMSET_SIZE = idb.SQL_ATTR_PARAMSET_SIZE;
+exports.SQL_ATTR_PARAM_STATUS_PTR = idb.SQL_ATTR_PARAM_STATUS_PTR;
+exports.SQL_ATTR_PARAMS_PROCESSED_PTR = idb.SQL_ATTR_PARAMS_PROCESSED_PTR;
+exports.SQL_ATTR_NUMBER_RESULTSET_ROWS_PTR = idb.SQL_ATTR_NUMBER_RESULTSET_ROWS_PTR;
+exports.SQL_BIND_BY_ROW = idb.SQL_BIND_BY_ROW;
+exports.SQL_BIND_BY_COLUMN = idb.SQL_BIND_BY_COLUMN;
+exports.SQL_CURSOR_FORWARD_ONLY = idb.SQL_CURSOR_FORWARD_ONLY;
+exports.SQL_CURSOR_STATIC = idb.SQL_CURSOR_STATIC;
+exports.SQL_CURSOR_DYNAMIC = idb.SQL_CURSOR_DYNAMIC;
+exports.SQL_CURSOR_KEYSET_DRIVEN = idb.SQL_CURSOR_KEYSET_DRIVEN;
+exports.SQL_UNSPECIFIED = idb.SQL_UNSPECIFIED;
+exports.SQL_INSENSITIVE = idb.SQL_INSENSITIVE;
+exports.SQL_SENSITIVE = idb.SQL_SENSITIVE;
+exports.SQL_FETCH_NEXT = idb.SQL_FETCH_NEXT;
+exports.SQL_FETCH_FIRST = idb.SQL_FETCH_FIRST;
+exports.SQL_FETCH_LAST = idb.SQL_FETCH_LAST;
+exports.SQL_FETCH_PRIOR = idb.SQL_FETCH_PRIOR;
+exports.SQL_FETCH_ABSOLUTE = idb.SQL_FETCH_ABSOLUTE;
+exports.SQL_FETCH_RELATIVE = idb.SQL_FETCH_RELATIVE;
+exports.SQL_DESC_COUNT = idb.SQL_DESC_COUNT;
+exports.SQL_DESC_TYPE = idb.SQL_DESC_TYPE;
+exports.SQL_DESC_LENGTH = idb.SQL_DESC_LENGTH;
+exports.SQL_DESC_LENGTH_PTR = idb.SQL_DESC_LENGTH_PTR;
+exports.SQL_DESC_PRECISION = idb.SQL_DESC_PRECISION;
+exports.SQL_DESC_SCALE = idb.SQL_DESC_SCALE;
+exports.SQL_DESC_DATETIME_INTERVAL_CODE = idb.SQL_DESC_DATETIME_INTERVAL_CODE;
+exports.SQL_DESC_NULLABLE = idb.SQL_DESC_NULLABLE;
+exports.SQL_DESC_INDICATOR_PTR = idb.SQL_DESC_INDICATOR_PTR;
+exports.SQL_DESC_DATA_PTR = idb.SQL_DESC_DATA_PTR;
+exports.SQL_DESC_NAME = idb.SQL_DESC_NAME;
+exports.SQL_DESC_UNNAMED = idb.SQL_DESC_UNNAMED;
+exports.SQL_DESC_DISPLAY_SIZE = idb.SQL_DESC_DISPLAY_SIZE;
+exports.SQL_DESC_AUTO_INCREMENT = idb.SQL_DESC_AUTO_INCREMENT;
+exports.SQL_DESC_SEARCHABLE = idb.SQL_DESC_SEARCHABLE;
+exports.SQL_DESC_UPDATABLE = idb.SQL_DESC_UPDATABLE;
+exports.SQL_DESC_BASE_COLUMN = idb.SQL_DESC_BASE_COLUMN;
+exports.SQL_DESC_BASE_TABLE = idb.SQL_DESC_BASE_TABLE;
+exports.SQL_DESC_BASE_SCHEMA = idb.SQL_DESC_BASE_SCHEMA;
+exports.SQL_DESC_LABEL = idb.SQL_DESC_LABEL;
+exports.SQL_DESC_MONEY = idb.SQL_DESC_MONEY;
+exports.SQL_DESC_TYPE_NAME = idb.SQL_DESC_TYPE_NAME;
+exports.SQL_DESC_COLUMN_CCSID = idb.SQL_DESC_COLUMN_CCSID;
+exports.SQL_DESC_ALLOC_TYPE = idb.SQL_DESC_ALLOC_TYPE;
+exports.SQL_DESC_ALLOC_AUTO = idb.SQL_DESC_ALLOC_AUTO;
+exports.SQL_DESC_ALLOC_USER = idb.SQL_DESC_ALLOC_USER;
+exports.SQL_COLUMN_COUNT = idb.SQL_COLUMN_COUNT;
+exports.SQL_COLUMN_TYPE = idb.SQL_COLUMN_TYPE;
+exports.SQL_COLUMN_LENGTH = idb.SQL_COLUMN_LENGTH;
+exports.SQL_COLUMN_LENGTH_PTR = idb.SQL_COLUMN_LENGTH_PTR;
+exports.SQL_COLUMN_PRECISION = idb.SQL_COLUMN_PRECISION;
+exports.SQL_COLUMN_SCALE = idb.SQL_COLUMN_SCALE;
+exports.SQL_COLUMN_DATETIME_INTERVAL_CODE = idb.SQL_COLUMN_DATETIME_INTERVAL_CODE;
+exports.SQL_COLUMN_NULLABLE = idb.SQL_COLUMN_NULLABLE;
+exports.SQL_COLUMN_INDICATOR_PTR = idb.SQL_COLUMN_INDICATOR_PTR;
+exports.SQL_COLUMN_DATA_PTR = idb.SQL_COLUMN_DATA_PTR;
+exports.SQL_COLUMN_NAME = idb.SQL_COLUMN_NAME;
+exports.SQL_COLUMN_UNNAMED = idb.SQL_COLUMN_UNNAMED;
+exports.SQL_COLUMN_DISPLAY_SIZE = idb.SQL_COLUMN_DISPLAY_SIZE;
+exports.SQL_COLUMN_AUTO_INCREMENT = idb.SQL_COLUMN_AUTO_INCREMENT;
+exports.SQL_COLUMN_SEARCHABLE = idb.SQL_COLUMN_SEARCHABLE;
+exports.SQL_COLUMN_UPDATABLE = idb.SQL_COLUMN_UPDATABLE;
+exports.SQL_COLUMN_BASE_COLUMN = idb.SQL_COLUMN_BASE_COLUMN;
+exports.SQL_COLUMN_BASE_TABLE = idb.SQL_COLUMN_BASE_TABLE;
+exports.SQL_COLUMN_BASE_SCHEMA = idb.SQL_COLUMN_BASE_SCHEMA;
+exports.SQL_COLUMN_LABEL = idb.SQL_COLUMN_LABEL;
+exports.SQL_COLUMN_MONEY = idb.SQL_COLUMN_MONEY;
+exports.SQL_COLUMN_ALLOC_TYPE = idb.SQL_COLUMN_ALLOC_TYPE;
+exports.SQL_COLUMN_ALLOC_AUTO = idb.SQL_COLUMN_ALLOC_AUTO;
+exports.SQL_COLUMN_ALLOC_USER = idb.SQL_COLUMN_ALLOC_USER;
 
-exports.SQL_SCOPE_CURROW = dba.SQL_SCOPE_CURROW;
-exports.SQL_SCOPE_TRANSACTION = dba.SQL_SCOPE_TRANSACTION;
-exports.SQL_SCOPE_SESSION = dba.SQL_SCOPE_SESSION;
-exports.SQL_PC_UNKNOWN = dba.SQL_PC_UNKNOWN;
-exports.SQL_PC_NOT_PSEUDO = dba.SQL_PC_NOT_PSEUDO;
-exports.SQL_PC_PSEUDO = dba.SQL_PC_PSEUDO;
+exports.SQL_SCOPE_CURROW = idb.SQL_SCOPE_CURROW;
+exports.SQL_SCOPE_TRANSACTION = idb.SQL_SCOPE_TRANSACTION;
+exports.SQL_SCOPE_SESSION = idb.SQL_SCOPE_SESSION;
+exports.SQL_PC_UNKNOWN = idb.SQL_PC_UNKNOWN;
+exports.SQL_PC_NOT_PSEUDO = idb.SQL_PC_NOT_PSEUDO;
+exports.SQL_PC_PSEUDO = idb.SQL_PC_PSEUDO;
 
-exports.SQL_ATTR_AUTO_IPD = dba.SQL_ATTR_AUTO_IPD;
-exports.SQL_ATTR_ACCESS_MODE = dba.SQL_ATTR_ACCESS_MODE;
-exports.SQL_ACCESS_MODE = dba.SQL_ACCESS_MODE;
-exports.SQL_ATTR_AUTOCOMMIT = dba.SQL_ATTR_AUTOCOMMIT;
-exports.SQL_AUTOCOMMIT = dba.SQL_AUTOCOMMIT;
-exports.SQL_ATTR_DBC_SYS_NAMING = dba.SQL_ATTR_DBC_SYS_NAMING;
-exports.SQL_ATTR_DBC_DEFAULT_LIB = dba.SQL_ATTR_DBC_DEFAULT_LIB;
-exports.SQL_ATTR_ADOPT_OWNER_AUTH = dba.SQL_ATTR_ADOPT_OWNER_AUTH;
-exports.SQL_ATTR_SYSBAS_CMT = dba.SQL_ATTR_SYSBAS_CMT;
-exports.SQL_ATTR_SET_SSA = dba.SQL_ATTR_SET_SSA;
-exports.SQL_HEX_SORT_SEQUENCE = dba.SQL_HEX_SORT_SEQUENCE;
-exports.SQL_JOB_SORT_SEQUENCE = dba.SQL_JOB_SORT_SEQUENCE;
-exports.SQL_JOBRUN_SORT_SEQUENCE = dba.SQL_JOBRUN_SORT_SEQUENCE;
-exports.SQL_ATTR_COMMIT = dba.SQL_ATTR_COMMIT;
-exports.SQL_MODE_READ_ONLY = dba.SQL_MODE_READ_ONLY;
-exports.SQL_MODE_READ_WRITE = dba.SQL_MODE_READ_WRITE;
-exports.SQL_MODE_DEFAULT = dba.SQL_MODE_DEFAULT;
-exports.SQL_AUTOCOMMIT_OFF = dba.SQL_AUTOCOMMIT_OFF;
-exports.SQL_AUTOCOMMIT_ON = dba.SQL_AUTOCOMMIT_ON;
-exports.SQL_TXN_ISOLATION = dba.SQL_TXN_ISOLATION;
-exports.SQL_ATTR_TXN_ISOLATION = dba.SQL_ATTR_TXN_ISOLATION;
-exports.SQL_COMMIT_NONE = dba.SQL_COMMIT_NONE;
-exports.SQL_TXN_NO_COMMIT = dba.SQL_TXN_NO_COMMIT;
-exports.SQL_TXN_NOCOMMIT = dba.SQL_TXN_NOCOMMIT;
-exports.SQL_COMMIT_CHG = dba.SQL_COMMIT_CHG;
-exports.SQL_COMMIT_UR = dba.SQL_COMMIT_UR;
-exports.SQL_TXN_READ_UNCOMMITTED = dba.SQL_TXN_READ_UNCOMMITTED;
-exports.SQL_COMMIT_CS = dba.SQL_COMMIT_CS;
-exports.SQL_TXN_READ_COMMITTED = dba.SQL_TXN_READ_COMMITTED;
-exports.SQL_COMMIT_ALL = dba.SQL_COMMIT_ALL;
-exports.SQL_COMMIT_RS = dba.SQL_COMMIT_RS;
-exports.SQL_TXN_REPEATABLE_READ = dba.SQL_TXN_REPEATABLE_READ;
-exports.SQL_COMMIT_RR = dba.SQL_COMMIT_RR;
-exports.SQL_TXN_SERIALIZABLE = dba.SQL_TXN_SERIALIZABLE;
+exports.SQL_ATTR_AUTO_IPD = idb.SQL_ATTR_AUTO_IPD;
+exports.SQL_ATTR_ACCESS_MODE = idb.SQL_ATTR_ACCESS_MODE;
+exports.SQL_ACCESS_MODE = idb.SQL_ACCESS_MODE;
+exports.SQL_ATTR_AUTOCOMMIT = idb.SQL_ATTR_AUTOCOMMIT;
+exports.SQL_AUTOCOMMIT = idb.SQL_AUTOCOMMIT;
+exports.SQL_ATTR_DBC_SYS_NAMING = idb.SQL_ATTR_DBC_SYS_NAMING;
+exports.SQL_ATTR_DBC_DEFAULT_LIB = idb.SQL_ATTR_DBC_DEFAULT_LIB;
+exports.SQL_ATTR_ADOPT_OWNER_AUTH = idb.SQL_ATTR_ADOPT_OWNER_AUTH;
+exports.SQL_ATTR_SYSBAS_CMT = idb.SQL_ATTR_SYSBAS_CMT;
+exports.SQL_ATTR_SET_SSA = idb.SQL_ATTR_SET_SSA;
+exports.SQL_HEX_SORT_SEQUENCE = idb.SQL_HEX_SORT_SEQUENCE;
+exports.SQL_JOB_SORT_SEQUENCE = idb.SQL_JOB_SORT_SEQUENCE;
+exports.SQL_JOBRUN_SORT_SEQUENCE = idb.SQL_JOBRUN_SORT_SEQUENCE;
+exports.SQL_ATTR_COMMIT = idb.SQL_ATTR_COMMIT;
+exports.SQL_MODE_READ_ONLY = idb.SQL_MODE_READ_ONLY;
+exports.SQL_MODE_READ_WRITE = idb.SQL_MODE_READ_WRITE;
+exports.SQL_MODE_DEFAULT = idb.SQL_MODE_DEFAULT;
+exports.SQL_AUTOCOMMIT_OFF = idb.SQL_AUTOCOMMIT_OFF;
+exports.SQL_AUTOCOMMIT_ON = idb.SQL_AUTOCOMMIT_ON;
+exports.SQL_TXN_ISOLATION = idb.SQL_TXN_ISOLATION;
+exports.SQL_ATTR_TXN_ISOLATION = idb.SQL_ATTR_TXN_ISOLATION;
+exports.SQL_COMMIT_NONE = idb.SQL_COMMIT_NONE;
+exports.SQL_TXN_NO_COMMIT = idb.SQL_TXN_NO_COMMIT;
+exports.SQL_TXN_NOCOMMIT = idb.SQL_TXN_NOCOMMIT;
+exports.SQL_COMMIT_CHG = idb.SQL_COMMIT_CHG;
+exports.SQL_COMMIT_UR = idb.SQL_COMMIT_UR;
+exports.SQL_TXN_READ_UNCOMMITTED = idb.SQL_TXN_READ_UNCOMMITTED;
+exports.SQL_COMMIT_CS = idb.SQL_COMMIT_CS;
+exports.SQL_TXN_READ_COMMITTED = idb.SQL_TXN_READ_COMMITTED;
+exports.SQL_COMMIT_ALL = idb.SQL_COMMIT_ALL;
+exports.SQL_COMMIT_RS = idb.SQL_COMMIT_RS;
+exports.SQL_TXN_REPEATABLE_READ = idb.SQL_TXN_REPEATABLE_READ;
+exports.SQL_COMMIT_RR = idb.SQL_COMMIT_RR;
+exports.SQL_TXN_SERIALIZABLE = idb.SQL_TXN_SERIALIZABLE;
 
-exports.SQL_INDEX_UNIQUE = dba.SQL_INDEX_UNIQUE;
-exports.SQL_INDEX_ALL = dba.SQL_INDEX_ALL;
-exports.SQL_INDEX_OTHER = dba.SQL_INDEX_OTHER;
-exports.SQL_TABLE_STAT = dba.SQL_TABLE_STAT;
-exports.SQL_ENSURE = dba.SQL_ENSURE;
-exports.SQL_QUICK = dba.SQL_QUICK;
+exports.SQL_INDEX_UNIQUE = idb.SQL_INDEX_UNIQUE;
+exports.SQL_INDEX_ALL = idb.SQL_INDEX_ALL;
+exports.SQL_INDEX_OTHER = idb.SQL_INDEX_OTHER;
+exports.SQL_TABLE_STAT = idb.SQL_TABLE_STAT;
+exports.SQL_ENSURE = idb.SQL_ENSURE;
+exports.SQL_QUICK = idb.SQL_QUICK;
 
-exports.SQL_ATTR_TRACE_CLI = dba.SQL_ATTR_TRACE_CLI;
-exports.SQL_ATTR_TRACE_DBMON = dba.SQL_ATTR_TRACE_DBMON;
-exports.SQL_ATTR_TRACE_DEBUG = dba.SQL_ATTR_TRACE_DEBUG;
-exports.SQL_ATTR_TRACE_JOBLOG = dba.SQL_ATTR_TRACE_JOBLOG;
-exports.SQL_ATTR_TRACE_STRTRC = dba.SQL_ATTR_TRACE_STRTRC;
+exports.SQL_ATTR_TRACE_CLI = idb.SQL_ATTR_TRACE_CLI;
+exports.SQL_ATTR_TRACE_DBMON = idb.SQL_ATTR_TRACE_DBMON;
+exports.SQL_ATTR_TRACE_DEBUG = idb.SQL_ATTR_TRACE_DEBUG;
+exports.SQL_ATTR_TRACE_JOBLOG = idb.SQL_ATTR_TRACE_JOBLOG;
+exports.SQL_ATTR_TRACE_STRTRC = idb.SQL_ATTR_TRACE_STRTRC;
 
-exports.SQL_FILE_READ = dba.SQL_FILE_READ;
-exports.SQL_FILE_CREATE = dba.SQL_FILE_CREATE;
-exports.SQL_FILE_OVERWRITE = dba.SQL_FILE_OVERWRITE;
-exports.SQL_FILE_APPEND = dba.SQL_FILE_APPEND;
+exports.SQL_FILE_READ = idb.SQL_FILE_READ;
+exports.SQL_FILE_CREATE = idb.SQL_FILE_CREATE;
+exports.SQL_FILE_OVERWRITE = idb.SQL_FILE_OVERWRITE;
+exports.SQL_FILE_APPEND = idb.SQL_FILE_APPEND;
 
-exports.SQL_DIAG_RETURNCODE = dba.SQL_DIAG_RETURNCODE;
-exports.SQL_DIAG_NUMBER = dba.SQL_DIAG_NUMBER;
-exports.SQL_DIAG_ROW_COUNT = dba.SQL_DIAG_ROW_COUNT;
-exports.SQL_DIAG_SQLSTATE = dba.SQL_DIAG_SQLSTATE;
-exports.SQL_DIAG_NATIVE = dba.SQL_DIAG_NATIVE;
-exports.SQL_DIAG_MESSAGE_TEXT = dba.SQL_DIAG_MESSAGE_TEXT;
-exports.SQL_DIAG_DYNAMIC_FUNCTION = dba.SQL_DIAG_DYNAMIC_FUNCTION;
-exports.SQL_DIAG_CLASS_ORIGIN = dba.SQL_DIAG_CLASS_ORIGIN;
-exports.SQL_DIAG_SUBCLASS_ORIGIN = dba.SQL_DIAG_SUBCLASS_ORIGIN;
-exports.SQL_DIAG_CONNECTION_NAME = dba.SQL_DIAG_CONNECTION_NAME;
-exports.SQL_DIAG_SERVER_NAME = dba.SQL_DIAG_SERVER_NAME;
-exports.SQL_DIAG_MESSAGE_TOKENS = dba.SQL_DIAG_MESSAGE_TOKENS;
-exports.SQL_DIAG_AUTOGEN_KEY = dba.SQL_DIAG_AUTOGEN_KEY;
-exports.SQL_UNSEARCHABLE = dba.SQL_UNSEARCHABLE;
-exports.SQL_LIKE_ONLY = dba.SQL_LIKE_ONLY;
-exports.SQL_ALL_EXCEPT_LIKE = dba.SQL_ALL_EXCEPT_LIKE;
-exports.SQL_SEARCHABLE = dba.SQL_SEARCHABLE;
+exports.SQL_DIAG_RETURNCODE = idb.SQL_DIAG_RETURNCODE;
+exports.SQL_DIAG_NUMBER = idb.SQL_DIAG_NUMBER;
+exports.SQL_DIAG_ROW_COUNT = idb.SQL_DIAG_ROW_COUNT;
+exports.SQL_DIAG_SQLSTATE = idb.SQL_DIAG_SQLSTATE;
+exports.SQL_DIAG_NATIVE = idb.SQL_DIAG_NATIVE;
+exports.SQL_DIAG_MESSAGE_TEXT = idb.SQL_DIAG_MESSAGE_TEXT;
+exports.SQL_DIAG_DYNAMIC_FUNCTION = idb.SQL_DIAG_DYNAMIC_FUNCTION;
+exports.SQL_DIAG_CLASS_ORIGIN = idb.SQL_DIAG_CLASS_ORIGIN;
+exports.SQL_DIAG_SUBCLASS_ORIGIN = idb.SQL_DIAG_SUBCLASS_ORIGIN;
+exports.SQL_DIAG_CONNECTION_NAME = idb.SQL_DIAG_CONNECTION_NAME;
+exports.SQL_DIAG_SERVER_NAME = idb.SQL_DIAG_SERVER_NAME;
+exports.SQL_DIAG_MESSAGE_TOKENS = idb.SQL_DIAG_MESSAGE_TOKENS;
+exports.SQL_DIAG_AUTOGEN_KEY = idb.SQL_DIAG_AUTOGEN_KEY;
+exports.SQL_UNSEARCHABLE = idb.SQL_UNSEARCHABLE;
+exports.SQL_LIKE_ONLY = idb.SQL_LIKE_ONLY;
+exports.SQL_ALL_EXCEPT_LIKE = idb.SQL_ALL_EXCEPT_LIKE;
+exports.SQL_SEARCHABLE = idb.SQL_SEARCHABLE;
 
-exports.SQL_API_SQLALLOCCONNECT = dba.SQL_API_SQLALLOCCONNECT;
-exports.SQL_API_SQLALLOCENV = dba.SQL_API_SQLALLOCENV;
-exports.SQL_API_SQLALLOCHANDLE = dba.SQL_API_SQLALLOCHANDLE;
-exports.SQL_API_SQLALLOCSTMT = dba.SQL_API_SQLALLOCSTMT;
-exports.SQL_API_SQLBINDCOL = dba.SQL_API_SQLBINDCOL;
-exports.SQL_API_SQLBINDFILETOCOL = dba.SQL_API_SQLBINDFILETOCOL;
-exports.SQL_API_SQLBINDFILETOPARAM = dba.SQL_API_SQLBINDFILETOPARAM;
-exports.SQL_API_SQLBINDPARAM = dba.SQL_API_SQLBINDPARAM;
-exports.SQL_API_SQLBINDPARAMETER = dba.SQL_API_SQLBINDPARAMETER;
-exports.SQL_API_SQLCANCEL = dba.SQL_API_SQLCANCEL;
-exports.SQL_API_SQLCLOSECURSOR = dba.SQL_API_SQLCLOSECURSOR;
-exports.SQL_API_SQLCOLATTRIBUTE = dba.SQL_API_SQLCOLATTRIBUTE;
-exports.SQL_API_SQLCOLATTRIBUTEW = dba.SQL_API_SQLCOLATTRIBUTEW;
-exports.SQL_API_SQLCOLATTRIBUTES = dba.SQL_API_SQLCOLATTRIBUTES;
-exports.SQL_API_SQLCOLATTRIBUTESW = dba.SQL_API_SQLCOLATTRIBUTESW;
-exports.SQL_API_SQLCOLUMNPRIVILEGES = dba.SQL_API_SQLCOLUMNPRIVILEGES;
-exports.SQL_API_SQLCOLUMNPRIVILEGESW = dba.SQL_API_SQLCOLUMNPRIVILEGESW;
-exports.SQL_API_SQLCOLUMNS = dba.SQL_API_SQLCOLUMNS;
-exports.SQL_API_SQLCOLUMNSW = dba.SQL_API_SQLCOLUMNSW;
-exports.SQL_API_SQLCONNECT = dba.SQL_API_SQLCONNECT;
-exports.SQL_API_SQLCONNECTW = dba.SQL_API_SQLCONNECTW;
-exports.SQL_API_SQLCOPYDESC = dba.SQL_API_SQLCOPYDESC;
-exports.SQL_API_SQLDATASOURCES = dba.SQL_API_SQLDATASOURCES;
-exports.SQL_API_SQLDATASOURCESW = dba.SQL_API_SQLDATASOURCESW;
-exports.SQL_API_SQLDESCRIBECOL = dba.SQL_API_SQLDESCRIBECOL;
-exports.SQL_API_SQLDESCRIBECOLW = dba.SQL_API_SQLDESCRIBECOLW;
-exports.SQL_API_SQLDESCRIBEPARAM = dba.SQL_API_SQLDESCRIBEPARAM;
-exports.SQL_API_SQLDISCONNECT = dba.SQL_API_SQLDISCONNECT;
-exports.SQL_API_SQLDRIVERCONNECT = dba.SQL_API_SQLDRIVERCONNECT;
-exports.SQL_API_SQLENDTRAN = dba.SQL_API_SQLENDTRAN;
-exports.SQL_API_SQLERROR = dba.SQL_API_SQLERROR;
-exports.SQL_API_SQLERRORW = dba.SQL_API_SQLERRORW;
-exports.SQL_API_SQLEXECDIRECT = dba.SQL_API_SQLEXECDIRECT;
-exports.SQL_API_SQLEXECDIRECTW = dba.SQL_API_SQLEXECDIRECTW;
-exports.SQL_API_SQLEXECUTE = dba.SQL_API_SQLEXECUTE;
-exports.SQL_API_SQLEXTENDEDFETCH = dba.SQL_API_SQLEXTENDEDFETCH;
-exports.SQL_API_SQLFETCH = dba.SQL_API_SQLFETCH;
-exports.SQL_API_SQLFETCHSCROLL = dba.SQL_API_SQLFETCHSCROLL;
-exports.SQL_API_SQLFOREIGNKEYS = dba.SQL_API_SQLFOREIGNKEYS;
-exports.SQL_API_SQLFOREIGNKEYSW = dba.SQL_API_SQLFOREIGNKEYSW;
-exports.SQL_API_SQLFREECONNECT = dba.SQL_API_SQLFREECONNECT;
-exports.SQL_API_SQLFREEENV = dba.SQL_API_SQLFREEENV;
-exports.SQL_API_SQLFREEHANDLE = dba.SQL_API_SQLFREEHANDLE;
-exports.SQL_API_SQLFREESTMT = dba.SQL_API_SQLFREESTMT;
-exports.SQL_API_SQLGETCOL = dba.SQL_API_SQLGETCOL;
-exports.SQL_API_SQLGETCOLW = dba.SQL_API_SQLGETCOLW;
-exports.SQL_API_SQLGETCONNECTATTR = dba.SQL_API_SQLGETCONNECTATTR;
-exports.SQL_API_SQLGETCONNECTATTRW = dba.SQL_API_SQLGETCONNECTATTRW;
-exports.SQL_API_SQLGETCONNECTOPTION = dba.SQL_API_SQLGETCONNECTOPTION;
-exports.SQL_API_SQLGETCONNECTOPTIONW = dba.SQL_API_SQLGETCONNECTOPTIONW;
-exports.SQL_API_SQLGETCURSORNAME = dba.SQL_API_SQLGETCURSORNAME;
-exports.SQL_API_SQLGETCURSORNAMEW = dba.SQL_API_SQLGETCURSORNAMEW;
-exports.SQL_API_SQLGETDATA = dba.SQL_API_SQLGETDATA;
-exports.SQL_API_SQLGETDESCFIELD = dba.SQL_API_SQLGETDESCFIELD;
-exports.SQL_API_SQLGETDESCFIELDW = dba.SQL_API_SQLGETDESCFIELDW;
-exports.SQL_API_SQLGETDESCREC = dba.SQL_API_SQLGETDESCREC;
-exports.SQL_API_SQLGETDESCRECW = dba.SQL_API_SQLGETDESCRECW;
-exports.SQL_API_SQLGETDIAGFIELD = dba.SQL_API_SQLGETDIAGFIELD;
-exports.SQL_API_SQLGETDIAGFIELDW = dba.SQL_API_SQLGETDIAGFIELDW;
-exports.SQL_API_SQLGETDIAGREC = dba.SQL_API_SQLGETDIAGREC;
-exports.SQL_API_SQLGETDIAGRECW = dba.SQL_API_SQLGETDIAGRECW;
-exports.SQL_API_SQLGETENVATTR = dba.SQL_API_SQLGETENVATTR;
-exports.SQL_API_SQLGETFUNCTIONS = dba.SQL_API_SQLGETFUNCTIONS;
-exports.SQL_API_SQLGETINFO = dba.SQL_API_SQLGETINFO;
-exports.SQL_API_SQLGETINFOW = dba.SQL_API_SQLGETINFOW;
-exports.SQL_API_SQLGETLENGTH = dba.SQL_API_SQLGETLENGTH;
-exports.SQL_API_SQLGETPOSITION = dba.SQL_API_SQLGETPOSITION;
-exports.SQL_API_SQLGETPOSITIONW = dba.SQL_API_SQLGETPOSITIONW;
-exports.SQL_API_SQLGETSTMTATTR = dba.SQL_API_SQLGETSTMTATTR;
-exports.SQL_API_SQLGETSTMTATTRW = dba.SQL_API_SQLGETSTMTATTRW;
-exports.SQL_API_SQLGETSTMTOPTION = dba.SQL_API_SQLGETSTMTOPTION;
-exports.SQL_API_SQLGETSTMTOPTIONW = dba.SQL_API_SQLGETSTMTOPTIONW;
-exports.SQL_API_SQLGETSUBSTRING = dba.SQL_API_SQLGETSUBSTRING;
-exports.SQL_API_SQLGETSUBSTRINGW = dba.SQL_API_SQLGETSUBSTRINGW;
-exports.SQL_API_SQLGETTYPEINFO = dba.SQL_API_SQLGETTYPEINFO;
-exports.SQL_API_SQLGETTYPEINFOW = dba.SQL_API_SQLGETTYPEINFOW;
-exports.SQL_API_SQLLANGUAGES = dba.SQL_API_SQLLANGUAGES;
-exports.SQL_API_SQLMORERESULTS = dba.SQL_API_SQLMORERESULTS;
-exports.SQL_API_SQLNATIVESQL = dba.SQL_API_SQLNATIVESQL;
-exports.SQL_API_SQLNATIVESQLW = dba.SQL_API_SQLNATIVESQLW;
-exports.SQL_API_SQLNEXTRESULT = dba.SQL_API_SQLNEXTRESULT;
-exports.SQL_API_SQLNUMPARAMS = dba.SQL_API_SQLNUMPARAMS;
-exports.SQL_API_SQLNUMRESULTCOLS = dba.SQL_API_SQLNUMRESULTCOLS;
-exports.SQL_API_SQLPARAMDATA = dba.SQL_API_SQLPARAMDATA;
-exports.SQL_API_SQLPARAMOPTIONS = dba.SQL_API_SQLPARAMOPTIONS;
-exports.SQL_API_SQLPREPARE = dba.SQL_API_SQLPREPARE;
-exports.SQL_API_SQLPREPAREW = dba.SQL_API_SQLPREPAREW;
-exports.SQL_API_SQLPRIMARYKEYS = dba.SQL_API_SQLPRIMARYKEYS;
-exports.SQL_API_SQLPRIMARYKEYSW = dba.SQL_API_SQLPRIMARYKEYSW;
-exports.SQL_API_SQLPROCEDURECOLUMNS = dba.SQL_API_SQLPROCEDURECOLUMNS;
-exports.SQL_API_SQLPROCEDURECOLUMNSW = dba.SQL_API_SQLPROCEDURECOLUMNSW;
-exports.SQL_API_SQLPROCEDURES = dba.SQL_API_SQLPROCEDURES;
-exports.SQL_API_SQLPROCEDURESW = dba.SQL_API_SQLPROCEDURESW;
-exports.SQL_API_SQLPUTDATA = dba.SQL_API_SQLPUTDATA;
-exports.SQL_API_SQLRELEASEENV = dba.SQL_API_SQLRELEASEENV;
-exports.SQL_API_SQLROWCOUNT = dba.SQL_API_SQLROWCOUNT;
-exports.SQL_API_SQLSETCONNECTATTR = dba.SQL_API_SQLSETCONNECTATTR;
-exports.SQL_API_SQLSETCONNECTATTRW = dba.SQL_API_SQLSETCONNECTATTRW;
-exports.SQL_API_SQLSETCONNECTOPTION = dba.SQL_API_SQLSETCONNECTOPTION;
-exports.SQL_API_SQLSETCONNECTOPTIONW = dba.SQL_API_SQLSETCONNECTOPTIONW;
-exports.SQL_API_SQLSETCURSORNAME = dba.SQL_API_SQLSETCURSORNAME;
-exports.SQL_API_SQLSETCURSORNAMEW = dba.SQL_API_SQLSETCURSORNAMEW;
-exports.SQL_API_SQLSETDESCFIELD = dba.SQL_API_SQLSETDESCFIELD;
-exports.SQL_API_SQLSETDESCFIELDW = dba.SQL_API_SQLSETDESCFIELDW;
-exports.SQL_API_SQLSETDESCREC = dba.SQL_API_SQLSETDESCREC;
-exports.SQL_API_SQLSETENVATTR = dba.SQL_API_SQLSETENVATTR;
-exports.SQL_API_SQLSETPARAM = dba.SQL_API_SQLSETPARAM;
-exports.SQL_API_SQLSETSTMTATTR = dba.SQL_API_SQLSETSTMTATTR;
-exports.SQL_API_SQLSETSTMTATTRW = dba.SQL_API_SQLSETSTMTATTRW;
-exports.SQL_API_SQLSETSTMTOPTION = dba.SQL_API_SQLSETSTMTOPTION;
-exports.SQL_API_SQLSETSTMTOPTIONW = dba.SQL_API_SQLSETSTMTOPTIONW;
-exports.SQL_API_SQLSPECIALCOLUMNS = dba.SQL_API_SQLSPECIALCOLUMNS;
-exports.SQL_API_SQLSPECIALCOLUMNSW = dba.SQL_API_SQLSPECIALCOLUMNSW;
-exports.SQL_API_SQLSTARTTRAN = dba.SQL_API_SQLSTARTTRAN;
-exports.SQL_API_SQLSTATISTICS = dba.SQL_API_SQLSTATISTICS;
-exports.SQL_API_SQLSTATISTICSW = dba.SQL_API_SQLSTATISTICSW;
-exports.SQL_API_SQLTABLEPRIVILEGES = dba.SQL_API_SQLTABLEPRIVILEGES;
-exports.SQL_API_SQLTABLEPRIVILEGESW = dba.SQL_API_SQLTABLEPRIVILEGESW;
-exports.SQL_API_SQLTABLES = dba.SQL_API_SQLTABLES;
-exports.SQL_API_SQLTABLESW = dba.SQL_API_SQLTABLESW;
-exports.SQL_API_SQLTRANSACT = dba.SQL_API_SQLTRANSACT;
-exports.SQL_API_SQLSETPOS = dba.SQL_API_SQLSETPOS;
+exports.SQL_API_SQLALLOCCONNECT = idb.SQL_API_SQLALLOCCONNECT;
+exports.SQL_API_SQLALLOCENV = idb.SQL_API_SQLALLOCENV;
+exports.SQL_API_SQLALLOCHANDLE = idb.SQL_API_SQLALLOCHANDLE;
+exports.SQL_API_SQLALLOCSTMT = idb.SQL_API_SQLALLOCSTMT;
+exports.SQL_API_SQLBINDCOL = idb.SQL_API_SQLBINDCOL;
+exports.SQL_API_SQLBINDFILETOCOL = idb.SQL_API_SQLBINDFILETOCOL;
+exports.SQL_API_SQLBINDFILETOPARAM = idb.SQL_API_SQLBINDFILETOPARAM;
+exports.SQL_API_SQLBINDPARAM = idb.SQL_API_SQLBINDPARAM;
+exports.SQL_API_SQLBINDPARAMETER = idb.SQL_API_SQLBINDPARAMETER;
+exports.SQL_API_SQLCANCEL = idb.SQL_API_SQLCANCEL;
+exports.SQL_API_SQLCLOSECURSOR = idb.SQL_API_SQLCLOSECURSOR;
+exports.SQL_API_SQLCOLATTRIBUTE = idb.SQL_API_SQLCOLATTRIBUTE;
+exports.SQL_API_SQLCOLATTRIBUTEW = idb.SQL_API_SQLCOLATTRIBUTEW;
+exports.SQL_API_SQLCOLATTRIBUTES = idb.SQL_API_SQLCOLATTRIBUTES;
+exports.SQL_API_SQLCOLATTRIBUTESW = idb.SQL_API_SQLCOLATTRIBUTESW;
+exports.SQL_API_SQLCOLUMNPRIVILEGES = idb.SQL_API_SQLCOLUMNPRIVILEGES;
+exports.SQL_API_SQLCOLUMNPRIVILEGESW = idb.SQL_API_SQLCOLUMNPRIVILEGESW;
+exports.SQL_API_SQLCOLUMNS = idb.SQL_API_SQLCOLUMNS;
+exports.SQL_API_SQLCOLUMNSW = idb.SQL_API_SQLCOLUMNSW;
+exports.SQL_API_SQLCONNECT = idb.SQL_API_SQLCONNECT;
+exports.SQL_API_SQLCONNECTW = idb.SQL_API_SQLCONNECTW;
+exports.SQL_API_SQLCOPYDESC = idb.SQL_API_SQLCOPYDESC;
+exports.SQL_API_SQLDATASOURCES = idb.SQL_API_SQLDATASOURCES;
+exports.SQL_API_SQLDATASOURCESW = idb.SQL_API_SQLDATASOURCESW;
+exports.SQL_API_SQLDESCRIBECOL = idb.SQL_API_SQLDESCRIBECOL;
+exports.SQL_API_SQLDESCRIBECOLW = idb.SQL_API_SQLDESCRIBECOLW;
+exports.SQL_API_SQLDESCRIBEPARAM = idb.SQL_API_SQLDESCRIBEPARAM;
+exports.SQL_API_SQLDISCONNECT = idb.SQL_API_SQLDISCONNECT;
+exports.SQL_API_SQLDRIVERCONNECT = idb.SQL_API_SQLDRIVERCONNECT;
+exports.SQL_API_SQLENDTRAN = idb.SQL_API_SQLENDTRAN;
+exports.SQL_API_SQLERROR = idb.SQL_API_SQLERROR;
+exports.SQL_API_SQLERRORW = idb.SQL_API_SQLERRORW;
+exports.SQL_API_SQLEXECDIRECT = idb.SQL_API_SQLEXECDIRECT;
+exports.SQL_API_SQLEXECDIRECTW = idb.SQL_API_SQLEXECDIRECTW;
+exports.SQL_API_SQLEXECUTE = idb.SQL_API_SQLEXECUTE;
+exports.SQL_API_SQLEXTENDEDFETCH = idb.SQL_API_SQLEXTENDEDFETCH;
+exports.SQL_API_SQLFETCH = idb.SQL_API_SQLFETCH;
+exports.SQL_API_SQLFETCHSCROLL = idb.SQL_API_SQLFETCHSCROLL;
+exports.SQL_API_SQLFOREIGNKEYS = idb.SQL_API_SQLFOREIGNKEYS;
+exports.SQL_API_SQLFOREIGNKEYSW = idb.SQL_API_SQLFOREIGNKEYSW;
+exports.SQL_API_SQLFREECONNECT = idb.SQL_API_SQLFREECONNECT;
+exports.SQL_API_SQLFREEENV = idb.SQL_API_SQLFREEENV;
+exports.SQL_API_SQLFREEHANDLE = idb.SQL_API_SQLFREEHANDLE;
+exports.SQL_API_SQLFREESTMT = idb.SQL_API_SQLFREESTMT;
+exports.SQL_API_SQLGETCOL = idb.SQL_API_SQLGETCOL;
+exports.SQL_API_SQLGETCOLW = idb.SQL_API_SQLGETCOLW;
+exports.SQL_API_SQLGETCONNECTATTR = idb.SQL_API_SQLGETCONNECTATTR;
+exports.SQL_API_SQLGETCONNECTATTRW = idb.SQL_API_SQLGETCONNECTATTRW;
+exports.SQL_API_SQLGETCONNECTOPTION = idb.SQL_API_SQLGETCONNECTOPTION;
+exports.SQL_API_SQLGETCONNECTOPTIONW = idb.SQL_API_SQLGETCONNECTOPTIONW;
+exports.SQL_API_SQLGETCURSORNAME = idb.SQL_API_SQLGETCURSORNAME;
+exports.SQL_API_SQLGETCURSORNAMEW = idb.SQL_API_SQLGETCURSORNAMEW;
+exports.SQL_API_SQLGETDATA = idb.SQL_API_SQLGETDATA;
+exports.SQL_API_SQLGETDESCFIELD = idb.SQL_API_SQLGETDESCFIELD;
+exports.SQL_API_SQLGETDESCFIELDW = idb.SQL_API_SQLGETDESCFIELDW;
+exports.SQL_API_SQLGETDESCREC = idb.SQL_API_SQLGETDESCREC;
+exports.SQL_API_SQLGETDESCRECW = idb.SQL_API_SQLGETDESCRECW;
+exports.SQL_API_SQLGETDIAGFIELD = idb.SQL_API_SQLGETDIAGFIELD;
+exports.SQL_API_SQLGETDIAGFIELDW = idb.SQL_API_SQLGETDIAGFIELDW;
+exports.SQL_API_SQLGETDIAGREC = idb.SQL_API_SQLGETDIAGREC;
+exports.SQL_API_SQLGETDIAGRECW = idb.SQL_API_SQLGETDIAGRECW;
+exports.SQL_API_SQLGETENVATTR = idb.SQL_API_SQLGETENVATTR;
+exports.SQL_API_SQLGETFUNCTIONS = idb.SQL_API_SQLGETFUNCTIONS;
+exports.SQL_API_SQLGETINFO = idb.SQL_API_SQLGETINFO;
+exports.SQL_API_SQLGETINFOW = idb.SQL_API_SQLGETINFOW;
+exports.SQL_API_SQLGETLENGTH = idb.SQL_API_SQLGETLENGTH;
+exports.SQL_API_SQLGETPOSITION = idb.SQL_API_SQLGETPOSITION;
+exports.SQL_API_SQLGETPOSITIONW = idb.SQL_API_SQLGETPOSITIONW;
+exports.SQL_API_SQLGETSTMTATTR = idb.SQL_API_SQLGETSTMTATTR;
+exports.SQL_API_SQLGETSTMTATTRW = idb.SQL_API_SQLGETSTMTATTRW;
+exports.SQL_API_SQLGETSTMTOPTION = idb.SQL_API_SQLGETSTMTOPTION;
+exports.SQL_API_SQLGETSTMTOPTIONW = idb.SQL_API_SQLGETSTMTOPTIONW;
+exports.SQL_API_SQLGETSUBSTRING = idb.SQL_API_SQLGETSUBSTRING;
+exports.SQL_API_SQLGETSUBSTRINGW = idb.SQL_API_SQLGETSUBSTRINGW;
+exports.SQL_API_SQLGETTYPEINFO = idb.SQL_API_SQLGETTYPEINFO;
+exports.SQL_API_SQLGETTYPEINFOW = idb.SQL_API_SQLGETTYPEINFOW;
+exports.SQL_API_SQLLANGUAGES = idb.SQL_API_SQLLANGUAGES;
+exports.SQL_API_SQLMORERESULTS = idb.SQL_API_SQLMORERESULTS;
+exports.SQL_API_SQLNATIVESQL = idb.SQL_API_SQLNATIVESQL;
+exports.SQL_API_SQLNATIVESQLW = idb.SQL_API_SQLNATIVESQLW;
+exports.SQL_API_SQLNEXTRESULT = idb.SQL_API_SQLNEXTRESULT;
+exports.SQL_API_SQLNUMPARAMS = idb.SQL_API_SQLNUMPARAMS;
+exports.SQL_API_SQLNUMRESULTCOLS = idb.SQL_API_SQLNUMRESULTCOLS;
+exports.SQL_API_SQLPARAMDATA = idb.SQL_API_SQLPARAMDATA;
+exports.SQL_API_SQLPARAMOPTIONS = idb.SQL_API_SQLPARAMOPTIONS;
+exports.SQL_API_SQLPREPARE = idb.SQL_API_SQLPREPARE;
+exports.SQL_API_SQLPREPAREW = idb.SQL_API_SQLPREPAREW;
+exports.SQL_API_SQLPRIMARYKEYS = idb.SQL_API_SQLPRIMARYKEYS;
+exports.SQL_API_SQLPRIMARYKEYSW = idb.SQL_API_SQLPRIMARYKEYSW;
+exports.SQL_API_SQLPROCEDURECOLUMNS = idb.SQL_API_SQLPROCEDURECOLUMNS;
+exports.SQL_API_SQLPROCEDURECOLUMNSW = idb.SQL_API_SQLPROCEDURECOLUMNSW;
+exports.SQL_API_SQLPROCEDURES = idb.SQL_API_SQLPROCEDURES;
+exports.SQL_API_SQLPROCEDURESW = idb.SQL_API_SQLPROCEDURESW;
+exports.SQL_API_SQLPUTDATA = idb.SQL_API_SQLPUTDATA;
+exports.SQL_API_SQLRELEASEENV = idb.SQL_API_SQLRELEASEENV;
+exports.SQL_API_SQLROWCOUNT = idb.SQL_API_SQLROWCOUNT;
+exports.SQL_API_SQLSETCONNECTATTR = idb.SQL_API_SQLSETCONNECTATTR;
+exports.SQL_API_SQLSETCONNECTATTRW = idb.SQL_API_SQLSETCONNECTATTRW;
+exports.SQL_API_SQLSETCONNECTOPTION = idb.SQL_API_SQLSETCONNECTOPTION;
+exports.SQL_API_SQLSETCONNECTOPTIONW = idb.SQL_API_SQLSETCONNECTOPTIONW;
+exports.SQL_API_SQLSETCURSORNAME = idb.SQL_API_SQLSETCURSORNAME;
+exports.SQL_API_SQLSETCURSORNAMEW = idb.SQL_API_SQLSETCURSORNAMEW;
+exports.SQL_API_SQLSETDESCFIELD = idb.SQL_API_SQLSETDESCFIELD;
+exports.SQL_API_SQLSETDESCFIELDW = idb.SQL_API_SQLSETDESCFIELDW;
+exports.SQL_API_SQLSETDESCREC = idb.SQL_API_SQLSETDESCREC;
+exports.SQL_API_SQLSETENVATTR = idb.SQL_API_SQLSETENVATTR;
+exports.SQL_API_SQLSETPARAM = idb.SQL_API_SQLSETPARAM;
+exports.SQL_API_SQLSETSTMTATTR = idb.SQL_API_SQLSETSTMTATTR;
+exports.SQL_API_SQLSETSTMTATTRW = idb.SQL_API_SQLSETSTMTATTRW;
+exports.SQL_API_SQLSETSTMTOPTION = idb.SQL_API_SQLSETSTMTOPTION;
+exports.SQL_API_SQLSETSTMTOPTIONW = idb.SQL_API_SQLSETSTMTOPTIONW;
+exports.SQL_API_SQLSPECIALCOLUMNS = idb.SQL_API_SQLSPECIALCOLUMNS;
+exports.SQL_API_SQLSPECIALCOLUMNSW = idb.SQL_API_SQLSPECIALCOLUMNSW;
+exports.SQL_API_SQLSTARTTRAN = idb.SQL_API_SQLSTARTTRAN;
+exports.SQL_API_SQLSTATISTICS = idb.SQL_API_SQLSTATISTICS;
+exports.SQL_API_SQLSTATISTICSW = idb.SQL_API_SQLSTATISTICSW;
+exports.SQL_API_SQLTABLEPRIVILEGES = idb.SQL_API_SQLTABLEPRIVILEGES;
+exports.SQL_API_SQLTABLEPRIVILEGESW = idb.SQL_API_SQLTABLEPRIVILEGESW;
+exports.SQL_API_SQLTABLES = idb.SQL_API_SQLTABLES;
+exports.SQL_API_SQLTABLESW = idb.SQL_API_SQLTABLESW;
+exports.SQL_API_SQLTRANSACT = idb.SQL_API_SQLTRANSACT;
+exports.SQL_API_SQLSETPOS = idb.SQL_API_SQLSETPOS;

package.json

 {
   "name": "idb-pconnector",
-  "version": "0.1.1",
+  "version": "1.0.0",
   "description": "Promised-based Db2 Connector for IBM i (production-ready as a \"technology preview\")",
@@ -14,15 +14,25 @@ "main": "lib/idb-pconnector.js",
   "keywords": [
+    "IBM i",
+    "DB2",
     "IBMi",
-    "Db2"
+    "IBM"
   ],
   "author": "Jesse Gorzinski",
+  "contributors": [
+    {
+      "name": "Abdirahim Musse",
+      "name": "Brian Jerome",
+      "name": "Danny Roessner"
+    }
+  ],
   "license": "MIT",
   "homepage": "https://bitbucket.org/litmis/nodejs-idb-pconnector#readme",
   "dependencies": {
-    "idb-connector": "^1.1.0"
+    "idb-connector": "^1.1.2"
   },
   "devDependencies": {
     "chai": "^4.1.2",
-    "mocha": "^5.2.0"
+    "mocha": "^5.2.0",
+    "eslint": "^5.6.0"
   }
 }

README.md

@@ -1,41 +0,84 @@
-# idb-pconnector
+# **idb-pconnector - promised based DB2 Connector for IBM i**
+**Project Status**: (production-ready as a "technology preview")
 
-Promised-based Db2 Connector for IBM i (production-ready as a "technology preview")
-The objective of this project is to provide a database connector for Db2 on i that enables usage of the "await" keyword.
-As Well As Providing Connection Pooling Support. The `DBPool` has integrated aggregates that make it easier to Prepare & Execute, Prepare, Bind, & Execute, and Quickly Execute SQL. 
-## Examples
-Simple example of using a prepared statement to insert some values into a table, then querying all contents of that table:
+The objective of this project is to provide a promise based database connector API for DB2 on IBM i. 
+This project is a wrapper over the [`idb-connector`](https://bitbucket.org/litmis/nodejs-idb-connector) project but returning promises instead of using callbacks.
 
+Connection Pooling is supported giving you better control.
+The `DBPool` class includes integrated aggregates (prepareExecute, runSql), which make it easier to Prepare & Execute & directly Execute SQL. When using the aggregates opening and closing of statements will be handled by the pool.
+
+Using Node version ^8.X.X you can take advantage of async & await to simplifying your code.
+Remember to use the `await` keyword your code must be wrapped within an `async function`.
+
+Please refer to the documentation below for installation and usage of the `idb-pconnector`.
+
+[TOC]
+
+# **Install**
+This project is a Node.js module available through npm (node package manager).
+
+Once you have Node.js installed, you can run the following command: 
+
+`npm install idb-pconnector`
+
+# **Examples**
+
+### exec
+Using Async & Await, to run a select statement & displaying the result set:
+
+
 ```javascript
+const {Connection} = require('idb-pconnector');
+
+async function execExample() {
+  try {
+    let statement =  new Connection().connect().getStatement();
+
+    let result = await statement.exec('SELECT * FROM MYSCHEMA.TABLE');
+    
+    console.log(`Select results: \n${JSON.stringify(result)}`);
+
+  } catch(error) {
+       console.error(`Error was: \n${error.stack}`);
+    }
+}
+
+execExample();
+
+```
+### prepare bind execute
+Using Async & Await, to prepare, bind, and execute an insert statement:
+
+```javascript
 const idbp = require('idb-pconnector');
+const Connection = idbp.Connection;
 
-async function runInsertAndSelect() {
-   try {
-       let statement =  new idbp.Connection().connect().getStatement();
-       
-       await statement.prepare('INSERT INTO MYSCHEMA.TABLE VALUES (?,?)');
+async function pbeExample() {
+  try {
+    let statement =  new Connection().connect().getStatement();
 
-       await statement.bind([ [2018, idbp.SQL_PARAM_INPUT, idbp.SQL_BIND_NUMERIC],
-                              ['Dog', idbp.SQL_PARAM_INPUT, idbp.SQL_BIND_CHAR] 
-                            ]);
-       await statement.execute();
+    await statement.prepare('INSERT INTO MYSCHEMA.TABLE VALUES (?,?)');
 
-       let result = await statement.exec('SELECT * FROM MYSCHEMA.TABLE');
-       console.log(`Select results: \n${JSON.stringify(result)}`);
-   } catch(err) {
-       console.log(`Error was: \n${err.stack}`);
-   }
+    await statement.bind([
+      [2018, idbp.PARAM_INPUT, idbp.BIND_INT],
+      ['example', idbp.PARAM_INPUT, idbp.BIND_STRING]
+    ]);
+    await statement.execute();
+
+  } catch(error) {
+       console.error(`Error was: \n${error.stack}`);
+    }
 }
 
-runInsertAndSelect();
+pbeExample();
 
 ```
+### DBPool
 
-Example Using DBPool to attach a connection , execute a stored procedure , and executing a simple select statement. Finally detach the connection.
+Using DBPool to attach a connection , execute a stored procedure , and finally detach the connection.
 
 ```javascript
 const {DBPool} = require('idb-pconnector');
-//set the debug to true to view verbose output call
-const pool = new DBPool({}, {debug: true});
-//remember to use await you must wrap within async Function.
+const pool = new DBPool();
+
 async function poolExample(){
@@ -58,4 +101,4 @@ //attach() returns an available connection from the pool.
 
- } catch (err){
-   console.log(`Error was: \n\n${err.stack}`);
+ } catch (error){
+   console.log(`Error was: \n\n${error.stack}`);
    pool.retire(connection);
@@ -69,172 +112,207 @@ }
 ```
-Example Using DBPool aggregates to Prepare & Execute , Prepare Bind Execute , and Execute a statement.
+### prepareExecute
 
+Example Using DBPool prepareExecute(sql,params,options) method to Prepare and Execute a statement.
+If you want to bind variables pass an array of values as the second parameter.
+
 ```javascript
 const {DBPool} = require('idb-pconnector');
-//optional to set the debug to true to view verbose output call
-const pool = new DBPool({}, {debug: true});
-//remember to use await you must wrap within async Function.
-async function aggregatesRun(){
+const pool = new DBPool();
+
+async function prepareExecuteExample(){
  //Prepare and execute an SQL statement.
  try {
-   console.log('\Prepare and Execute\n');
-   let results = await pool.prepareExecute("CALL QIWS.GET_MEMBERS('QIWS','QCUSTCDT')");
-    if (results !== null) {
-     console.log(`\n\n${JSON.stringify(results)}\n\n`);
-   }
    /*
-   Params are passed as an array values.
-   The order of the params indexed in the array should map to the order of the parameter markers(i.e. '?').
- */
-   console.log('\nPrepare Bind & Execute\n');
+   * Params are passed as an array values.
+   * The order of the params indexed in the array should map to the order of the parameter markers(i.e. '?').
+   */
    let sql = 'INSERT INTO QIWS.QCUSTCDT VALUES (?,?,?,?,?,?,?,?,?,?,?) with NONE',
      params = [4949, 'Johnson', 'T J', '452 Broadway', 'MSP', 'MN', 9810, 2000, 1, 250, 0.00],
-     results2 = await pool.prepareExecute(sql, params);
+     data = await pool.prepareExecute(sql, params);
 
-   if (results2 !== null){
-     console.log(`\n\n${JSON.stringify(results2)}\n\n`);
+   if (data !== null){
+     let {resultSet} = data;
+     console.log(`\n\n${JSON.stringify(resultSet)}\n\n`);
    }
-   /*
-   Quickly execute a statement by providing the SQL to the runSql() function
-   NOTE: Stored Procedures should use the prepareExecute() method instead.
- */
-   console.log('\nRun a Query\n');
-   let results3 = await pool.runSql(`SELECT * FROM QIWS.QCUSTCDT WHERE CUSNUM = ${params[0]}`);
-    if (results3 !== null) {
-     console.log(`\n${JSON.stringify(results3)}`);
+
+ } catch (error){
+   console.log(`Error was: ${error.stack}`);
+ }
+}
+
+prepareExecuteExample();
+
+```
+### runSql
+
+Example Using DBPool runSql(sql) method to directly run an sql statement.
+NOTE: This method will not work with stored procedures use prepareExecute() instead.
+
+```javascript
+const {DBPool} = require('idb-pconnector');
+const pool = new DBPool();
+
+async function runSqlExample(){
+  /*
+  * Directly execute a statement by providing the SQL to the runSql() function.
+  * NOTE: Stored Procedures must use the prepareExecute() method instead.
+  */
+ try {
+
+   let result = await pool.runSql('SELECT * FROM QIWS.QCUSTCDT');
+
+    if (result !== null) {
+     console.log(`\n${JSON.stringify(result)}`);
    }
-   console.log('\nDone');
 
- } catch (err){
-   console.log(`Error was: ${err.stack}`);
+ } catch (error){
+   console.log(`Error was: ${error.stack}`);
  }
 }
-aggregatesRun();
 
+runSqlExample();
 
 ```
-# API
 
+# **API Documentation**
+
 # Class: Connection
 
+## Constructor: Connection()
+The Connection constructor accepts an optional `db` parameter which can be used to connect to the database. If `db` is not provided make sure to use the `connect()` before performing any other methods.
 
-## Connection.connect(dbname)
+**Parameters**:
+- **db**: `Object` includes the properties `url` location of the database, use '*LOCAL' for a local database, `username` for the database user, `password` for the databse user. If connecting using '*LOCAL' it is not required to pass the `username` & `password` but ensure that the the object contains `url: '*LOCAL'`.
 
+## Connection.connect(url, username, password)
+
 Establishes a Connection to the database.
 
-**Parameters**
+**Parameters**:
 
-**dbname**: `string`, the name of the database to connect to. If a name is not specified, the dbname is defaulted to "*LOCAL".
+- **url**: `String` the url of the database to connect to. If a url is not specified, it defaults to "*LOCAL".
 
-**Returns**: `object`, - the dbConn Object with an established connection.
+- **username**: `String` the username for the database user.
 
+- **password**: `String` the password for the database user.
+
+**Returns**: `Object` the Connection object with an established connection.
+
 ## Connection.getStatement()
 
-returns a Statement Object initialized to the current dbConn Connection.
+Returns a Statement Object initialized to the current Connection. Ensure that the Connection object is connected first before attempting to  get a Statement. The [isConnected](#markdown-header-connectionisconnected) method can be used to check if the Connection object is currently connected
 
-**Returns**: `object`, - a new Statement initialized with the current dbconn.
+**Returns**: `Object` a new Statement initialized with the current Connection.
 
 ## Connection.close()
 
-closes the Connection to the DB and frees the connection object.
+Closes the Connection to the DB and frees the connection object.
 
-**Returns**: `Promise`, - Promise object represents the closure of the Connection.
+**Returns**: `Promise` when resolved will return `true` indicating successful closure, or the promise will be rejected.
 
 ## Connection.disconn()
 
-disconnects an existing connection to the database.
+Disconnects an existing connection to the database.
 
-**Returns**: `Promise`, - Promise object represents the disconnect of the Connection.
+**Returns**: `Promise` when resolved will return `true` indicating successful disconnection, or the promise will be rejected.
 
 ## Connection.debug(choice)
 
-prints more detailed info if choice = true. Turned off by setting choice = false.
+Prints verbose detailed info to the console if choice is set `true`. Can be turned off by setting choice = false.
 
-**Parameters**
+**Parameters**:
 
-**choice**: `boolean`, the option either true or false to turn on debugging.
+- **choice**: `boolean` the option either true or false to turn debug on/off.
 
-**Returns**: `Promise`, - Promise object represents the debug method being set to the choice specified.
+**Returns**: `Promise` when resolved will return `true | false` indicating the current state of debug, or the promise will be rejected.
 
 ## Connection.getConnAttr(attribute)
 
-if connection attribute exists should return type String or Int depending on the attribute type
+If the `attribute` exists will return the current value of the attribute.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, if connection attribute exists should return type String or Int depending on the attribute type
+- **attribute**: `Number` the attribute to retrieve the current value from.
 
-**Returns**: `Promise`, - Promise object represents the the current settings for the specified connection attribute.
+**Returns**: `Promise` when resolved  will return the specified connection attribute settings either `Number | String`, or the promise will be rejected.
 
 **Link**:
-[Further Documentation ON Connection Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw\_ibm\_i_73/cli/rzadpfnsconx.htm)
+[Connection Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw\_ibm\_i_73/cli/rzadpfnsconx.htm)
+
+## Connection.isConnected()
+
+Checks if the Connection object is currentl connected to the database.
+
+**Returns**: `true` or `false` indicating if the Connection object is currently connected.
+
 ## Connection.setConnAttr(attribute, value)
 
-Sets the ConnAttr , Attribute should be INT.
+Sets the the value for a given `attribute`.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, the attribute to be set refer to the getConAttr example to view available attributes.
+- **attribute**: `Number` the attribute to be set.
 
-**value**: `string | number`, the value to set the attribute to. Can be String or Int depending the attribute.
+- **value**: `string | number` the value to set the attribute to.
 
-**Returns**: `Promise`, - Promise object represents the execution of the setConnAttr().
+**Returns**: `Promise` when resolved will return `true` indicating success or the promise will be rejected.
 
-### Connection.validStmt(sql)
+## Connection.validStmt(sql)
 
 Checks if the given SQL is valid and interprets vendor escape clauses.
 
-**Parameters**
+**Parameters**:
 
-**sql**: `string`, the sql string to be validated.
+- **sql**: `String`, the sql string to be validated.
 
-**Returns**: `Promise`, - Promise object represents the transformed SQL string that is seen by the data source.
+**Returns**: `Promise` when resolved will return the transformed sql string that is seen by the data source, or the promise will be rejected.
 
-- - -
+
 # Class: Statement
 
+## Constructor: Statement(connection)
 
+**Parameters**:
+
+- **connection**: optional `dbconn` Object for the connection to use. If you don't pass a `connection` one will be implicitly created and used for the statement.
+
 ## Statement.bindParam(params)
 
-associates parameter markers in an SQL statement to app variables.
+Associates parameter markers in an sql statement to application variables.
 
-**Parameters**
+**Parameters**:
 
-**params**: `Array`, this should be an Array of the parameter list. Each parameter element will also be an Array with 3 values ( Value, In/out Type ,Indicator ).
+- **params**: `Array` the parameter list in order corresponding to the parameter markers. Each parameter element will also be an Array with 3 values ( value, in/out type ,indicator ).
 
-**Returns**: `Promise`, - Promise object represents the execution of bindParam().
 
-**Example**:
-```js
-statement.bindParam([
-       [2099, dba.SQL_PARAM_INPUT, dba.SQL_BIND_NUMERIC],
-       ['Node.Js', dba.SQL_PARAM_INPUT,dba.SQL_BIND_CHAR]
-        ]);
-        
+```
        IN/OUT TYPE CAN BE:
-          - SQL_PARAM_INPUT
-          - SQL_PARAM_OUTPUT
-          - SQL_PARAM_INPUT_OUTPUT
+          - SQL_PARAM_INPUT or PARAM_INPUT
+          - SQL_PARAM_OUTPUT or PARAM_OUTOUT
+          - SQL_PARAM_INPUT_OUTPUT or INPUT_OUTPUT
           
        INDICATORS CAN BE:
-           - SQL_BIND_CHAR
-           - SQL_BIND_INT
-           - SQL_BIND_NUMERIC
-           - SQL_BIND_BINARY
-           - SQL_BIND_BLOB
-           - SQL_BIND_CLOB
-           - SQL_BIND_BOOLEAN
-           - SQL_BIND_NULL_DATA
+           - SQL_BIND_CHAR or BIND_STRING
+           - SQL_BIND_INT or BIND_INT
+           - SQL_BIND_NUMERIC or BIND_NUMERIC
+           - SQL_BIND_BINARY or BIND_BINARY
+           - SQL_BIND_BLOB or BIND_BINARY
+           - SQL_BIND_CLOB or BIND_CLOB
+           - SQL_BIND_BOOLEAN or BIND_BOOLEAN
+           - SQL_BIND_NULL_DATA or BIND_NULL
       
 ```
+These values are constants which are attached to object returned when you `const idbp = require('idb-pconnector')`.
 
-## Statement.bind(params)
+You can access said values like so : `idbp.PARAM_INPUT`
 
-Shorthand for bindParam
+**Returns**: `Promise` when resolved there is no return value but if an error occurred the promise will be rejected.
 
-**Parameters**
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
-**params**: `Array`, this should be an Array of the parameter list. Each parameter element will also be an Array with 3 values ( Value, In/Out Type ,Indicator ).
+## Statement.bind(params)
 
+Shorthand equivalent of bindParam(params) above.
 
+
 ## Statement.close()
@@ -244,100 +322,51 @@
 
-**Returns**: `Promise`, - Promise object represents the execution of close().
+**Returns**: `Promise` when resolved will return true indicating successful closure, or the promise will be rejected.
 
 ## Statement.closeCursor()
 
-closes the cursor associated with the dbstmt object and discards any pending results.
+Closes the cursor associated with the Statement object and discards any pending results.
 
-**Returns**: `Promise`, - Promise object represents the execution of closeCursor().
+**Returns**: `Promise` when resolved will return true indicating successful closure, or the promise will be rejected.
 
 ## Statement.commit()
 
-adds all changes to the database that have been made on the connection since connect time.
+Adds all changes to the database that have been made on the connection since connect time.
 
-**Returns**: `Promise`, - Promise object represents the execution of Commit().
+**Returns**: `Promise` when resolved will return true indicating successful commit, or the promise will be rejected.
 
-## Statement.exec(sqlString)
+## Statement.exec(sql)
 
-performs action of given SQL String. The exec() method does not work with stored procedure calls use execute() instead.
+Directly executes a given sql String. The exec() method does not work with stored procedure use execute() method instead.
 
-**Parameters**
+**Parameters**:
 
-**sqlString**: `string`, performs action of given SQL String. The exec() method does not work with stored procedure calls use execute() instead.
+- **sql**: `String` the sql command to execute.
 
-**Returns**: , the result set as an array.
-**Returns**: `Promise`, - Promise object represents the result set from the execution of exec().
+**Returns**: `Promise` when resolved if available will return the result set as an `Array` , or the promise will be rejected.
 
+**Example**: [Here](#markdown-header-exec)
+
 ## Statement.execute()
 
-Runs a statement that was successfully prepared using prepare().
-Use execute() for stored procedure calls.
+Runs a statement that was successfully prepared using prepare(). Used to call stored procedure calls. Important to note that execute() will return output parameters and not a result set. If available you can retrieve the result set by either running fetch() or fetchAll().
 
-**Returns**: `Promise`, - Promise object represents the execution of execute().
+**Returns**: `Promise` when resolved if available will return output parameters as an `Array`, or the promise will be rejected.
 
-**Example**:
-```js
-- Calling a stored Procedure that returns a result set with execute() & displaying the result set.
-       
-  const idbp = require('idb-pconnector');
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
-  async function storedProcedure(){
+## Statement.fetch()
 
-    try {
-      // note that that calling the new Statement() without the DbConn as a parameter
-      // creates a new connection implicitly and uses that for the Statement.
-      let statement = new idbp.Statement(),
-        sql = 'CALL MYSCHEMA.SAMPLEPROC';
-      
-    	await statement.prepare(sql);
-      await statement.execute();
-      
-      //if a result set exists you can fetch it
-    	let result = await statement.fetchAll();
-    	console.log(`Result is\n: ${JSON.stringify(result)}`);
-    } catch(error){
-    	console.log(error.stack);
-      }
-  }
+If a result set exists, fetch() will retrieve a row from the result set. The row is an `Object`. Fetch can be continuously run until there is no data. If there is no data to be fetched null will be returned indicating the end of the result set.
 
-  storedProcedure();
-    
-- Insert Example With Prepare , Binding Parameter , and Execution
-	
-  const idbp = require('idb-pconnector');
-  
-  async function prepareBindExecute(){
-    try {
-      let statement = new idbp.Statement(),
-        sql = 'INSERT INTO MYSCHEMA.MYTABLE VALUES (?,?)';
+**Returns**: `Promise` when resolved will return an `Object` representing the row that was retrieved. If there is no data remaining to be fetched in the result set `null` will be returned indicating the end of the result set. Or if there was never a result set to be fetched the promise will be rejected.
 
-      await statement.prepare(sql);
-      //binding a number and null data types
-      await statement.bind([ [2018,idbp.SQL_PARAM_INPUT,idbp.SQL_BIND_NUMERIC], [null ,idbp.PARM_TYPE_INPUT, idbp.SQL_BIND_NULL_DATA ] ]);
-      await statement.execute();
+**Example Fetching a result set until there is no more data to fetch**:
 
-      let result = await statement.exec('SELECT * FROM MYSCHEMA.MYTABLE');
-      console.log(`Select results: \nJSON.stringify(result)`);
-    } catch(error){
-    	console.log(error.stack);
-      }
-  }
-
-  prepareBindExecute();
-```
-
-## Statement.fetch()
-
-if a result exists , retrieves a row from the result set
-
-**Returns**: `Promise`, - Promise object represents the row that was retrieved from the execution of fetch(). If there is no data to be fetched null will be returned indicating the end of the result set.
-
 ```javascript
+const {Connection} = require('idb-pconnector');
 
-- Example Fetching a result set until there is no more data to fetch.
-const idbp = require('idb-pconnector');
-
 async function fetch(){
   try {
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-    connection = new idbp.Connection();
+    connection = new Connection();
 
@@ -366,65 +395,65 @@ connection.debug(true);
 
-if a result set exists , retrieves all the rows of data from the result set.
+If a result set exists , fetchAll() retrieves all the rows from the result set.
 
-**Returns**: `Promise`, - Promise object represents the the an array containing the result that was retrieved from the execution of fetchAll().
+**Returns**: `Promise` when resolved will return an `Array` of `Objects` representing the result set if its available, or the promise will be rejected.
 
 ## Statement.fieldName(index)
 
-requires an int index parameter. If a valid index is provided, returns the name of the indicated field.
+If a valid index is provided, returns the name of the indicated field.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the String that was retrieved from the execution of fieldName().
+**Returns**: `Promise` when resolved will return `String` name of the field or the promise will be rejected.
 
 ## Statement.fieldNullable(index)
 
-requires an int index parameter. If a valid index is provided, returns t/f if the indicated field can be Null
+If a valid index is provided, returns `true | false` if the indicated field can be set to `null`.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the boolean that was retrieved from the execution of fieldNullable().
+**Returns**: `Promise` when resolved will return `true | false` or the promise will be rejected.
 
 ## Statement.fieldPrecise(index)
 
-requires an int index parameter. If a valid index is provided, returns the precision of the indicated field
+If a valid index is provided, returns the precision of the indicated field
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldPrecisie().
+**Returns**: `Promise` when resolved will return `Number` or the promise will be rejected.
 
 ## Statement.fieldScale(index)
 
-requires an int index parameter. If a valid index is provided, returns the scale of the indicated column
+If a valid index is provided, returns the scale of the indicated column.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldScale().
+**Returns**: `Promise` when resolved will return a `Number` or the promise will be rejected.
 
 ## Statement.fieldType(index)
 
-requires an int index parameter. If a valid index is provided, returns the data type of the indicated field
+If a valid index is provided, returns the data type of the indicated field.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldType().
+**Returns**: `Promise` when resolved will return a `Number` or the promise will be rejected.
 
 ## Statement.fieldWidth(index)
 
-requires an int index parameter. If a valid index is provided, returns the field width of the indicated field
+If a valid index is provided, returns the field width of the indicated field
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, the position of the field within the table. It is 0 based.
+- **index**: `Number` the position of the field within the table. It is 0 based.
 
-**Returns**: `Promise`, - Promise object represents the the Number that was retrieved from the execution of fieldWidth().
+**Returns**: `Promise`, when resolved will return a `Number` or the promise will be rejected.
 
@@ -436,42 +465,41 @@ ## Statement.getStmtAttr(attribute)
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, the statement attribute to get
+- **attribute**: `Number`the attribute to retrieve the current value from.
 
-**Returns**: `Promise`, Promise object represents the the String | Number that was retrieved from the execution of getStmtAttr().
+**Returns**: `Promise`, when resolved will return the specified connection attribute settings as a `Number | String`, or the promise will be rejected.
 
-**Link**:
-[Further Documentaion On Statement Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/cli/rzadpfnsstma.htm)
+**Link**: [Statement Attributes](https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/cli/rzadpfnsstma.htm)
+
 ## Statement.nextResult()
 
-Determines whether there is more information available on the statement
+Determines whether there is more information available on the statement handle that has been associated with a stored procedure that is returning result sets.
 
-**Returns**: `Promise`, - Promise object represents the execution of nextResult().
+After completely processing the first result set, the application can call nextResult() to determine if another result set is available. If the current result set has unfetched rows, nextResult() discards them by closing the cursor.
 
+**Returns**: `Promise` when resolve `true` will be returned indicating there is another result set or `null` is returned indicating there was not another result set. If an error occurred while processing the promise is rejected.
+
 ## Statement.numFields()
 
-if a result is available , retrieves number of fields contained in result.
+If a result set is available , numFields() retrieves number of fields contained in the result set.
 
-**Returns**: `Promise`, - Promise object represents the Number returned from the execution of numFields().
+**Returns**: `Promise` when resolved `Number` is returned or the promise is rejected.
 
 ## Statement.numRows()
 
-if a query was performed ,retrieves number of rows that were affected by a query
+If a query was performed, retrieves the number of rows that were affected by a query.
 
-**Returns**: `Promise`, - Promise object represents the Number returned from the execution of numRows().
+**Returns**: `Promise` when resolved will return a `Number` or the promise is rejected.
 
-## Statement.prepare(sqlString)
+## Statement.prepare(sql)
 
-If valid SQL is provided . prepares SQL and sends it to the DBMS, if the input SQL Statement cannot be prepared error is thrown.
+If valid sql is provided . prepares the sql and sends it to the DBMS, if the input sql Statement cannot be prepared error is thrown.
 
-**Parameters**
+**Parameters**:
 
-**sqlString**: `string`, the SQL string to be prepared.
+- **sql**: `String`, the SQL string to be prepared.
 
-**Returns**: `Promise`, - Promise object represents the the execution of prepare().
+**Returns**: `Promise` when resolved no value is returned but if an error occurred the promise is rejected.
 
-**Example**:
-```js
-- view the examples located at the execute() method.
-```
+**Example**: [Here](#markdown-header-prepare-bind-execute)
 
@@ -482,14 +510,16 @@ ## Statement.rollback()
 
+**Returns**: `Promise` when resolved  `true` is returned or promise is rejected.
 
+
 ## Statement.setStmtAttr(attribute, value)
 
-if a valid attribute and value is provided , sets StmtAttr indicate Attribute. Refer to the example @getStmtAttr for a list of valid Statement Attributes.
+Sets the the value for a given attribute.
 
-**Parameters**
+**Parameters**:
 
-**attribute**: `number`, must be an int INT.
+- **attribute**: `Number` the attribute to be set.
 
-**value**: `string | number`, can String or Int depending on the attribute
+- **value**: `string | number` the value to set the attribute to.
 
-**Returns**: `Promise`, - Promise object represents the execution of setStmtAttr().
+- **Returns**: `Promise` when resolved will return `true` indicating success or the promise will be rejected..
 
@@ -500,12 +530,9 @@ ## Statement.stmtError(hType, recno)
 
-**Parameters**
+**Parameters**:
 
-**hType**: `number`, indicates the handler type of diagnostic information.
+- **hType**: `Number`, indicates the handler type of diagnostic information.
 
-**recno**: `number`, indicates which error should be retrieved. The first error record is number 1.
+- **recno**: `Number`, indicates which error should be retrieved. The first error record is number 1.
 
-**Returns**: `Promise`, - Promise object represents Number retrieved from the execution of stmtError().
-
-**Example**:
-```js
+```
 hType can be following values:
@@ -517,3 +544,3 @@ SQL_HANDLE_ENV:  Retrieve the environment diagnostic information
 
-# DBPool API
+**Returns**: `Promise` when resolved returns `String` or the promise is rejected.
 
@@ -523,4 +550,5 @@
 # Class: DBPool
+
 Manages a list of DBPoolConnection instances.
-Constructor to instantiate a new instance of a DBPool class given the `database` and `config`
+Constructor to instantiate a new instance of a DBPool class given the `database` and `config`.
 
@@ -530,20 +558,22 @@
 
-**Parameters**
+**Parameters**:
 
-**database**: `object`, Object includes the `url`(database name) defaults to *LOCAL, `username`, and `password`. `username` and `password` assumed blank if not specified with non-local URL.
+- **database**: `object` includes the `url` defaults to "*LOCAL", `username`, and `password`. Username & password is optional when connecting to "*LOCAL".
 
-**config**: `object` , Object includes the `incrementSize` and `debug`. IncrementSize sets the desired size of the DBPool. If none specified, defaults to 8 connections. Setting debug = true will display message logs.
+- **config**: `object` with the properties: `incrementSize` and `debug`. IncrementSize is a integer `Number` that sets the desired size of the DBPool defaults to 8 connections. Debug is a `boolean` setting it to true will display verbose output to the console, defaults to false.
 
+**Example**: [Here](#markdown-header-dbpool)
 
-### DBPool.createConnection(index)
 
+## DBPool.createConnection(index)
+
 Instantiates a new instance of DBPoolConnection with an `index` and appends it to the pool.
 Assumes the database of the pool when establishing the connection.
 
-**Parameters**
+**Parameters**:
 
-**index**: `number`, An identifier to id the connection for debug purposes.
+**index**: `Number` an optional identifier to id the connection for debug purposes.
 
 
-### DBPool.detachAll()
+## DBPool.detachAll()
 
@@ -553,64 +583,101 @@ Frees all connections in the pool (Sets "Available" back to true for all)
 
-**Returns**: `boolean`, - true if all were detached successfully
+**Returns**: `true` if all were detached successfully or will return `String` error message if an error occurred.
 
-### DBPool.retireAll()
+## DBPool.retireAll()
 
 Retires (Removes) all connections from being used again
 
-**Returns**: `boolean`, - true if all were retired successfully
+**Returns**: `true` if all were retired successfully, or will return `String` error message if an error occurred.
 
-### DBPool.detach(connection)
+## DBPool.detach(connection)
 
-Frees a connection (Returns the connection "Available" back to true)
-closes any statements and gets a new statement.
+Frees a connection (Returns the connection "Available" back to true) closes any statements and gets a new statement.
 
-**Parameters**
+**Parameters**:
 
-**connection**: `DBPoolConnection`, Frees a connection (Returns the connection "Available" back to true)
+- **connection**: `DBPoolConnection`, Frees a connection (Returns the connection "Available" back to true)
 closes any statements and gets a new statement.
 
 
-### DBPool.retire(connection)
+**Returns**: `String` error message if an error occurred.
 
-Retires a connection from being used and removes it from the pool
+## DBPool.retire(connection)
 
-**Parameters**
+Retires a connection from being used and removes it from the pool.
 
-**connection**: `DBPoolConnection`, Retires a connection from being used and removes it from the pool
+**Parameters**:
 
+- **connection**: `DBPoolConnection`, Retires a connection from being used and removes it from the pool
 
-### DBPool.attach()
+**Returns**: `String` error message if an error occurred.
 
+## DBPool.attach()
+
 Finds and returns the first available Connection.
 
-**Returns**: `DBPoolConnection`, - one connection from the DBPool.
+**Returns**: `DBPoolConnection` connection from the `DBPool`.
 
 
 
-### DBPool.runSql(sql)
+## DBPool.runSql(sql)
 
-Shorthand to exec a statement , just provide the sql to run.
+An aggregate to run an sql statement, just provide the sql to run. Note that Stored Procedures should use the prepareExecute() aggregate instead.
 
-**Parameters**
+**Parameters**:
 
-**sql**: `string`, the sql statement to execute.
+- **sql**: `String`, the sql statement to execute.
 
-**Returns**: `array`, - if the SQL returns a result set it is returned as an array of objects.
-else if no result set is available null is returned. caller should check if null is returned.
+**Returns**: 
+- `Array` if the sql returns a result set it is returned as an `Array` of `Objects`.
 
-### DBPool.prepareExecute(sql, params)
+- If no result set is available `null` is returned. Caller should check if `null` is returned.
 
-Shortcut to prepare ,bind, and execute. Just provide the sql and the params as an array.
+**Example**: [Here](#markdown-header-runsql)
 
-**Parameters**
 
-**sql**: `string`, the sql to prepare , include parameter markers (?, ?, ...)
+## DBPool.prepareExecute(sql, params, options)
 
-**params**: `array`, an optional array of values to bind. order of the values in the array must match the
-order of the desired parameter marker in the sql string.
+Aggregate to prepare, bind, and execute. Just provide the sql and the optional params as an array.
 
-**Returns**: `array`, - if the Prepared SQL returns result set it is returned as an array of objects.
-else null will be returned indicating that there is no result set.
+An `options` object can now be used for global configuration. This is used to set options on all the parameters within the `params` Array. Currently, the input output indicator `io` is the only available option to set. This will override the default which is `'both'`.
 
+**Example**: `prepareExecute(sql, parrams, {io: 'in'})`
 
-* * *
+Also parameters can be customized at an individual level by passing an object within the parameter list.
+
+The object format: `{value: "string | Number | boolean | null" , io: "in | out | both" , asClob: "true | false"}`
+
+`value` is the only required property others will fallback to defaults.
+
+If you want to bind a string as a clob you can add `asClob: true` property to the object.
+
+**Example**: `{value: 'your string', asClob: true, io: 'in'}`
+
+**Parameters**::
+
+- **sql**: `string`, the sql to prepare , include parameter markers (?, ?, ...)
+
+- **params**: `array`, an optional array of values to bind. order of the values in the array must match the order of the desired parameter marker in the sql string.
+- **options**: `Object` with config options to set for all parameters. The format can be: `{io: 'in' | 'out' | 'both'}` where `io` can be set to either the `String` `'in'`, `'out'`, or `'both'`. Indicating that the parameter is an input, output, or inout parameter.
+
+**Returns**: `Object` in the format: `{resultSet: [], outputParams: []}` if the Prepared SQL returns result set it is returned as an array of objects or if the Prepared SQL returns output parameters it is returned as an array of objects. 
+
+- If neither were available `null` will be returned indicating that there is no result set or output parameters. Caller should check if `null` is returned.
+
+**Example**: [Here](#markdown-header-prepareexecute)
+
+## DBPool.setConnectionAttribute(attribute)
+
+Sets the connection attribute for each a Connection in the pool.
+
+**Parameters**:
+
+- **attribute**: `Object` in the format {attribute: Number (integer), value: Number (integer) | String}
+
+# **License**
+MIT. View [LICENSE](LICENSE)
+
+# **Contributing**
+If you would like to contribute please issue a pull request. No document signing is necessary for this project.
+
+

test/connectionTest.js

@@ -10,3 +10,3 @@ /*
 const expect = require('chai').expect;
-const dba = require('../lib/idb-pconnector');
+const {Connection} = require('../lib/idb-pconnector');
 
@@ -16,8 +16,24 @@
 
+describe('Connection constructor connect', () => {
+  it('should attempt to connect if the db object parameter is provided', async () => {
+    let dbConn = new Connection({url: '*LOCAL'});
+
+    expect(dbConn.isConnected()).to.be.true;
+  });
+});
+
+describe('Connection constructor connect', () => {
+  it('should attempt to connect if the db object parameter is provided', async () => {
+    let dbConn = new Connection({url: '*LOCAL', username: process.env.USERID, password: process.env.PASSWD});
+
+    expect(dbConn.isConnected()).to.be.true;
+  });
+});
+
 describe('connect', () => {
   it('should return a newly connected dbconn object', async () => {
-    let dbConn = new dba.Connection();
-    console.log(dbConn);
-    let connReturned = dbConn.connect();
-    console.log(connReturned);
+    let dbConn = new Connection(),
+      connReturned = dbConn.connect();
+
+    expect(connReturned.isConnected()).to.be.true;
     expect(connReturned.dbconn).to.be.a('dbconn');
@@ -27,8 +43,17 @@ });
 
+describe('connect with user & password', () => {
+  it('should return a newly connected dbconn object', async () => {
+    let dbConn = new Connection(),
+      connReturned = dbConn.connect('*LOCAL', process.env.USERID, process.env.PASSWD);
+
+    expect(connReturned.isConnected()).to.be.true;
+    expect(connReturned.dbconn).to.be.a('dbconn');
+  });
+});
+
 describe('getStatement', () => {
   it('should return a new statemetnt intiialized with the the dbconn', async () => {
-    let dbConn = new dba.Connection().connect();
-    console.log(dbConn);
-    let stmtReturned = dbConn.getStatement();
-    console.log(stmtReturned);
+    let dbConn = new Connection().connect(),
+      stmtReturned = dbConn.getStatement();
+
     expect(stmtReturned.stmt).to.be.a('dbstmt');
@@ -41,8 +66,7 @@ });
   it('if the SQL is valid, validStmt , should return type String', async () => {
-    let sql = 'SELECT * FROM QIWS.QCUSTCDT';
-    let dbConn = new dba.Connection().connect();
-    let res = await dbConn.validStmt(sql);
-    console.log('Valid Stmt output: ' + res);
+    let sql = 'SELECT * FROM QIWS.QCUSTCDT',
+      dbConn = new Connection().connect(),
+      res = await dbConn.validStmt(sql);
+
     expect(res).to.be.a('string');
-
   });
@@ -54,6 +78,6 @@ });
   it('if connection attribute exsits should return type String or Int depending on the attribute type', async () => {
-    let attr = 0;
-    let dbConn = new dba.Connection().connect();
-    let res = await dbConn.getConnAttr(attr);
-    console.log('Attrubte: ' + res);
+    let attr = 0,
+      dbConn = new Connection().connect(),
+      res = await dbConn.getConnAttr(attr);
+
     expect(res).to.satisfy(function(res){
@@ -69,6 +93,7 @@ return res === 'string' || typeof res === 'number';
   it('sets the ConnAttr. Attrubte should be INT. Value can String or Int depending on the attribute', async () => {
-    let attr = 0;
-    let value = 2;
-    let dbConn = new dba.Connection().connect();
-    let res = await dbConn.setConnAttr(attr, value);
+    let attr = 0,
+      value = 2,
+      dbConn = new Connection().connect(),
+      res = await dbConn.setConnAttr(attr, value);
+
     expect(res).to.be.true;
@@ -81,5 +106,6 @@ });
   it('prints more detailed info if choice = true. Turned off by setting choice = false.', async () => {
-    let choice = true;
-    let dbConn = new dba.Connection().connect();
-    let res = await dbConn.debug(choice);
+    let choice = true,
+      dbConn = new Connection().connect(),
+      res = await dbConn.debug(choice);
+
     expect(res).to.be.true;
@@ -92,4 +118,5 @@ });
   it('disconnects an exsisting connection to the datbase. ', async () => {
-    let dbConn = new dba.Connection().connect();
-    let res = await dbConn.disconn();
+    let dbConn = new Connection().connect(),
+      res = await dbConn.disconn();
+
     expect(res).to.be.true;
@@ -102,7 +129,29 @@ });
   it('frees the connection object. ', async () => {
-    let dbConn = new dba.Connection().connect();
+    let dbConn = new Connection().connect();
+
     await dbConn.disconn();
+
     let res = await dbConn.close();
+
     expect(res).to.be.true;
   });
+});
+
+describe('isConnected', () => {
+  it('returns true/false if Connection object is connected ', async () => {
+    let dbConn = new Connection(),
+      before = dbConn.isConnected();
+    expect(before).to.be.false;
+
+    dbConn.connect();
+
+    let after = dbConn.isConnected();
+
+    expect(after).to.be.true;
+
+    await dbConn.disconn();
+
+    let last = dbConn.isConnected();
+    expect(last).to.be.false;
+  });
 });

test/dbpoolTest.js

@@ -10,4 +10,5 @@ /*
 const idbp = require('../lib/idb-pconnector');
-const connPool = new idbp.DBPool({}, {debug: true});
-const DBPoolConnection = require('../lib/dbPool.js').DBPoolConnection;
+const {DBPool} = idbp;
+const connPool = new DBPool({url: '*LOCAL'}, {debug: true});
+const {DBPoolConnection} = require('../lib/dbPool.js');
 const log = console.log;
@@ -55,3 +56,3 @@
 
-      //after being detached available should be true again
+    //after being detached available should be true again
     expect(detached.available).to.be.true;
@@ -127,6 +128,21 @@ //make sure the statement was cleared
       console.log(results);
-      expect(results).to.be.an('array');
-      expect(results.length).to.be.gt(0);
+      expect(results).to.be.an('object');
+      expect(results.resultSet).to.be.an('array');
+      expect(results.resultSet.length).to.be.gt(0);
     });
 });
 
+describe('Set Connection Attribute for Pool', async () => {
+  it('should set a valid connection attribute for the pool.',
+    async () => {
+      let db = {url: '*LOCAL'},
+        attribute = {attribute: idbp.SQL_ATTR_DBC_SYS_NAMING, value: idbp.SQL_FALSE},
+        config = {incrementSize: 3, debug: true};
+
+      const testPool = new DBPool(db, config);
+
+      await testPool.setConnectionAttribute(attribute).catch(error =>{throw error;});
+
+    });
+});
+

test/statementTest.js

@@ -10,2 +10,3 @@ /*
 const idbp = require('../lib/idb-pconnector');
+const {Connection} = idbp;
 const util = require('util');
@@ -17,3 +18,3 @@
   it('Prepares valid SQL and sends it to the DBMS, if the input SQL Statement cannot be prepared error is returned. ', async () =>{
-    dbConn = new idbp.Connection();
+    dbConn = new Connection();
     dbConn.debug(true);
@@ -33,4 +34,4 @@ let dbStmt = dbConn.connect().getStatement(),
     let sql = 'INSERT INTO QIWS.QCUSTCDT(CUSNUM,LSTNAM,INIT,STREET,CITY,STATE,ZIPCOD,CDTLMT,CHGCOD,BALDUE,CDTDUE) VALUES (?,?,?,?,?,?,?,?,?,?,?) with NONE',
-      dbStmt = new idbp.Connection().connect().getStatement(),
-      dbStmt2 = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement(),
+      dbStmt2 = new Connection().connect().getStatement();
 
@@ -77,3 +78,3 @@ let params = [
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -91,3 +92,3 @@ await dbStmt.exec(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -105,3 +106,3 @@ await dbStmt.exec(sql);
     let sql = 'INSERT INTO QIWS.QCUSTCDT(CUSNUM,LSTNAM,INIT,STREET,CITY,STATE,ZIPCOD,CDTLMT,CHGCOD,BALDUE,CDTDUE) VALUES (?,?,?,?,?,?,?,?,?,?,?) with NONE ',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -132,3 +133,3 @@ let params = [
   it('performs action of given SQL String', async () => {
-    let dbConn = new idbp.Connection();
+    let dbConn = new Connection();
     dbConn.debug(true);
@@ -151,3 +152,3 @@ let dbStmt = dbConn.connect().getStatement(),
       sql = `CALL ${user}.MAXBAL(?)`,
-      dbConn = new idbp.Connection();
+      dbConn = new Connection();
 
@@ -172,3 +173,3 @@ dbConn.debug(true);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbConn = new idbp.Connection();
+      dbConn = new Connection();
 
@@ -194,3 +195,3 @@ dbConn.debug(true);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbConn = new idbp.Connection();
+      dbConn = new Connection();
     dbConn.debug(true);
@@ -212,3 +213,3 @@ let dbStmt = dbConn.connect().getStatement();
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -228,3 +229,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -244,3 +245,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -264,3 +265,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -284,3 +285,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -304,3 +305,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -324,3 +325,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -345,3 +346,3 @@ await dbStmt.prepare(sql);
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -366,3 +367,3 @@ await dbStmt.prepare(sql);
       value = 1,
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -378,3 +379,3 @@ let result = await dbStmt.setStmtAttr(attr, value);
     let attr = idbp.SQL_ATTR_FOR_FETCH_ONLY,
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -393,3 +394,3 @@ let result = await dbStmt.getStmtAttr(attr);
 // 		let sql = "SELECT * FROM QIWS.QCUSTCDT";
-// 		let dbStmt = new idbp.Connection().connect().getStatement();
+// 		let dbStmt = new Connection().connect().getStatement();
 // 		await dbStmt.prepare(sql);
@@ -406,3 +407,3 @@ // 		await dbStmt.execute();
     let sql = 'SELECT * FROM QIWS.QCUSTCDT',
-      dbStmt = new idbp.Connection().connect().getStatement();
+      dbStmt = new Connection().connect().getStatement();
 
@@ -421,3 +422,3 @@ await dbStmt.prepare(sql);
 // 	it('Returns the diagnostic information ', async () =>{
-// 			let dbStmt =  new idbp.Connection().connect().getStatement();
+// 			let dbStmt =  new Connection().connect().getStatement();
 // 			await dbStmt.stmtError(hType, recno);
@@ -424,0 +425,0 @@

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Environment variable access

Supply chain risk

Package accesses environment variables, which may be a sign of credential stuffing or data theft.

Found 2 instances in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

No v1

Quality

Package is not semver >=1. This means it is not stable and does not support ^ ranges.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

157474

increased by7.56%

Lines of code

2754

increased by5.56%

Number of low quality alerts

0

decreased by-100%

Number of lines in readme file

673

increased by11.24%

Worsened metrics

Dev dependency count

3

increased by50%

Number of low supply chain risk alerts

5

increased by400%

Dependency changes

• Updatedidb-connector@^1.1.2