I tried to match two file but it is showing decimal overflow error. Could you please let me know how to fix this issue?
MATCH FILE HLD1 SUM BASE_AMOUNT AS LDGR_BASE_AMOUNT
BY LEDGER
BY BUS_UNIT BY DEPT_NBR BY ACCOUNT BY SUB_DIV BY FISCAL_YEAR BY PERIOD RUN NUMBER OF RECORDS SELECTED= 1327628 LINES= 436796
FILE HLD2 SUM BASE_AMOUNT AS JRNL_BASE_AMOUNT
BY LEDGER BY BUS_UNIT BY DEPT_NBR BY ACCOUNT BY SUB_DIV BY FISCAL_YEAR BY PERIOD AFTER MATCH HOLD OLD-OR-NEW
END (FOC36207) DECIMAL OVERFLOW--FIELD SET TO MAXIMUM NUMBER OF RECORDS SELECTED= 7682816 LINES= 450118 LINES OF MATCH OUTPUT = 450118 OFFLINE... HOLDING...This message has been edited. Last edited by: Kerry,
Raghuraman K
February 14, 2013, 08:56 AM
Prarie
You asked this question the other day. What version are you on? You need to increase the size of your fields. This is what the error means.
During an aggregation (SUM), the result of an ADD DECIMAL instruction exceeded the capacity of the field. The magnitude of the field has been set to 99...99 (the sign is unchanged) and the corresponding count has been frozen
February 14, 2013, 09:58 AM
Raghuraman K
Hi,
Thank you. I am using verision 7.3. This is HOLD file then how to increase the field size.
Please let me know.
Raghuraman K
February 14, 2013, 11:54 AM
Francis Mariani
SET HOLDLIST=PRINTONLY
MATCH FILE CAR
SUM SALES/D20.2 AS 'AUTO_SALES'
BY CAR
RUN
FILE CAR
SUM SALES/D20.2 AS 'AUTO_SALES'
BY CAR
AFTER MATCH HOLD OLD-OR-NEW
END
TABLE FILE HOLD
PRINT *
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 14, 2013, 03:31 PM
Waz
Can you update your profile so we kn ow what version you are on.
7.3 sounds like it is FOCUS and not WebFOCUS.
FYI
in a fex you can issue ? nnnn where nnnn is the error number