Command Execution | Basic Teradata Query - 17.00 - Command Execution - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Specify the following command to create SQL stored procedures within a database:

.COMPILE FILE = example.spl;

The COMPILE command processes only SQL stored procedures.

As BTEQ processes the COMPILE command, it uses the specified file’s content as the SQL stored procedure source text input. It sends the SQL stored procedure source text to the database for processing the SQL stored procedure definition.