Here is my code and below is the error generated I am at a loss as to why i am getting the error does my hold file get consumed when read? I have tried renumbering the joins and leaving the join out on the second pass thru the hold file 45CY

Please help if you can


-INCLUDE IBFS:/WFC/Repository/University_Advancement/~gpfish/BOT/AutoYR_DT1.fex
SET ASNAMES = ON
-* CURRENT YEAR VS PREVIOUS YEAR SAME DATE
DEFINE FILE AWVFRG1
GROUP_ORDER/D12.2=5;
GROUP_NAME/A50='DONOR RETENTION(made gift this FY and last FY)';
ROWNM/D12.2=45;
SUBNAME/A50='Donors who Upgraded';
END
TABLE FILE AWVFRG1
SUM
COMPUTE CURR/D20.2 = AWVFRG1.AWVFRG1.AGRGDES_AMT;
BY LOWEST AWVFRG1.AWVFRG1.AGBGIFT_PIDM
BY LOWEST GROUP_ORDER
BY LOWEST GROUP_NAME
BY LOWEST ROWNM
BY LOWEST SUBNAME
WHERE ( AWVFRG1.AWVFRG1.AGBGIFT_FISC_CODE EQ '&FISCYRX' ) AND ( AWVFRG1.AWVFRG1.AGRGDES_AMT LT 15000 );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HR45CY
END
DEFINE FILE AWVFRG1
GROUP_ORDER/D12.2=5;
GROUP_NAME/A50='DONOR RETENTION(made gift this FY and last FY)';
ROWNM/D12.2=45;
SUBNAME/A50='Donors who Upgraded';
END


TABLE FILE AWVFRG1
SUM
COMPUTE PREV/D20.2 = AWVFRG1.AWVFRG1.AGRGDES_AMT;
BY LOWEST AWVFRG1.AWVFRG1.AGBGIFT_PIDM
BY LOWEST GROUP_ORDER
BY LOWEST GROUP_NAME
BY LOWEST ROWNM
BY LOWEST SUBNAME
WHERE ( AWVFRG1.AWVFRG1.AGBGIFT_FISC_CODE EQ '&FISPYRX' ) AND ( AWVFRG1.AWVFRG1.AGRGDES_AMT LT 15000 ) AND ( AWVFRG1.AWVFRG1.AGBGIFT_GIFT_DATE LE '&DATE2X' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HR45PY
END


-* UPGRADED CURRENT YEAR VS PREVIOUS YEAR
JOIN
HR45CY.HR45CY.AGBGIFT_PIDM IN HR45CY TO MULTIPLE HR45PY.HR45PY.AGBGIFT_PIDM
IN HR45PY TAG J0 AS J0
END
TABLE FILE HR45CY
SUM
CNT.DST.HR45CY.HR45CY.AGBGIFT_PIDM AS 'COUNT,DISTINCT,HR45CY.HR45CY.AGBGIFT_PIDM'
WHERE HR45CY.HR45CY.CURR GT J0.HR45PY.PREV;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HR45CY
END


-*- DOWNGRADED CURRENT YEAR VS PREVIOUS YEAR
-*JOIN
-*HR45CY.HR45CY.AGBGIFT_PIDM IN HR45CY TO MULTIPLE HR45PY.HR45PY.AGBGIFT_PIDM
-*IN HR45PY TAG J1 AS J1
-*END
TABLE FILE HR45CY
SUM
CNT.DST.HR45CY.HR45CY.AGBGIFT_PIDM AS 'COUNT,DISTINCT,HR45CY.HR45CY.AGBGIFT_PIDM'
WHERE HR45CY.HR45CY.CURR LT J0.HR45PY.PREV;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HR46CY
END


-* SAME CURRENT YEAR VS PREVIOUS YEAR
JOIN
HR45CY.HR45CY.AGBGIFT_PIDM IN HR45CY TO MULTIPLE HR45PY.HR45PY.AGBGIFT_PIDM
IN HR45PY TAG J0 AS J0
END
TABLE FILE HR45CY
SUM
CNT.DST.HR45CY.HR45CY.AGBGIFT_PIDM AS 'COUNT,DISTINCT,HR45CY.HR45CY.AGBGIFT_PIDM'
WHERE HR45CY.HR45CY.CURR EQ J0.HR45PY.PREV;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS HR47CY
END



0 ERROR AT OR NEAR LINE 73 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: HR45CY.HR45CY.CURR
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
0 ERROR AT OR NEAR LINE 88 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: HR45CY.HR45CY.CURR
BYPASSING TO END OF COMMAND

This message has been edited. Last edited by: Geoff Fish,

LESSON LEARNED MAKE SURE YOUR HOLD FILES HAVE UNIQUE NAMES. I WAS RE USING THE SAME FILE NAME IN 2 PLACES

Agreed, reusing hold files is fraught with danger