Re: Edit a numeric column in IBM Query Manager - STRQM

Rather than using the expressions in the prompted mode query in QMQRY,
consider just using the SQL mode directly.

Unlike Query/400, QMQRY uses SQL.

In STRQM, use 10=Convert to SQL to convert a prompted query to an SQL mode.

Also, F19=Change query creation mode, you can change your default to SQL
mode.

Charles




On Tue, Dec 15, 2020 at 11:28 AM Michael Smith <msmith@xxxxxxxxxxxxxx>
wrote:

Vern,

Based on your suggestion; CPART will get me close enough for what I need
in this report.


Define Expressions


Type expression using field names, constants, and operators, press
Enter.
For full name and expression, press F4.

Valid operators are: +, -, *, /, CONCAT ...


Name Expression

APART SUBSTRING( DIGITS(PART),1,7)

BPART SUBSTRING( DIGITS(PART),8,2)

CPART APART CONCAT '-' CONCAT BPART


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Vernon Hamberg
Sent: Tuesday, December 15, 2020 1:13 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Edit a numeric column in IBM Query Manager - STRQM

*EXTERNAL EMAIL*

Hi Michael

I've done a fair amount playing/working with QM. I see where you get only
the codes.

Part of the trouble is, your part numbers are not really numbers used in
calculations. Edit words could get you what you want, of course.

I think what you do is use one of the SQL functions - digits() with
various subtringing can do it - i looked at varchar_format but did not see
how it could do it.

HTH
Vern

On 12/15/2020 9:44 AM, Michael Smith wrote:

I have very little experience with the IBM Query Manager(STRQM) product.

With that said;
I would like to use an edit word on a query form.

The path to the screen is STRQM>2. Work with Query Manager report
forms>Option 2 and select query form>Option 1 and select Edit column
formatting

Using F4 on the edit column only allows me to use/select an edit code.

Is there another screen, function key, or work around for editing the

part number?

I would like to use an edit word that produced a column of part numbers

formatted: "123456-78".

Edit Column Formatting

Type information, press Enter.
For Usage and Edit, press F4 for list.
For Heading, press F4 for prompt.

Column Heading Usage Edit Seq Indent

Width

1 DESC1 3 2
2 DESC2 3 2

50

3 PART J0 1 2
4 STATUS 2 2

Michael Smith

--
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://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=04%7C01%7Cmsmith%40jhfletcher.com%7Cf8c7dc7202f64d909cc308d8a1252113%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%7C637436528127138323%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=0QgA1Fjpw6%2F6g8yYvPwonhL9nqA0IJjj6vmKRxghmUU%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=04%7C01%7Cmsmith%40jhfletcher.com%7Cf8c7dc7202f64d909cc308d8a1252113%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%7C637436528127138323%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=NBkJjYFRumaAc5BAhqKrxCZNiozo7PuJK%2FAqB88ucLo%3D&amp;reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=04%7C01%7Cmsmith%40jhfletcher.com%7Cf8c7dc7202f64d909cc308d8a1252113%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%7C637436528127138323%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=ZZbWIkuBLMG0WcP6Uqz5aCo2vAU7VRcKoJNMQRHDPTc%3D&amp;reserved=0


** WARNING: This email originated from OUTSIDE of the organization. DO NOT
click links or open attachments unless you recognize the sender and know
the content is safe.
**

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