Archives of the TeradataForum

Message Posted: Fri, 17 Dec 2010 @ 17:06:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Try something like this:

Below query will create a show procedure statement for all the procedures in a database.

     sel 'show procedure ' || trim(databasename) ||'.'|| trim(tablename) ||';'
     from dbc.tables
     where databasename = 'DBNAME'
     and tablekind = 'P'
     and tablename like '%name%' -- if required to filter with some specific table

Once the definition has been created we can run the set of show procedure definition and get the DDL for the procedure.

Hope this helps.

Thanks & Regards,

C. Murugavel

	<Prev	Next>		<<First	<Prev	Next>	Last>>