16.20 - Executing Programs in Teradata Database - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

It is possible to use SQL statements to execute user-defined programs in Teradata Database. To do this, first define the programs using the SQL statements CREATE FUNCTION, CREATE METHOD, or CREATE PROCEDURE. These SQL statements create an ElicitFile parcel in the response that prompts CLIv2 to provide the program's source.