/
Database Functions(5.0)

Database Functions(5.0)

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 use a database connection pool, and they pick a connection from the pool for each invocation. Each function handles connection properties, such as the transaction state, internally, and these properties are never visible in APL.

These database functions work with the following database types: character, string, integer, and date types such as VARCHAR, INTEGER, NUMBER, DATE, TIMESTAMP, and BOOLEAN.

APL database functions do not support other database data types. The list below contains examples of such types. These types are usually very large data types, or custom objects, structures, and similar types.

  • Large object data types such as BLOB and CLOB

  • User-defined structures and objects

  • User-defined collections and arrays

  • Spatial and geometry data types

  • JSON and XML

 

This chapter includes the following sections: