I am using format 'DFIX DELIMITER |' and when no records are returned, I need the output file to be empty but it always has one line with '| | | |0|0|' in it. Is it possible to force the file to be empty? Thanks.

APP HOLD FOLDERNAME
TABLE FILE CAR
PRINT *
WHERE COUNTRY EQ 'SDFDF'
ON TABLE HOLD AS EMPTYREPORTTEST FORMAT DFIX DELIMITER |
END

This message has been edited. Last edited by: <Kathryn Henning>,

Hi,

Try this ---> ON TABLE SET EMPTYREPORT ON

Here is an example that created an empty file for me.

-*
FILEDEF HOLDCAR DISK holdcar.txt
-*
TABLE FILE CAR
PRINT
SEATS
BY COUNTRY
BY CAR
BY MODEL
WHERE COUNTRY EQ 'SDFDF'
ON TABLE SET EMPTYREPORT ON
ON TABLE HOLD AS HOLDCAR FORMAT DFIX DELIMITER |
END
-RUN

Hope this helps.