Terry,
You can use non-destructive reads by specifying the COPY option on a file equation as in:
FILE MSGFILE;COPY
FCOPY FROM=*MSGFILE;TO=NEWFILE
There's also an FOPEN Aoptions (bit 3:1) to enable the option.
As for editing a message file, the only safe way I know is to extract all the records into a regular flat file, edit it and load it back into the message file.
HTH
Thanks...François
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Simpkins, Terry
Sent: Wednesday, March 09, 2011 12:29 PM
To: [log in to unmask]
Subject: [HP3000-L] Message file question
We use NETBASE to shadow our Production databases to a 'backup' HP3000.
We also use Bridgeware from Taurus to 'shadow' the data to SQL versions
of the IMAGE database onto a Windows machine. NETBASE uses message
files to transmit the IMAGE database changes to Taurus who then performs
the SQL changes (puts, changes & deletes). From time to time, I need to
'manipulate' the message file records going to Taurus. Specifically I
need to find and delete certain records in the message. These records
could (certainly are) intermixed throughout the message file.
My question is what tools can I use to 'edit' a message file without
destroying the file?
I learned today (the hard way) that using FCOPY to copy from a message
file, destroys the records read from the message file. Can you "COPY" a
message file without destroying the records that are copied?
Terry W. Simpkins
Director Business Systems
Measurement Specialties, Inc.
office: +1 757-766-4278
mobile: +1 757 532-5685
[log in to unmask] <mailto:[log in to unmask]>
www.meas-spec.com <http://www.meas-spec.com>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|