Pinned topic SysProgramStat catalog view
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I'm looking for a way to cross-reference program usage to the rest of the catalogs but in reviewing SysProgramStat, I don't see any way to tie a given program to a table, view, or even the SQL statement contained in the program. What is the intended purpose of this view? Are there any other catalog views that contain the program name that could be referenced back to this view?
Updated on 2012-08-16T05:39:49Z at 2012-08-16T05:39:49Z by B.Hauser
B.Hauser 1000007U1D298 Posts
Re: SysProgramStat catalog view2012-08-16T05:39:49ZThis is the accepted answer. This is the accepted answer.SysProgramStat lists the SQL Routines, i.e. SQL Stored Procedures, SQL User Defined Functions, SQL Triggers and External Programs/Service Programs and Procedures that are registered as Stored Procedures and User Defined Functions. It also shows the compile options, i.e. options automatically set or set with the SET OPTION statement.
AFAIK there is no catalog view that shows which file/table/view is used within a program, service program or procedure with either native I/O and/or embedded SQL.