|
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.part number?
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
forms>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
formatted: "123456-78".
I would like to use an edit word that produced a column of part
numbers
Width
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
1 DESC1 3 250
2 DESC2 3 2
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%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=04%7C01%7Cms
mith%40jhfletcher.com%7C111007dcda1944038fea08d8a138b8ee%7C5566ca2ffb3
148048736d7a43eb4683e%7C0%7C0%7C637436612300459349%7CUnknown%7CTWFpbGZ
sb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3
D%7C1000&sdata=kIrJH716bkfKx3HvVBIKObxHtDtZXjIKw0dY99D7%2BwY%3D&am
p;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%2Farch
ive.midrange.com%2Fmidrange-l&data=04%7C01%7Cmsmith%40jhfletcher.c
om%7C111007dcda1944038fea08d8a138b8ee%7C5566ca2ffb3148048736d7a43eb468
3e%7C0%7C0%7C637436612300459349%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLj
AwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=
117gHqNJEB4j2M0dCwnA%2FgF%2FknljkJlSbUtln3h0K%2Fw%3D&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%2Famaz
on.midrange.com%2F&data=04%7C01%7Cmsmith%40jhfletcher.com%7C111007
dcda1944038fea08d8a138b8ee%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%
7C637436612300459349%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
joiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=n21OfTn2Ix2
z%2BZDQ9f6Hnfh9WOnjl%2BDRpjwFTXm4ws0%3D&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://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=04%7C01%7Cms
mith%40jhfletcher.com%7C111007dcda1944038fea08d8a138b8ee%7C5566ca2ffb3
148048736d7a43eb4683e%7C0%7C0%7C637436612300459349%7CUnknown%7CTWFpbGZ
sb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3
D%7C1000&sdata=kIrJH716bkfKx3HvVBIKObxHtDtZXjIKw0dY99D7%2BwY%3D&am
p;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&data=04%7C01%7Cmsmith%40jhfletcher.com%7C111007dcda1944038fea08d8a138b8ee%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%7C637436612300469344%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=keJ6vy%2FwyK2f60UbnrusQLSDp1EJHLZShN9BkE44qOI%3D&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%2Famaz
on.midrange.com%2F&data=04%7C01%7Cmsmith%40jhfletcher.com%7C111007
dcda1944038fea08d8a138b8ee%7C5566ca2ffb3148048736d7a43eb4683e%7C0%7C0%
7C637436612300469344%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
joiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=LiUJY6YjC5M
uKzQ3fSSjbsycP1qyjsQ8rHlBaJiT5zo%3D&reserved=0
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
