I just upgraded to 7.701. I am no longer getting multiple excel worksheets when I
include the 3 lines of FML Code.

I can change the routine to used "TOC" instead but I want to know why this is no longer working.

-*____________________________________________________________________________________
FILEDEF TGCNSYS2 DISK baseapp/TGCNSYS2.FTM
FILEDEF GCNGL DISK GCN_METADATA/GCNGL.FTM
-SET &IDX = 1;
-REPEAT LAB2 WHILE &IDX LE 2;
-SET &OUTPUT = IF &IDX EQ 1 THEN 'EXL2K OPEN' ELSE 'EXL2K CLOSE' ;
JOIN CLEAR *
JOIN
GCNGL.GCNGL.GL_ACCOUNT IN GCNGL TO MULTIPLE TGCNSYS2.TGCNSYS2.GL_ACCOUNT IN TGCNSYS2
AS J0
END
TABLE FILE GCNGL
SUM
AMOUNT
ACROSS LOB_GROUP
-***************************************************************
-* FML CODE
FOR
GL_ACCOUNT
'2000' GET CHILDREN ALL
-****************************************************************
ON TABLE PCHOLD FORMAT &OUTPUT
END
-SET &IDX = &IDX + 1;
-LAB2;
-*____________________________________________________________________________________

This message has been edited. Last edited by: Kerry,

Jammer,

This is the sort of question that would be best raised direct to IB Technical Support via Info Response and not the Forum.

T

Yes - I will open a case with Tech support.

As far as the code is concerned is there anything wrong or unusual?