Using the Script File - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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