Executing Stored Procedures - Basic Teradata Query - 16.20

Basic Teradata Query Reference

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

Execute stored procedures either interactively, or include them in BTEQ scripts or input stream files.

Use the Teradata SQL CALL statement to execute a stored procedure interactively:

CALL samplesp1 (8888, pAmount);

If the procedure is created with parameters, specify the parameter arguments within the parenthesis.