 |
 |
Archives of the TeradataForum
Message Posted: Mon, 20 Dec 2010 @ 19:07:53 GMT
| Subj: | | Re: How to query spl text |
| |
| From: | | Dieter Noeth |
Quincy Leslie wrote:
| | Geoff: What is your view of developing a form of recursive SQL? The recursion can incorporate the strings, or do I mis-understand, and
you need to interrogate multiple Stored Procedures? | |
Besides SHOW PROCEDURE there's no way to access the source code of an SP. And within an SP it's not possible to use any kind of SHOW.
So you need some external program like BTEQ/Perl.
But as this is some kind of metadata retrieval Teradata's Meta Data Services should be the most elegant solution...
Dieter
| |
