How to Use the BTEQ Script File | Basic Teradata Query - 17.00 - Using the Script File - 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

The following example shows how to create and execute an SQL stored procedure from the script file, when the script is running in ANSI mode. The example.spl file contains the stored procedure source text.

.LOGON e/fml,notebook
.COMPILE FILE = example.spl;
COMMIT;
CALL samplesp1 (8888, pAmount);
.LOGOFF

The next example is a script for a session running in Teradata mode:

.LOGON e/fml,notebook
BT;
.COMPILE FILE = example.spl;
ET;
CALL samplesp1 (pAccountNo, 10000.00);
.LOGOFF