×
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.
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
midrange.com
