You can store executable procedures in the database and invoke them later using the SQL CALL statement. There are two types of stored procedures:
- SQL, consisting of statements written in the SQL Stored Procedure Language (SPL).
- External, consisting of statements written in a standard programming language such as C, C++, or Java, and able to call CLIv2.
See SQL Stored Procedures and Embedded SQL, B035-1148 for additional information on stored procedures.