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]


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

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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


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