MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

Re: how to get text output of a PF?



fixed

Hotel,
if you are using Client Access for windows, there is a file transfer button on the tool bar.
open it, and place the LIBRARY/FILE(MEMBER) name in the IBMi File name window.
in the PC File name window, put in something like c:\MEMBER.txt

be sure to click on the properties icon, and have Convert CCSID 65535 checked...




On 7/10/2014 4:17 PM, Hoteltravelfundotcom wrote:
My mistake, it's a txt on the green side. The qsn is how to get this to a
windows text file without the seq numbers.


it has statements like this:
0016.00 Insert into
ISTLIB.CORCOEx(PROGR3PST)
140707
0017.00 SELECT count(*) FROM
ASTCCDTA.OEORH48,ASTCCDTA.TRNSTAT2,ASTCCDTA.OETRA99
000000
0018.00 WHERE OHCOM# = TSCOM# AND OHORD# =
TSORD# 000000
0019.00 AND (otCOM# = OHCOM# AND OTORD#= OHORD# AND ottrnc =
'AQC') 000000


On Thu, Jul 10, 2014 at 5:14 PM, Vernon Hamberg<vhamberg@xxxxxxxxxxxxxxx>
wrote:

PFs don't have stuff on the left - well, non-source types - are you
working with source members?

Do you have WDSC or RDi or RDp? You should be able to get what you want in
there.

If you are working on green only, you will probably want to do a query,
sql type or qrydfn type or otherwise, and select only the SRCDTA column.

That's all the guessing I can do right now, man!

Vern


On 7/10/2014 3:57 PM, Hoteltravelfundotcom wrote:

I have used the Iseries NAvigator to export the output after entering '6'
and print on the green screen IBM i.
but this has all the 'stuff' on the left side. i would like it to be a
clean text file.

WHat am i leaving out?


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