InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:49:01 GMT20http://www.teradata.com/teradataforum/Topic11625-9-1.aspxThanks,I am using Teradata SQL Assistant 7.1Wed, 28 May 2008 05:01:10 GMTmeetsatishg@gmail.comhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxIt should work, this way in SQL Assistant as well, e.g I just tried following on V12:create procedure sp1()begin...end;create procedure sp2()begin...end;create procedure sp3()begin...end;In case of BTEQ scripts, suppose you are working in a folder "C:\SPTest" and you have saved all definitions (starting from "Create" till "End;") of all SPs in seperate files (e.g. sp1.spl, sp2.spl, sp3.spl) in the same folder, following BTEQ script will compile all three in batch mode:.LOGON server ip/login,pass;.DATABASE database;.COMPILE FILE = sp1.spl;.COMPILE FILE = sp2.spl;.COMPILE FILE = sp3.spl;.LOGOFF;HTH.Regards,AdeelWed, 28 May 2008 04:56:20 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxHi ,IF I am executing following three statements at a time then they get executed even if executed individually then they also get executed as like same I need to create 5 stored procedureCREATE TABLE ALFCT_STATICCHANNEL( STATICCHANNELID Decimal(18,0) NOT NULL, STATICCHANNELTYPE varchar(256) NULL)PRIMARY INDEX ( STATICCHANNELID );CREATE TABLE ALENT_ARTWORKCAMPAIGN( CAMPAIGNID Decimal(18,0) NOT NULL, CAMPAIGNNAME varchar(255) NULL, VALIDTO Timestamp NULL, CAMPAIGNTYPE varchar(100) NULL)PRIMARY INDEX ( CAMPAIGNID );CREATE TABLE ALFCT_STOCK( STOCKID Decimal(18,0) NOT NULL, STOCKLEVEL Decimal(18,0) NULL, MINORDERLEVEL Decimal(18,0) NULL)PRIMARY INDEX ( STOCKID );For my information will you please tell me how to create/Execute the batch in BTEQ.Wed, 28 May 2008 04:45:41 GMTmeetsatishg@gmail.comhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxFor my information, how can you write a batch in SQL Assistant?And can't you write a BTEQ script for a batch task?Regards,AdeelWed, 28 May 2008 04:37:56 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxThanks for Reply,I am using Teradata SQL Assistant for creation of the stored procedures.They get created if executing individually but i need to execute all in a batch.ThanksWed, 28 May 2008 04:34:29 GMTmeetsatishg@gmail.comhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxHello,If you are using BTEQ script for batch, you can use ".COMPILE FILE sp1.sql" to compile the SP.Regards,AdeelWed, 28 May 2008 04:28:08 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11625-9-1.aspxHi,I need to create multiple stored procedures in a single script, i meanI am having definitions of 5 stored procedures.Individually they get created but when same definitions are executed in batch then the following Error Occurs "Only an ET or null statement is legal after a DDL Statement. "If anyone knows the solution please let me know..ThanksWed, 28 May 2008 04:25:48 GMTmeetsatishg@gmail.com