IBM i DB2 Access

Profound.js Connector provides two ways to work with IBM i Db2 database tables: Record Level Access (RLA) and embedded SQL. Both run top-down without requiring callbacks, and both support QTEMP in batch and interactive jobs. This page lists the capabilities of each.

• Record Level Access - Read, write, update, and delete records one at a time, by key or sequentially, the way an RPG program does.

• SQL access - Run full embedded SQL, including prepared statements, cursors, and parameter binding.

Profound.js Connector provides full Record Level Access support for working with IBM i database tables. Some of the capabilities include:

• Override database file support.

• Using files with or without level checking.

• QTEMP support for both batch and interactive jobs.

• Read, write, update, and delete capabilities.

• Record locking.

• Fetching records sequentially in either direction.

• Fetching records by key.

• Multi-part keys.

• Use of data structures to fetch and update data.

• Use of global record format fields to fetch and update data.

• Options for qualified and non-qualified access.

• Key data structures.

• Updating fields selectively.

• Top-down transactional I/O without requiring callbacks.

• Access to INFDS (Information Data Structure) values.

For more information about RLA capabilities, see Record Level Access API.

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.