IBM i DB2 Record Level Access

Owned by Alex Roytman
Last updated: Aug 16, 2023 by Jessica Tomkins
1 min read



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/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.