Re: find command (QP2TERM) output to a table on the iSeries data conversion problem

I figured out how to get what I wanted, which was a recursive diretory listing of files only, and the output redirected to a table.
The solution follows:


OVRDBF FILE(STDOUT) TOFILE(SLLIB/FILELIST)
qsh cmd('find /ImageRight/Import/FUP/fupMonitor/backup -type f')


---- suncds@xxxxxxxxxxxxxxx wrote:

Hi Scott, thank you for your response. When I run the command, the output is not directed to the iSeries table. Rather, it diaplays this message in QSHELL, repetitively:

ls: 001-3015 usage: ls [-ACFLRSTacdfiloqrstu1] [file ...]

I'm a qshell newbie, from what I can gather is that the embedded "ls" command needs to be revised.


---- Scott Klement <midrange-l@xxxxxxxxxxxxxxxx> wrote:

Hi Stuart,

On 12/6/2012 7:29 PM, Stuart Leonard wrote:

The below command executes just fine. However, the data is being
written as ASCII instead of EBCDIC.

QP2TERM is PASE. Try running this in QShell (i.e. use the STRQSH
command instead of CALL QP2TERM)

PASE is an environment that will run programs written and compiled for
AIX. AIX does not have any notion of EBCDIC, so your data will always
output ASCII.

QShell on the other hand is a Unix-like environment that has been
implemented with native IBM i programs. As such, it works with CCSIDs,
and is able to output either ASCII or EBCDIC, and will translate as needed.

QShell is able to run both PASE and native programs (if you point QShell
at an AIX program, it'll invoke PASE under the covers). However, by
contrast, QP2TERM will only understand PASE programs. So it's much more
versatile in that respect. Though, I have run across a few situations
where you want things to be pure Unix, so QP2TERM works better -- but
these are not commonplace.

Also STRQSH is much more versatile for use from within a CL program.

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