Hi there,
How can I check if the result of a IBI.FIL is null?

I want to make this test because if the returned value is null I want to send a "message" like "No data returned".

Thanks in advanced,
Carlos Dias

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

You mean to check if the file used in the IBI.FIL command is empty?
If so, you may want to check OS commands to see if the OS has something that can do that for you (for instance unix has something called 'test -f'). Otherwise you could try to use DM to do a -READ from the file. If return code indicates a record has been read, the file is not empty.

If you are creating the file in WebFOCUS, then use &LINES after the TABLE Request.

Waz has it. Immediately after you create the hold file, examine (or capture) the value in &LINES and make your decision based on that. At the end of your focexec you can use the logic:

-IF &LINES EQ 0 THEN GOTO EMPTYRPT

If you are creating the file in WebFOCUS then Waz is obviously correct.
However !IBI.FIL. can also be used to serve up static content that has been filedef'd
in which case GamP is correct.