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.