All Forums Database
DaZzL3R 20 posts Joined 12/06
25 Mar 2010
Compile Stored Procedures in Batch

Version: TD V2R6
Environment: Mainframe

I am trying to find out how to compile Stored Procedure in Batch with just Referencing their Name and without including SP DDL statements. I know how to compile them by including DDL (like below), but what if we have 10 SP, and they need to be recompiled, do we still use their 10 DDL or is there a method to simply use their name and recompile all of them. I have tried using .COMPILE with SP name, but it requires File or DD name with it. I simply need to know Syntax. I search, but could not find it..

One SYSIN contains:
----------------------------
BT;
.COMPILE DD =

;
ET;
SHOW PROCEDURE ;

2nd SYSIN contains:
----------------------------
Create or Replace Stored Procedure

Jim Chapman 449 posts Joined 09/04
25 Mar 2010

You can recompile an existing procedure by submitting an ALTER PROCEDURE statement.

Example:

ALTER PROCEDURE myprocname COMPILE ;

DaZzL3R 20 posts Joined 12/06
25 Mar 2010

Thanks a Bunch, it worked....

covuppas 1 post Joined 06/11
03 Jun 2011

Thanks alot.. Alter statement works fine after changing the session to ANSI..

Mini

Qaisar Kiani 337 posts Joined 11/05
04 Oct 2012

for example?

ulrich 816 posts Joined 09/09
04 Oct 2012

If I understand your question correctly the answer would be no:
see Carries comment in 
http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

ratnamch 14 posts Joined 06/12
13 Oct 2012

plz send me any sp in teradata 
ex : 
1. check obect is exist or not?
2.if exists data will be insert ?
if not exists object/table will created .
after inserts data ?
 
so plz send me the above senarrio? ans procedure 
 
thank's
ratnam

You must sign in to leave a comment.