Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
STEVEN BLACK — — source: IIUG Forums & Mailing Lists
Hi all,
Is there a way via system catalog tables to see a stored procedure's table
dependency list?
The sysprocplan table encodes the dependency list, but is there a way to see
the un-encoded list?
I did find Sujit Pal's Perl script (FAQ) for building the column and table
dependency list which looks useful, but was just wondering if there's another
way to determine the list via system catalog tables. Maybe an "un-encode"
function would be helpful.
Thanks
Steve
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.