InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:53:18 GMT20http://www.teradata.com/teradataforum/Topic11942-9-1.aspxThanks it works...Mon, 23 Jun 2008 03:30:51 GMTmeetsatishg@gmail.comhttp://www.teradata.com/teradataforum/Topic11942-9-1.aspxHello,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,AdeelMon, 23 Jun 2008 02:12:52 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11942-9-1.aspxHi,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,Mon, 23 Jun 2008 01:31:08 GMTmeetsatishg@gmail.com