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

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.