You can store executable procedures in the Teradata 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.
Refer to SQL Stored Procedures and Embedded SQL (B035-1148) for additional information on stored procedures.