what is the structure and use of sysibm.syslink table ?

geek_mohit · New User Joined: 19 May 2006 Posts: 23

Hi All can anyone tell me the structure and the use of sysibm.syslink table and what exactly is a subselect and how do we use it ?

I would really appreciale a quick reply....Thanks

geek_mohit · New User Joined: 19 May 2006 Posts: 23

Hi people nobody replied to my query but I did got some information somehow....it might be useful for some one else as well...

You can determine the nature of links by querying the DB2 Catalog table, SYSIBM.SYSLINKS. This single DB2 Catalog table stores the information defining the relationships between other DB2 Catalog tables.

The colums in this table are PARENTNAME, TBNAME, LINKNAME,CHILDSEQ, COLCOUNT and INSERTRULE

1. The PARENTNAME is the name of the superior, or parent table in the hierarchy.
2. TBNAME is the name of the subordinate, or child table in the hierarchy
3. The CHILDSEQ and COLCOUNT columns refer to the clustering and ordering of the data within the relationship.
4. The INSERTRULE determines the order in which data will be inserted into the relationship