Use a text editor to include a stored procedure in a BTEQ script or input stream file. To execute the procedure samplesp1 from a script, for example, enter the Teradata SQL CALL statement after the LOGON statement in the script:
.LOGON tdpid/userid, password CALL samplesp1 (8888, pAmount); .LOGOFF