|
|
|
Junior Member
 
Group: Forum Members
Last Login: 7/7/2008 2:17:32 AM
Posts: 24,
Visits: 90
|
|
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,
Satish Gaikwad
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 3:13:33 PM
Posts: 133,
Visits: 359
|
|
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
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 7/7/2008 2:17:32 AM
Posts: 24,
Visits: 90
|
|
Thanks it works...
Satish Gaikwad
|
|
|
|