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

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

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?

From: Venkat Srinivasan [mailto:[login to unmask email]
Sent: Thursday, April 06, 2017 12:51 PM
To: [login to unmask email]
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-----

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

2017-04-06 19:04 GMT+02:00 Bucaria, John <[login to unmask email]>:

> Thanks Venkat!
>
>
>
> Does the RID value have to be converted from HEX to decimal before this
> construct can be used?
>
>
>
> *From:* Venkat Srinivasan [mailto:[login to unmask email]
> *Sent:* Thursday, April 06, 2017 12:51 PM
> *To:* [login to unmask email]
> *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-----
>