Command to recompile a procedure?

[CapsuleCorpJX]

Currently the way I recompile a stored procedure is to reexecute its definition.

Is there a teradata command that will recompile the procedure? Like: "recompile databasename.procedurename" and thus let me capture any errors it may return (for example: procedure can't be recompiled because a table or column that the procedure references no longer exists)

 

[dnoeth]

Starting with V2R5 there's
"alter procedure databasename.procedurename compile [with warning]"

Of course it's only possible if the procedure was created with source code.

Check the DDL manual...

Dieter