× 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 did already try to reduce the size of the fields. That did not help.
Maybe I don't know what its field SEL0017 is. I am guessing and that does
not help.
Darryl

On Tue, Jan 31, 2023 at 5:38 PM Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

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

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g
atl
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
parameters

[WARNING]: External Email

This is the message I get.

Message . . . . : Reduction of total digits not allowed for operator
X'07'.

Cause . . . . . : The derived calculation involving operator X'07'
requires

more than 31 total digits, but the reduction of total digits is not
allowed

for this query request. The derivation is in derived item number 21 for

derived field SEL0017 in query format FORMAT0001. Operand number one
is

*N. Operand number two is *N. If an operand is *N, either the operand
is the

result of previously derived operations or the operator does not
require two
operands.


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?

Thanks, Darryl.

On Tue, Jan 31, 2023 at 5:14 PM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I did run ANZQRY and there are no errors.
Darryl


--
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.



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.