Re: Running a QRYDFN using STRQMQRY to pass the parameters

[a4g atl <a4ginatl2@xxxxxxxxx>]

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