Database Functions(3.1)

Owned by Jenni Wallin
May 10, 2023
1 min read

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 failovers
  • 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. 


This chapter includes the following sections: