Re: Retrieving individual records from a journal

Thanks

Adam Driver

Chicago, IL

T: 847-916-9499

M: 224-250-9049

www.linkedin.com/adamdriver<http://www.linkedin.com/adamdriver>

[Description: http://www.quinnox.com/images/email-sig/quinnox-branding-logo.png]
[Description: http://www.quinnox.com/images/email-sig/facebook_icon.png]<https://www.facebook.com/QuinnoxInc>

[Description: http://www.quinnox.com/images/email-sig/Twitter_icon.png]<https://twitter.com/QuinnoxInc>

[Description: http://www.quinnox.com/images/email-sig/linkedin_icon.png]<http://www.linkedin.com/company/quinnox>


www.quinnox.com<http://www.quinnox.com/>






date: Tue, 10 Feb 2015 14:00:47 -0600

from: CRPence <CRPbottle@xxxxxxxxx<mailto:CRPbottle@xxxxxxxxx>>

subject: Re: Retrieving individual records from a journal



The CL program does not have a direct ability to insert the retrieved data, so using the Retrieve Journal Entry (RTVJRNE) as a front-end for that purpose is probably a poor choice. Use of the command vs an API also has many limitations that may not be able to be overcome if not using the Retrieve Journal Entries (QjoRetrieveJournalEntries) API to retrieve the entries; the Return Variable For The Journal Entry for example is limited to a binary-character CL variable data type of the maximum (?9999?) length and no support for the data types that require pointers to access the data.



If the journal entries are on the remote system, then the Display Journal (DSPJRN) command supports an Output (OUTPUT) parameter specification of *OUTFILE to request directing the entries to a named Output File (OUTFILE) using a specified Output File Format (OUTFILFMT) similar to the Entry Format (ENTFMT) specification of the RTVJRNE command to define the layout of the Entry Data.



Once the data exists as rows in a file of the journal entry output, that data can be copied\inserted into the target file. The /copy/ is not direct and simple, minimally there are the extra columns but there is also the issue with the null indicator and specifications of how to expose those. There are some tools [talked about in the archives] that can help to effect the copy more directly, but depending on the [complexity of the layout of and the data itself in the] individual scenario and if the request is a /one-off/ vs something that must be done periodically, the specific steps to achieve the desired results could probably be explained in scripted actions for a particular setup\scenario.



--

Regards, Chuck









________________________________

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute, print or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. Any views or opinions presented in this email are solely those of the author and do not necessarily represent the views of the company. Although the company has taken reasonable precautions to ensure no viruses are present in this email, the company cannot accept responsibility for any loss or damage arising from the use of this email or attachments.