RE: Fastest way to get a unique identifier/tracking column change s

Just a quick FYI, but GENUUID may not guarantee a unique ID.

Check out this thread in the newsgroup:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=9nu8eb.dt1.ln%40m
odula.bender-dv.de&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26selm
%3D9nu8eb.dt1.ln%2540modula.bender-dv.de

Seems as if duplicates can occur on a multi-processor system when multiple
processes are using it at the same time.
Unless it turned out to be a bug that was corrected.


HTH,
Charles


> -----Original Message-----
> From: Kevin Mohondro [mailto:kevin.mohondro@xxxxxxxxxxxxxxx]
> Sent: Monday, July 12, 2004 1:29 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Fastest way to get a unique identifier/tracking column
> change s
> 
> 
> You could get a UUID (Universally Unique IDentifier). This 
> will give you a
> unique ID that you could use.
> 
> D getUUID         PR                  ExtProc('_GENUUID') 
> D  UUID_DS                        *   Value               
> 
> D UUID_DS         DS                                              
> D  BytPrv                       10u 0 Inz(%size(UUID_DS))
> D  BytAvl                       10u 0                             
> D  Hold                          8a   Inz(*allx'00')            
> D  UUID                         16a                               
> 
> C                   CallP     getUUID(%addr(UUID_DS))
> C                   Eval      Key = UUID                   
> 
> -Kevin
> -=-=-=-=-=-=-=-=-
> Kevin R Mohondro
> Programmer/Analyst
> Ashworth, Inc
> 
> -----Original Message-----
> From: Reeve Fritchman [mailto:reeve.fritchman@xxxxxxxxxx]
> Sent: Monday, July 12, 2004 7:22 AM
> To: 'Midrange Systems Technical Discussion'
> Subject: Fastest way to get a unique identifier/tracking 
> column changes
> 
> 
> I'm designing a new system with a requirement for detailed 
> tracking of, and
> inquiry into, column-level changes.  I've decided to build a 
> single file
> with before and after values, etc. for all the tables by 
> using triggers.
> Some of the tables have complex keys (order number/SKU/shipper
> location/consignee location/release number), and I don't want 
> to burden my
> historical tracking file with a nasty key structure to 
> support inquiry into
> the details of the changes.  I'm not going to track added records or
> date-of-last-change timestamps in the tables; the majority of 
> the changes
> will be on a limited number of columns (of the status and 
> date nature).
> 
>  
> 
> My design is to assign every row an "entity number"; the 
> entity number would
> be like a record serial number, would be unique on a 
> system-wide basis, and
> would be the key to the historical tracking table.  When a 
> user wants to see
> the details of the changes to a specific row, the row's 
> entity number would
> allow simple access to the tracking file.  Using SQL's AS 
> IDENTITY with the
> table name could work to provide a key to a specific record.
> 
>  
> 
> The challenge is to determine a way to get the entity number quickly.
> Having a control file is okay but probably limiting performance-wise;
> another possibility is a journaled data area.  Is there a system API
> providing a guaranteed unique sequential number?  Or is there a better
> approach for tracking column-level changes?
> 
>  
> 
> Thanks,
> 
> Reeve
> 
>  
> 
>  
> 
> --
> 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.
> 
> ##############################################################
> #######################
> Attention:
> The information contained in this message and or attachments 
> is intended
> only for the person or entity to which it is addressed and may contain
> confidential and/or privileged material.  Any review, retransmission,
> dissemination or other use of, or taking of any action in 
> reliance upon,
> this information by persons or entities other than the 
> intended recipient
> is prohibited. If you received this in error, please contact 
> the sender and
> delete the material from any system and destroy any copies.
> 
> Thank You.
> ##############################################################
> #######################
> --
> 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.
>