Archives of the TeradataForum

Message Posted: Wed, 20 Jun 2007 @ 20:18:46 GMT

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

<-- Anonymously Posted: Wednesday, June 20, 2007 14:09 -->

We have many stored procedures created by different users. Some procedures are compiled with SPL and some are with NOSPL.

Can anybody tell me how can I find which procedures are compiled with SPL and NOSPL? It is difficult and time consuming to do "SHOW PROCEDURE" for each and every procedure. Is there any DBC view which can give this information? FYI.. We are on V2R6.1

Thanks

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