Modifying a VMSTIMESTAMP in a field

[John Stires]

Due to a system problem, a number of records were not created when they should have been created.  Now we are trying to create these missing records for that date that have a time stamp for that day. The value normally placed in that field is VMSTIMESTAMP which is normally never manipulated or displayed.  When we went with the VMSTIMESTAMP value field, I told my boss that we would never be able to look at it or manipulate it; all it would do was to force records into a chronological order and make the indexes unique.  To that end, we are having only minor duplicate problems that we are handling during the batch process that creates these records.

Now, we have a number of records to create, in the hundreds, but need to have an appropriate value for the VMSTIMESTAMP for a day in the past. We can take another record containing a time stamp for that day. So far so good. Then if we could increment the time component by some value, we do not care what, so long as it ends up still for that day and we are not creating duplicate indexed records...a bad thing to do with unique indexes.  I know that the smallest increment coming out of a VMSTIMESTAMP is 100th of a second, but what do I have to add to be in that ball park is the question.

Does anyone have anything in their bag of tricks that you can come up with that may be of some help???  We are running on OpenVMS 6.2 with 7.10e6 PowerHouse with an RDB database.

Thanks for any help anyone can give.

John


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20050815/c9c5c277/attachment.html