My Problem:
------------------
1- When I was trying to run some queries like below, I got the error
like this:
------------------------------ Command Entered
------------------------------
select * from bank1.abrnparam s ;
-----------------------------------------------------------------------------
SQL0540N The definition of table "BANK1.ABRNPARA MS" 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.SYSCOLUM NS.KEYSEQ by:
SELECT DISTINCT KEYSEQ, COUNT(*)
FROM SYSIBM.SYSCOLUM NS
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.
------------------
1- When I was trying to run some queries like below, I got the error
like this:
------------------------------ Command Entered
------------------------------
select * from bank1.abrnparam s ;
-----------------------------------------------------------------------------
SQL0540N The definition of table "BANK1.ABRNPARA MS" 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.SYSCOLUM NS.KEYSEQ by:
SELECT DISTINCT KEYSEQ, COUNT(*)
FROM SYSIBM.SYSCOLUM NS
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.
Comment