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

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