× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2020

Re: Leading minus sign in QMQRY result?

I do see a post in the archives where varchar_format is mentioned. Must be a fat-finger typo.

On 6/3/2020 6:09 AM, Rob Berendt wrote:
Who is Ben?
<snip>
Ben's suggestion about varchar_format sounds interesting
</snip>
I missed that reply. So I went and checked the archives also and I don't see that.
Was Ben's reply "offlist"? If not, and it went to the list, then not only did I miss it, it is not in the archives.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -----Original Message----- From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of petercdow@xxxxxxxxx Sent: Wednesday, June 3, 2020 2:09 AM To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx> Subject: Re: Leading minus sign in QMQRY result? CAUTION: 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. I missed the part about going to an outfile. Ben's suggestion about varchar_format sounds interesting - I haven't used that for numeric fields. Or the lengthier case when construct might do it.------ Original message------From: Roger HarmanDate: Tue, Jun 2, 2020 7:43 PMTo: Midrange Systems Technical Discussion;Cc: Subject:RE: Leading minus sign in QMQRY result?Even if it's just going to an outfile? Not sure how that would work. Outfile gets copied to CSV and emailed. I'll look at it in the morning. For most of these things, I just use SQL Workbench/J which has XLSX output. But, this is a scheduled daily job. -----Original Message----- From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Peter Dow Sent: Tuesday, June 02, 2020 4:45 PM To: midrange-l@xxxxxxxxxxxxxxxxxx Subject: Re: Leading minus sign in QMQRY result? Hi Roger, As I recall, you have to create a QM Report Form (STRQM option 2). That form will let you specify edit codes for numeric columns among other things. I think P is for leading minus. Then when you run the query, you specify the name of the form. -- *Peter Dow* / Dow Software Services, Inc. 909 793-9050 petercdow@xxxxxxxxx pdow@xxxxxxxxxxxxxx / On 6/2/2020 4:36 PM, Roger Harman wrote:
This shouldn't be baffling me as much as it is but it's been quite a day....

I have a QM Query object that I need to change to have a leading minus instead of trailing in a particular column. Is there an easy way to do this? It's escaping me at the moment.

V7R2

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power







--
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
athttps://archive.midrange.com/midrange-l.

Please contactsupport@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
athttps://archive.midrange.com/midrange-l.

Please contactsupport@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
athttps://archive.midrange.com/midrange-l.

Please contactsupport@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


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.