IBM i DB2 SQL Access

Profound.js Connector provides full embedded SQL capabilities including the following:

  • Reading, updating, deleting, and inserting data
  • QTEMP support in both interactive and batch jobs
  • File overrides
  • Data structures
  • Prepared statements
  • Immediately executed statements
  • Parameter binding
  • Fetching and processing records one at a time in either direction
  • Cursors
  • Custom connection attributes
  • Remote connections
  • Top-down transactional I/O without requiring callbacks

For more information about SQL capabilities within Profound.js, see SQL API.