Finding Tables without any Primary key

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.

Which platform and version of DB2 are you on?
Which client interface and version are you using?

(This smells like the client wants to keep bookmarks fro editing....)
Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

On 19 ÌæáÜ, 17:08, Serge Rielau wrote:
> Which platform and version of DB2 are you on?
> Which client interface and version are you using?
>
> (This smells like the client wants to keep bookmarks fro editing....)
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

Dear Friend,
I think the table has some BLOB and not defined good.
Our Database version is UDB v7.1 also.

I AM LOOKING FOR
how to define BLOB fields in the DB2 way (different tables) in my DB2
version?
Thanks