Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
HP.com home

HP OpenVMS Systems

ask the wizard
Content starts here

Merging RMS Indexed Files?

» close window

The Question is:

 
Dear wizzard,
 
I am merging two files Indexed Sequential files (say A and B) and, where
there are dupliacates, I want to keep A's records and discard B's records.
To do this I have been editing file A then INCluding file B to the bottom of
this.
 
I then use the Convert/fdl/nofast command and this converts the file into
ISF format with some expected duplicates being outputed to a file.  However,
the problem is that in certain cases file B's duplicates are being kept
whilst file A's duplicates are d
isgarded.
HELP!
What can I do to stop this happening?
 
Thanks
 
Sam
 


The Answer is :

  The technique described for merging SYSUAF files into a single
  OpenVMS Cluster -- as described in the appendix of the OpenVMS
  Cluster Systems manual -- might be of interest.  The technique
  uses CONVERT, and the documentation descibes how duplicate
  records are handled.  (SYSUAF is an RMS indexed file...)
 
  On the face of it, the command:
 
    $ MERGE/STABLE/NODUPLICATES A,B output
 
  should do exactly what you want. If not, it may be worth considering
  writing a program to preform the merge precisely as you want. This would
  use a minor variation of the classical "Sequential Master File Update"
  algorithm which can be found in any Computer Science text.
 

answer written or last revised on ( 3-NOV-1999 )

» close window

 

** About PDF files: The PDF files on this Web site can be read online or printed using Adobe® Acrobat® Reader. If you do not have this software installed on your system, you may download it from Adobe's Web site
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2008 Hewlett-Packard Development Company, L.P.