# V10 for z/OS : Find A Row Based on a RID ?

#### John Bucaria

V10 for z/OS : Find A Row Based on a RID ?
Hello All,

Is it possible (yet) to find a row in a table based on a RID displayed in the message returned from an SQLCODE -803? If so, how?

Thanks,
John

#### Venkat Srinivasan

RE: V10 for z/OS : Find A Row Based on a RID ?
(in response to John Bucaria)

SELECT * FROM SCHEMA.TABLE where RID(SCHEMA.TABLE) = value

Hello All,

Is it possible (yet) to find a row in a table based on a RID displayed in the message returned from an SQLCODE -803? If so, how?

Thanks,
John

#### John Bucaria

V10 for z/OS : Find A Row Based on a RID ?
(in response to Venkat Srinivasan)
Thanks Venkat!

Does the RID value have to be converted from HEX to decimal before this construct can be used?

Sent: Thursday, April 06, 2017 12:51 PM
Subject: [DB2-L] - RE: V10 for z/OS : Find A Row Based on a RID ?

SELECT * FROM SCHEMA.TABLE where RID(SCHEMA.TABLE) = value

Hello All,

Is it possible (yet) to find a row in a table based on a RID displayed in the message returned from an SQLCODE -803? If so, how?

Thanks,
John

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

#### dusan pospisil

V10 for z/OS : Find A Row Based on a RID ?
(in response to John Bucaria)
At least I always convert it to decimal

regards
dusan

> Thanks Venkat!
>
>
>
> Does the RID value have to be converted from HEX to decimal before this
> construct can be used?
>
>
>
> *Sent:* Thursday, April 06, 2017 12:51 PM
> *Subject:* [DB2-L] - RE: V10 for z/OS : Find A Row Based on a RID ?
>
>
>
> SELECT * FROM SCHEMA.TABLE where RID(SCHEMA.TABLE) = value
>
> In Reply to John Bucaria:
>
> Hello All,
>
> Is it possible (yet) to find a row in a table based on a RID displayed in
> the message returned from an SQLCODE -803? If so, how?
>
> Thanks,
> John
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>