Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Why would I get #Deleted in a DB2 table in a select query

Status
Not open for further replies.
Goot

Goot

Programmer
Aug 4, 2005
86
0
0
US
I am using ODBC to access a DB2 database. I have taken over a query that someone is working on.
I am getting #Deleted in the columns from the table on the right side of the join. Infact, if I try to open table in the Query tool, I get #Deleted for all the columns,
Can someone explain what this means?

Thanks
 
Sort by date Sort by votes
That usually means that the records from the DB2 table were deleted.
 
Upvote 0 Downvote
Hi

I just got the query to work, actually the records are not deleted.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
178
lameid
lameid
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
170
combo
combo
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
108
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
77
Andrzejek
Andrzejek
serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
296
serino
serino

Part and Inventory Search

Sponsor

Back
Top