MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2008

RE: What is the function that adds a row ID column and auto-increments



fixed

I think this is the thread you're referring to:

http://archive.midrange.com/midrange-l/200805/msg01233.html

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com

-----Original Message-----
Subject: What is the function that adds a row ID column and auto-increments

I've forgotten, but what is the function that allows me to have a column put
on an existing table or at table creation, wherein the additional column
auto-increments when a new row is added to the table thus allowing a unique
key to be created. I'm thinking ROWID but whatever it is must survive a
reorg and not lose uniqueness.

This is to solve a problem where DataPropagator would prefer to have source
tables that have unique indexes or unique keys so unique indexes can be
produced for the target table. I'm faced with tables that have NO unique
constraints on the source side (Production) so applications can put in
duplicate rows, willy-nilly.

I know I could use the RRN capability but that doesn't survive any reorg.

Thanks in advance,

Dave Odom
Arizona







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact