FWiW, comments inline.

Regards, Chuck

Vern Hamberg wrote:
<<SNIP>> The output from interactive SQL and from Query/400|iSeries|i always truncate the output.

Query/400 enables a /line wrap/ feature if\when requested for spooled\printed reports. The option is available only in the *QRYDFN, not from RUNQRY [e.g. as for some of the other print\spool report writer options].

I think the prtf name is QPQXPRTF - its default width is 80 characters. Note that QPQUPRFIL, the prtf for interactive SQL
and Query, has a default width of 132. I just noticed that the
replacement character for unprintable is different from one to
the other of these prtfs - interesting.

Query/400 does not prevent binary data from going directly to the spool\printer [nor display where it will reactively rewrite the display if\when bad data is diagnosed by the workstation controller at the device]. The design assumption was that any binary data spooled would be accidental, and the default RPLUNPRT(*YES x'40') was chosen to handle such cases. The QMQRY feature may /translate/ binary data [possibly as a feature of the UIM] before writing to the printer file, so the replace unprintable would then be redundant; presumably why its printer file uses RPLUNPRT(*NO).


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].