RE: how to get text output of a PF?

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.