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

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

"ROWID is similar to identity columns. But rather than being an attribute
of a numeric column, it is a separate data type."
https://www.ibm.com/docs/en/i/7.5?topic=language-using-rowid

On Wed, Mar 5, 2025 at 10:07 AM Patrik Schindler <poc@xxxxxxxxxx> wrote:

> 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.