asked on

Data mapping error on member QSQPTABL - UDTF error

Hi , my UDTF sometimes gives me this error:

Data mapping error on member QSQPTABL.
Data mapping error on member QSQPTABL.
Data conversion or data mapping error.
User-defined function error on member ORDERS.
Data mapping error on member QSQPTABL.
Data mapping error on member QSQPTABL.
Data mapping error on member QSQPTABL.
Data conversion or data mapping error.
User-defined function error on member ORDERS

When F1 on 'User-defined function error on member ORDERS' the error code is 1

1 -- The external program or service program returned SQLSTATE 22003. The
text message returned from the program is: SQLP_L2.ORDVAL

ASKER CERTIFIED SOLUTION

Gary Patterson, CISSP

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

iskibinska

ASKER

Thanks,

The problem was I was using the expession:
SET ORDVAL = ((PRODPRC*PRDQTY)-((PRODPRC*PRDQTY)*(DSCPRC/100)

when i broke it to smaller pieces
SET ORDVAL = TOTPRC - DISC*TOTPRC;

it started to work, strange

the definitions were as follows:

PRODPRC DECIMAL(7,2),
DSCPRC DECIMAL(5,2),
PRDQTY DECIMAL(7,0)
DECLARE ORDVAL DECIMAL(11,2);
DECLARE WRKPP DECIMAL(11,2);
DECLARE TOTPRC DECIMAL(11,2);
DECLARE DISC DECIMAL(5,2);