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