RE: Query/400 vs QM Query vs Db2 Web Query and text wrapping -- MIDRANGE-L

For wrapping in a column, we just format each piece to the necessary length. We've produced some pretty nice reports. The biggest challenge is if a break needs to be one of the concatenated fields--that requires the formatting and concatenation to match in the select clause and the group by clause.

Michael Quigley
Computer Services
The Way international
www.TheWay.org

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf
Of Vernon Hamberg
Sent: Friday, July 24, 2020 10:28 PM
To: Midrange Systems Technical Discussion <midrange-
l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Query/400 vs QM Query vs Db2 Web Query and text wrapping

Hi Peter

I really like QM's ability to wrap text within a column - 2 variants, one breaks
at words, the other at the column width.

You know, maybe you can control what's in each line by using x'41', which is
a non-breaking space - pad each value to the column width - crazy idea,
right?

Vern

On 7/24/2020 7:08 PM, Peter Dow wrote:

Thanks Vern.

Re "at least you don't have an AS/400, right? " -- the users think
they do :)

Query for i has a line wrap option on the print options that makes it
possible.

QM query has the ability to do something similar for a single column
using edit code CW. I'm trying the idea of concatenating all the
fields into one giant field, then using the CW edit code on it. It
was looking promising until I ran into a problem with VARCHAR_FORMAT
and DDM files -- see my new email thread.

I'll give ANZQMRY (or is it ANZQMQRY?) tomorrow.

Peter

On 7/24/2020 4:50 PM, Vernon Hamberg wrote:

Hi Peter

I don't have all your answers, maybe a couple.

Query for i is Query/400 - at least you don't have an AS/400, right?

QM and Query for i do have their differences, of course. I'd forgot,
I think, of the layout you describe. As I recall, there's nothing
like that QM can do. Now was that on several pages, or was it only on
a cover page?

OTOH, I have liked how QM will print to multiple kind-of parallel
SPLFs if the output record is wider than the PRTF width. Query tended
to truncate - or is the a fold setting in the print settings?

It would be interesting and maybe instructive to use ANZQMRY on the
Query for i QRYDFN that has this layout and see what you get in the
job log - there will probably be messages about the things QM can't do.

Interesting stuff!

Vern

On 7/24/2020 4:00 PM, Peter Dow wrote:

When I started to write this email, I realized I'm not sure of the
current naming for IBM i's query products.

Near as I can tell Query/400 refers to WRKQRY, RUNQRY, etc., QM
Query refers to STRQM, STRQMQRY, etc. and I have no experience with
Db2 Web query.

On a 7.3 IBM i, under installed licensed software, I see 5770QU1 IBM
Query for i. I don't know what this includes.

My real question involves a difference in how Query/400 queries and
QM queries format their reports.

In Query/400, it is possible for one selected record to print on
multiple lines on the same page. For example, if a record contains
a name, address lines, city, state, zip and phone#, it is possible
for the query to print

Name
Address Line1
Address Line2
City, State Zip
800-555-1212

all on the same page in a single spool file.

Trying to do the same in QM query results in multiple spool files.
Reading the Query Management Programming manual (SC41-5703),

when

working on column formatting, the edit codes for a character column
include CW says

"Makes no change in the display of a value, but if the value cannot
fit on one line in the column, query management wraps the text
according to the width of the column. That is, instead of truncating
the data at the end of the column, query management puts as much
data as possible on one line in the column and then continues the
data on the next line in the column."

Not exactly the same thing, but close. To do the same thing as
Query/400, I would have to concatenate all the fields into one, then
use the CW edit code. That means I lose a lot of ability to format
individual fields.

What I would like is a way within QM Query to wrap a record at the
page width, but keep the additional lines within the same spool file.

Has anyone else run into this and found a solution?

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>

pdow@xxxxxxxxxxxxxx

<mailto:pdow@xxxxxxxxxxxxxx> /
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-

L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com