Try the attached CMD JRNOUT and CLLE JRNOUTA.
Adapt JRNOUTA to user your journal. (comment on this is the source).
Brgds
Helge
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Thursday, June 14, 2012 11: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!)
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
