MVSFORUMS.com

[sonika2008]

Hi,

I have used these two queries for primary key -
1)SELECT * FROM SYSIBM.SYSKEYS
WHERE IXCREATOR='Creator';

2)SELECT NAME
FROM
SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'Table Name'
AND TBCREATOR = 'Creator'
AND KEYSEQ > 0
ORDER BY KEYSEQ ASC

but for some tables these queries are not working.
Is there any other way from which I can find the primary key for DB2 tables?

[kolusu]

sonika2008,

You should be checking SYSIBM.SYSINDEXES. Also it is not always possible to retrieve information about unique keys Created before Version 7. Information can be retrieved for unique Keys created in Version 7 and for unique keys created before Version 7 if they are not involved in referential integrity.

Any way check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=24&highlight=parent

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[sonika2008]

Thanks for your quick response!!

Actually, I was trying to find primary key in order to uniquely identify the rows for comparison purpose (I am unloading 2 versions - older and newer - of Image copies of DB2 tables and then I need to compare those 2.)

But, now, as you say, if I can't find primary key for older tables which were created before version 7, Can you please suggest me any other way by which I can uniquely identify the rows?

[videlord]

1. even the old record and the new reord with the primary key, they may be different too (not primary key columns have been updated)

2. Why not sort the 2 unloaded files in the same order, and use SUPERC utility to compare them.

[sonika2008]

Thanks for your reply.

I have used SUPERC utility for comparison, but its not working fine for millions of record.Right now I am using the File-manger compare utility, for that compariosn I need to give the primary key fields as per my output requirement.

So plz give suggestion to find out the primary key or unique column in table

[videlord]