Is it possible to findout primary ID, multiple Secondary ID

mbr_raja · Posted: Tue Sep 05, 2006 1:49 pm

Is it possible to findout Primary ID and multiple Secondary ID through by means of SPUFI or anyother utility to find out.

sushil_ach · New User Joined: 01 May 2006 Posts: 6

Yes it is possible , u can try this querry.... let me know if it doesn't work..

SELECT NAME FROM SYSIBM.SYSCOLOUMNS
WHERE TBCREATOR = <TABLE CREATOR NAME>
AND TBNAME = <TABLE NAME>
AND KEYSEQ > 0 ;

OR,

SELECT A.COLNAME,
A.COLSEQ,
A.ORDERING,
FROM SYSIBM.SYSKEYS A,
SYSIBM.SYSINDEXES B
WHERE A.IXNAME = B.NAME
AND A.IXCREATOR = B.CREATOR
AND B.TBNAME = <TABLE NAME>
AND B.TBCREATOR = <TBCREATOR>
AND B.UNIQUERULE = 'P' ;