Posted: Wed Jun 06, 2012 12:19 pm Post subject: Objects associated with a table
Hi ,
Please some one let me know for a table where we can get all the associated objects defined aganist that table. Can this informatio we get by querying the catlog tables?
Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
Posted: Wed Jun 06, 2012 12:57 pm Post subject: Re: Objects associated with a table
rajeev5174 wrote:
Hi ,
Please some one let me know for a table where we can get all the associated objects defined aganist that table. Can this informatio we get by querying the catlog tables?
Thanks,
Raj
What do you mean associated OBJECTS? Do you mean parent child relationship tables? If so check this link
Joined: 08 Oct 2004 Posts: 274 Topics: 52 Location: California
Posted: Wed Jun 06, 2012 5:15 pm Post subject:
I use this query.
Code:
SELECT B.BNAME,
A.NAME,
A.OWNER,
A.COLLID,
A.VERSION,
A.VALID,
A.OPERATIVE,
A.TIMESTAMP,
A.BINDTIME,
A.PKSIZE,
A.ISOLATION
FROM SYSIBM.SYSPACKAGE A,
SYSIBM.SYSPACKDEP B
WHERE (A.COLLID=B.DCOLLID
AND A.NAME=B.DNAME
AND B.BNAME IN (YOUR TABLE)
AND B.BQUALIFIER='YOUR DATABASE'
AND B.BTYPE='T')
GROUP BY B.BNAME,
A.NAME,
A.OWNER,
A.COLLID,
A.VERSION,
A.VALID,
A.OPERATIVE,
A.TIMESTAMP,
A.BINDTIME,
A.PKSIZE,
A.ISOLATION
FOR FETCH ONLY WITH UR;
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
