DB2 学习笔记 - AIView.com

select procname, valid from syscat.procedures where procschema = upper('zytst')

a procedure A is called in another procedure B, then says A is depended by B, or B depends A.

When we rebuild procedure A, B will not work untill you rebuild B too after A was rebuilt.

See following test case.

db2 => create procedure zytst.a() begin return 0; end
db2 => create procedure zytst.b() begin call zytst.a; return 0; end
db2 => select procname, valid from syscat.procedures where procschema = upper('zytst')

PROCNAME	VALID
------------------------
A			Y
B			Y
 db2 => call zytst.a

return status = 0
 db2 => call zytst.b

return status = 0

db2 => drop procedure zytst.a
db2 => create procedure zytst.a() begin return 0; end db2 => select procname, valid from syscat.procedures where procschema = upper('zytst')

PROCNAME	VALID
------------------------
A			Y
B			Y

db2 => call zytst.b

SQL0440N  未找到类型为 "PROCEDURE" 命名为 "ZYTST.A"
且具有兼容自变量的已授权例程。  SQLSTATE=42884
 db2 => drop procedure zytst.b
db2 => create procedure zytst.b() begin call zytst.a; return 0; end
 
db2 => call zytst.b

return status = 0