Using VMSTIMPESTAMP as part of an index

[John Stires]

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050607/5bbca86b/attachment-0001.html