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.