SQL API

Data API
- pjs.data.delete()
- pjs.data.getCount()
- pjs.data.get()
- pjs.data.update()
- pjs.data.add()
- pjs.data.createCondition()
pjs.allocStmt()
pjs.bindParameters()
pjs.close()
pjs.getConnection()
pjs.getDB()
pjs.getRemoteDB()
pjs.escapeString()
pjs.execute()
pjs.executeDirect()
pjs.getSQLOption()
pjs.setConnectAttr()
pjs.query()
pjs.parallelQueries()
pjs.setSQLOption()
pjs.setStmtAttr()
pjs.prepare()
pjs.connect()
pjs.disconnect()
pjs.sqlHelper
SQL Diagnostics
SQL Examples
- Fetch into fields
- Fetch into primitive object
- Multi-row fetch into data-structure array
- Multi-row fetch into data-structure array with parameters
- Multi-row fetch into primitive object
- Load Rich Display Grid using SQL
- Retrieve Auto-Generated Row Id after Insert into DB2 Table
SQL Fetch API
- pjs.fetch()
- pjs.fetchFirst()
- pjs.fetchLast()
- pjs.fetchNext()
- pjs.fetchPrior()
- pjs.fetchAbsolute()
- pjs.fetchRelative()
- pjs.rowCount()
- pjs.hasMoreRows()
- statement.endOfData()