Adam, Session tables created using DGTT (declared global temporary table) do not exist in the catalog tables. However, Session tables created using CGTT (create
global temporary table) are.
I do not know the method Quest uses to search for dependencies. But I think something better than what is in place may have to be developed (such as scanning
the text of packages and views).
Please call me to discuss existing dependency methodology.
Richard Chouanard, analytics consultant
DB2 Database Administrator
*Payment Operations Management/Float Datamart
From: Adam Ririe [mailto:firstname.lastname@example.org]
Sent: Thursday, September 11, 2014 1:48 PM
Subject: RE: [Toad for IBM DB2 - Beta Discussion Forum] Toad for DB2 LUW v6.0 B0111 - Obejct Explorer\ Dependencies Tab Doesn’t Display all Dependencies
Reply by Adam Ririe
Now I see. This was a trick question I guess should have noticed the SESSION schema.
I’m not sure this dependency exists in the catalog. It’s not in packagedep, and the object only exists during the session. Do you know a way of finding this dependency?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for IBM DB2 - Beta notifications altogether.
Toad for IBM DB2 - Beta Discussion Forum
this post as spam/abuse.