如何在Teradata中提取存储过程正文 [英] How to extract Stored Procedure body in Teradata

问题描述

我正在尝试通过查询系统表来提取存储过程DDL.
如果我运行以下查询

I'm trying to extract Stored procedure DDL by querying system tables.
If I run the following query

从dbc.tvm中选择*，其中TableKind ='P'

两个字段 RequestText 和 CreateText 都包含NULL. 除了使用SHOW PROCEDURE，还有什么方法可以查询存储过程正文?

both fields RequestText and CreateText contain NULL. Is there any way to query Stored Procedure body apart from using SHOW PROCEDURE?

谢谢.

推荐答案

存储过程的DDL(SPL)未存储在数据字典表中.如果您没有将DDL保留在版本控制的存储库中，则需要在BTEQ脚本中编写SHOW PROCEDURE命令的脚本并将其导出到平面文件.如果您对数据字典的查询很有创意，则可以动态生成此BTEQ脚本.

The DDL (SPL) for the Stored Procedures is not stored in the data dictionary tables. If you do not retain your DDL in a repository for version control you will need to script the SHOW PROCEDURE commands in a BTEQ script and export them to flat files. This BTEQ script can be generated dynamically if you are creative with your queries against the data dictionary.

这篇关于如何在Teradata中提取存储过程正文的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！