Re: [SQL] RowID - what is it and when to use it

[Daniel Gross <daniel@xxxxxxxx>]

IIRC a ROWID value is unique even over multiple systems - so there shouldn't be any duplicate values even over multiple partitions - and even in combination with Db2/z. 

It's implemented as a char(40) ccsid(*hex) binary field - most probably including a MAC address or something else unique, like a GUID. 

HTH 
Daniel


> Am 05.03.2025 um 16:07 schrieb Patrik Schindler <poc@xxxxxxxxxx>:
>
> Hello,
>
> I'm trying to grok the difference between an ordinary identity column and the RowID. I thought I had once seen a discussion in this list about that, but I can't find it in the archive through an appropriate Google search. What is this RowID compared to an ordinary identity column, and what would be typical use cases/benefits of using it instead of normal identity columns?
>
> Also, more generic Google searches did not come up with helpful enlightenment regarding my question.
>
> Thanks!
>
> :wq! PoC
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.