MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

RE: how to get text output of a PF?



fixed

Yes, 'order by' would have been a good idea.


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
CRPence
Sent: Friday, July 11, 2014 8:55 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: how to get text output of a PF?

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.






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