473,396 Members | 1,756 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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.
Jul 19 '08 #1
2 2763
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
Jul 19 '08 #2
On 19 ÌæáÜ, 17:08, Serge Rielau <srie...@ca.ibm.comwrote:
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
Sep 14 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Aaron W. West | last post by:
Timings... sometimes there are almost too many ways to do the same thing. The only significant findings I see from all the below timings is: 1) Integer math is generally fastest, naturally....
1
by: Dominic Marks | last post by:
Hi, (I apologise if this is the wrong list, I haven't posted to a postgresql.org mailing list before, general seemed like a good catch-all) I am trying to implement a centralised...
7
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
2
by: Hugh O | last post by:
Hi, I have a Web app using VS.Net 2003, ASP and VB. I am using RDO with a SQL Server 2000 database. The code below shows an example of a NewRow method. In the first column there is a integer...
13
by: pb648174 | last post by:
Whenever I want help on a query, I get told my design is wrong, So this time I'm posting a message during the design phase: How am I going to perfectly design the following? We want to be able...
5
by: rdemyan via AccessMonster.com | last post by:
I have a need to add another field to all of my tables (over 150). Not data, but an actual field. Can I code this somehow. So the code presumabley would loop through all the tables, open each...
1
by: hirak chatterjee | last post by:
Hi, i want to find interrelations among all the primary keys in all the tables. for e.g== the output will be .....is the primary key of table............ .....is the primary key of table........
2
by: Danny | last post by:
Hello, We imported a bunch of tables from a database and realized that the primary keys weren't copied to the destination db. In order to re- create the keys, we need to know which tables have...
1
by: Jenniferdb2 | last post by:
We recently identified a table on a primary HADR database that had been loaded with the parm "nonrecoverable" thus the table was unavailable to the HADR standby copy. The table was...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.