Using VMSTIMPESTAMP as part of an index

[brian_matthewsbrian matthews]

if two users write rows at the same 'split second' they'll get the same 
segment value, so I would recommend using syntax below with an RMS indexed 
file, where unqrecordname_count is an 8 byte integer,

lock unqrecordname record
get unqrecordname  using keyval via rec_key
let unq_table_seg = unqrecordname_count
let unqrecordname_count  = unqrecordname_count + 1
put unqrecordname reset
unlock unqrecordname

that is, unless RDB has either of these functions - with SQLserver you can 
achieve this with autoincrement/uniqueidentity columns, with Oracle you can 
use sequences

regards Bri,




>From: John Stires <pencarver at sbcglobal.net>
>To: powerh-l at lists.sowder.com
>Subject: Using VMSTIMPESTAMP as part of an index
>Date: Tue, 7 Jun 2005 17:36:07 -0700 (PDT)
>
>
>We have a history file that gets a tremendous number hits at various times 
>of the day.  We have concerns about the accuracy of this history table and 
>that the order, sequence, the records are written to this table is 
>absolutely accurate.
>
>
>
>We need to have a highly accurate (high precision) date/time stamp solely 
>for the purpose of sequentially retrieving records in an RBD database.  A 
>value will never be used in this field to access any given record(s) in 
>this table.  As I say, the only reason for this field is to force a unique 
>key and to facilitate their sequential retrieval.
>
>
>
>We are running on a Vax running OpenVMS, V6.2, with PowerHouse version 
>7.10.E6.
>
>
>
>We have a bit of a discussion as to whether VMSTIMESTAMP would be a viable 
>option to populate this field.  Will VMSTIMESTAMP give us a reliable value 
>for this purpose?  If it will not, does anyone have a better alternative?
>
>
>Thanks,
>pencarver
>(John Stires)
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!  
http://toolbar.msn.co.uk/