Finding Tables without any Primary key

Question posted by: amir (Guest) on July 19th, 2008 11:15 AM

My Problem:
------------------
1- When I was trying to run some queries like below, I got the error
like this:
------------------------------ Command Entered
------------------------------
select * from bank1.abrnparams ;
-----------------------------------------------------------------------------
SQL0540N The definition of table "BANK1.ABRNPARAMS" is incomplete
because it
lacks a primary index or a required unique index. SQLSTATE=57001
2- Also, when I tried to show some Tables in C#, I got same.

What I have done:
-------------------------
I tried to check the problem through checking the
SYSIBM.SYSCOLUMNS.KEYSEQ by:

SELECT DISTINCT KEYSEQ, COUNT(*)
FROM SYSIBM.SYSCOLUMNS
GROUP BY KEYSEQ;

All tables in my schema, has one key column at least.

What I need:
------------------
I need a solution for facing to error I got above.
Any help will appreciated, before.

Not the answer you were looking for? Post your question . . .
189,847 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).