MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

Re: how to get text output of a PF?



fixed

Thanks I used the great idea from Mathesun the Iseries transfer this will
be fine for us, good job.


On Fri, Jul 11, 2014 at 8:54 AM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 11-Jul-2014 05:02 -0500, paultherrien wrote:

<<SNIP>> it sounds like your are printing the contents from a

member of a source physical file.
But all of that would be an assumption.

But if that is the case then you MAY want to use SQL:

[run the SQL interactive program]

STRSQL

[Create an alias to point to the member you are trying to print]
CREATE ALIAS library/aliasname FOR library/file (member)

[Change SQL session to print the results of your SQL commands]

F13
Option 1. Change session attributes
Select Output: 2=Printer

[Then run this SQL Statement]
SELECT srcdta FROM library/aliasname

You will now have a spool file of your source member with no 'stuff'
except your source code. <<SNIP>>


However, having failed to specify an ORDER BY, the "source code" may not
appear in the desired [physical] sequence. The Reorganize Physical File
Member (RGZPFM) enables an option to effect updates to the Source Sequence
(typically named SRCSEQ) column data, to ensure that column can be utilized
for a collation that reflects the physical order.

--
Regards, Chuck

--
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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact