I believe: Query derived calculation is from (example): fieldA (size 17)
times fieldB (size20) equals fieldC (greater than size 31)
Try reducing the size of fieldA and fieldB
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
Sent: Tuesday, January 31, 2023 4:24 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [External] Re: Running a QRYDFN using STRQMQRY to pass the
[WARNING]: External Email
This is the message I get.
Message . . . . : Reduction of total digits not allowed for operator
Cause . . . . . : The derived calculation involving operator X'07'
more than 31 total digits, but the reduction of total digits is not
for this query request. The derivation is in derived item number 21 for
derived field SEL0017 in query format FORMAT0001. Operand number one
*N. Operand number two is *N. If an operand is *N, either the operand
result of previously derived operations or the operator does not
I have no idea why it needs more than 31 digits.
- What is the maximum number of digits allowed?
- How do I work out what field SEL0017 is?
- What is item number 21?
On Tue, Jan 31, 2023 at 5:14 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:
I did run ANZQRY and there are no errors.--
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.