I want to combine the output (flat file) of 2 TABLE FILEs. Thus, I’m doing the following:

TABLE FILE table1
WHERE filter
SUM fields
BY fields
ON TABLE SAVE FILENAME file.txt

MORE
FILE table2
WHERE fields
END

The above works fine. However, I want to make a slight change and use a DEFINE’d field instead of a real field in the SUM and BY. Thus, I put a DEFINE above the TABLE FILE and I used the DEFINEd field in the SUM and BY. That works fine if I just have one normal TABLE FILE. But if I want to use the DEFINEd field in the original, combined MORE, I get this error:

(FOC952) NO MATCH IS FOUND FOR THE FIELD OF MAIN REQUEST: REAL_NAME

If I put the DEFINE FILE above both the TABLE FILE table1 and the FILE table2, I get this error:

(FOC001) THE NAME OF THE FILE OR THE WORD 'FILE' IS MISSING

(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND
(FOC1517) UNRECOGNIZED COMMAND FILE FY2019
(FOC1517) UNRECOGNIZED COMMAND WHERE VENDOR_NO GE '1000000000'
(FOC1517) UNRECOGNIZED COMMAND AND AOBJ GE '0101'
(FOC1517) UNRECOGNIZED COMMAND AND AOBJ LE '0220';

Is there a way to combine output using MORE along with a DEFINEd field?

Thanks,
Mark

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

I think you need to create your defined field for both table1 and table2. Did you try Something like this :

DEFINE FILE table1
DEF1 =
END
DEFINE FILE table2
DEF1 =
END
Then your TABLE FILE with MORE

When using MORE, all combined files must have the same number of field, same field name/format/length
Sample

TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE SEATS EQ 2;
ON TABLE HOLD AS TBL1
END
-RUN

TABLE FILE CAR
PRINT RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE MODEL CONTAINS '2 DOOR';
ON TABLE HOLD AS TBL2
END
-RUN

DEFINE FILE TBL1
FLD /A10V = 'TABLE 1';
END
DEFINE FILE TBL2
FLD /A10V = 'TABLE 2';
END
TABLE FILE TBL1
PRINT RETAIL_COST
BY FLD
BY COUNTRY
BY CAR
BY MODEL
MORE
FILE TBL2
END
-RUN

Jean-Claude and Martin,

Thanks for both of your replies. I went with the first, and simpler one. I moved the 2nd DEFINE right under the first DEFINE and before the (first) TABLE FILE and it worked.

Thanks again.

Mark