Yes, 'order by' would have been a good idea.
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Sent: Friday, July 11, 2014 8:55 AM
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]
[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]
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.