Check out EXPJRNE at
http://www.tools400.de/English/Freeware/Utilities/utilities.html
Quote from site: "The EXPJRNE command exports journal entries of files, data
areas and data queues to an output file. The output file has the same layout
as the journalized file plus the journaling information. EXPJRNE makes it
really easy to analyze journal entries by SQL."
You could copy all of the data base fields from that output file to an empty
copy of the database file.
Another option would be to create a version of EXPJRNE that extracts only
the database fields.
EXPJRNE does let you select by start/end date and time.
Hope this helps!
Richard
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Thursday, June 14, 2012 5:33 PM
To: 'Midrange Systems Technical Discussion'
Subject: retrieving PF records from journal
How can I get (for example) customer records from a journal receiver into an
empty copy of the CUST DB file (with externally described fields).
APYJRNCHG seems like the obvious choice, but doesn't seem to provide a
filter on START-DATE & TIME, which I need.
DSPJRN seems to bring back a string of the record buffer. What is an easy
method to copy this into externally-described fields?
Must I use an HLL? Can SQL do this with a substring?
Is there a simple way to accomplish this?
Thanks!
(ps my last post was mistaken, DBU on the DSPJRN outfile shows DB fields
which aren't really there!)
midrange.com
