RE: Unique identifer for keyed sequence

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

One thing to remember, and I just found this out ;-)....is the system doesn't 
guarantee that the IDENTITY column is unique unless one or both of the 
following is true:

1) Column is GENERATE ALWAYS and specifies NO CYCLE

2) Column is the only member of a unique/primary key constraint 


Also note that the system doesn't guarantee that it will use all possible 
values in sequence.  In other words, you might add three records and get 1,2,3. 
 Another job adds three records and gets 21,22,23.  Values 4-19 never get used. 
 Similarly there is also no relationship between the RRN and the value of the 
identity column.

HTH,


Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Booth Martin
> Sent: Wednesday, April 27, 2005 2:02 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: Unique identifer for keyed sequence
> 
> 
> ok,  I hear you.  So,  I can alter the file DDS with SQL, and 
> then RPG, DDS,
> WRKQRY will recognize the new trait? 
> 
> 
> 
> Is there a downside that I need to be prepared for?
> 
>  
> 
> ---------------------------------
> 
> Booth Martin
> 
> http://www.martinvt.com
> 
> ---------------------------------
> 
> -------Original Message-------
> 
>  
> 
> From: Midrange Systems Technical Discussion
> 
> Date: 04/27/05 12:47:40
> 
> To: Midrange Systems Technical Discussion
> 
> Subject: RE: Unique identifer for keyed sequence
> 
>  
> 
> >how about in DDS?
> 
>  
> 
> DDS is the Dead Data Specification. Get used to using SQL. You can
> 
> always ALTER TABLE a DDS table if you need to use DDS as a baseline.
> 
>  
> 
> -Walden
> 
>  
> 
> ------------
> 
> Walden H Leverich III
> 
> Tech Software
> 
> (516) 627-3800 x11
> 
> WaldenL@xxxxxxxxxxxxxxx
> 
> http://www.TechSoftInc.com
> 
>  
> 
> Quiquid latine dictum sit altum viditur.
> 
> (Whatever is said in Latin seems profound.)
> 
>  
> 
>  
> 
> --
> 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> 
> To subscribe, unsubscribe, or change list options,
> 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> 
> Before posting, please take a moment to review the archives
> 
> at http://archive.midrange.com/midrange-l.
> 
>  
> 
>  
> 
> .
> -- 
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>