Command Execution

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

Specify the following command to create SQL stored procedures on the Teradata server:

.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 Teradata server for processing the SQL stored procedure definition.