RE: Leading minus sign in QMQRY result?

[Roger Harman <roger.harman@xxxxxxxxxxx>]

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 <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto: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
>
>
>
>
>   
>