SQL code -803: how to retrieve the data?

Eugene Zeev

SQL code -803: how to retrieve the data?

Hi community members.
DB2 V11 produces error message of code -803 with these text:
RID OF EXISTING ROW IS X record-id
Is it possible to retrieve data from the table using this RID if the table does not contain an RID column?

Daniel Luksetich

SQL code -803: how to retrieve the data?
(in response to Eugene Zeev)
Hello,

The listserv rules dictate that you are to use your full name so please update that in your idug membership or I will block you.



Now….

Select * from table1

where

rid(table1) = <value>



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IBM Certified Database Adminstrator – DB2 11 DBA for z/OS

IBM Certified System Administrator – DB2 11 for z/OS

IBM Certified Application Developer – DB2 11 for z/OS

IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows



From: ugine z [mailto:[login to unmask email]
Sent: Tuesday, July 25, 2017 4:45 AM
To: [login to unmask email]
Subject: [DB2-L] - SQL code -803: how to retrieve the data?



Hi community members.
DB2 V11 produces error message of code -803 with these text:
RID OF EXISTING ROW IS X record-id
Is it possible to retrieve data from the table using this RID if the table does not contain an RID column?



-----End Original Message-----

John Bucaria

SQL code -803: how to retrieve the data?
(in response to Daniel Luksetich)
BTW, I think you have to first convert the RID hex value to decimal before supplying it in the below SQL

From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Tuesday, July 25, 2017 10:28 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: SQL code -803: how to retrieve the data?

Hello,
The listserv rules dictate that you are to use your full name so please update that in your idug membership or I will block you.

Now….
Select * from table1
where
rid(table1) = <value>

Daniel L Luksetich
DanL Database Consulting

IBM GOLD Consultant
IBM Champion for Analytics
IDUG Content Committee Past-Chairman
IBM Certified Database Adminstrator – DB2 11 DBA for z/OS
IBM Certified System Administrator – DB2 11 for z/OS
IBM Certified Application Developer – DB2 11 for z/OS
IBM Certified Advanced Database Administrator – DB2 10.1 for Linux UNIX and Windows

From: ugine z [mailto:[login to unmask email]
Sent: Tuesday, July 25, 2017 4:45 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - SQL code -803: how to retrieve the data?


Hi community members.
DB2 V11 produces error message of code -803 with these text:
RID OF EXISTING ROW IS X record-id
Is it possible to retrieve data from the table using this RID if the table does not contain an RID column?

-----End Original Message-----

-----End Original Message-----