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

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