Hello Everyone,
I am having a problem with retrieving the primary keys of a table by using JDBC.
This is the code looks like

DatabaseMetaData data=con.getMetaData();
ResultSet primarykey=data.getPrimaryKeys(con.getCatalog(),sc hemaname, tableName);

primarykey.next() //which is returning a false.
but the table has a primary key.
Is there any other way to retrieve the primary key....

i would really appreciate if some one can reply me back.

Thanks in advance

I think somebody has already referred you to the manual describing the DB2 system catalog views. May be it's time to read it...

Here are the system catalog views:
DB2 Database for Linux, UNIX, and Windows

and this is the view you need to query from:
DB2 Database for Linux, UNIX, and Windows

Hello thanks a lot this answer helped me a lot because you gave me a specific one to look one more time thanks a lot......
I have used the following query may be in future for some one it might be useful..
"select t.TABSCHEMA,t.TABNAME, k.colseq, k.colname from syscat.keycoluse k, syscat.tabconst t where k.constname = t.constname and k.tabname = t.tabname and k.TABSCHEMA = t.TABSCHEMA and t.type='P'and t.TABSCHEMA NOT LIKE 'SYS%'";

Which eliminates the system tables and gets the all the primary keys....

Thanks,
swati