我想在某个数据库中创建存储过程的列表。我尝试了
db2 "display procedure MyDb.*"
但我得到错误
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "procedure" was found following "display ".
Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601
在另一个论坛中,我看到我必须查询表syscat.procedures
但如果我打电话
db2“从syscat.过程中选择 *”
我得到了很多我无法真正理解的数据。
2条答案
按热度按时间a11xaf1n1#
删除详细信息......这将只显示过程名称:
SELECT procname FROM syscat.procedures WHERE procschema = 'MYSCHEMA'
knsnq2tg2#
不要直接查询syscat.procedures表,而是尝试使用SQLProcedures()存储过程。可以使用许多输入参数来自定义结果。