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.