Hello,

I am getting error file reading the hold file since hold file had no records.
How to find the no records attribute for hold file so that it can skip the segment and continue to next.

Thanks,

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

The following method should work for you:

TABLE FILE MYFILE
{DO WHATEVER TO GET NO RECORDS}
ON TABLE HOLD AS HOLDFILE
END
-RUN
-IF &RECORDS EQ 0 THEN GOTO NoDataToShow ;
TABLE FILE HOLDFILE
{WHATEVER}
END
-GOTO TheEnd
-NoDataToShow
Display a message if you'd like...
-TheEnd

You can also use &LINES

THanks All for your responses.

It's worked fine used the &RECORDS.

Thanks !

I would suggest using &LINES, in particular if you use WHERE TOTAL.

TABLE FILE CAR
PRINT COUNTRY
WHERE TOTAL COUNTRY EQ 'USA'
ON TABLE HOLD
END
-RUN
-TYPE RECORDS = &RECORDS
-TYPE LINES   = &LINES

You will notice that &RECORDS = 5 and &LINES EQ 0.

Waz is correct,

you should use &LINES because &RECORDS is generated before the WHERE TOTAL is applied
and so it can quite easily return the incorrect value.

You're absolutly correct in using "&LINES" instead of "&RECORDS" when using a "WHERE TOTAL". I only took it as far as Viral asked in the original post.