The following sets of functions are used for managing data in databases accessed via Database profiles:
- Database Table functions - Looks up and insert data into tables
- Callable Statement functions - Executes stored procedures
- Prepared Statement functions - Efficiently executes statements multiple times and has support for failover
- Database Bulk functions - Bundles multiple queries into one SQL statement
Note!
All database related APL functions utilize a db connection pool, and they pick a connection from the pool for each invocation. Connection properties, such as the transaction state, are handled internally by each function and are never visible in APL.