Batch execution of stored procedures

Database
Enthusiast

Batch execution of stored procedures

Hi,

I need to execute the stored procedures is batch.I am having 40 stored procedures and I need to execute all these in single batch i.e all 40 gets created in one execution.

If someone knows please let me know.

Thanks,
2 REPLIES
Teradata Employee

Re: Batch execution of stored procedures

Hello,

All you have to do is it place all the definitions of all the SPs in seperate files e.g. sp1.spl, sp2.spl,..., sp40.spl. Write a BTEQ script as follows:

.LOGON ...;

DATABASE ...;

.COMPILE FILE = sp1.spl;
.COMPILE FILE = sp2.spl;
...
.COMPILE FILE = sp40.spl;

.LOGOFF;

Place all these files in 1 folder and execute the BTEQ script.

HTH.

Regards,

Adeel
Enthusiast

Re: Batch execution of stored procedures

Thanks it works...