NODISPLAY

This batch SQL command suppresses the query Result window. When NODISPLAY is in effect, query results are not displayed on the Result window.

The syntax is:

NODISPLAY;

The NODISPLAY command must be placed immediately after the query statement on which you want it to take effect.

For example:

SELECT pno, pname FROM part WHERE color='BLUE';
NODISPLAY;

In this example, the results of the SELECT statement will not be displayed.

Once a NODISPLAY command is executed, it will remain in effect for the rest of the script, or until a DISPLAY command is encountered. Together, the DISPLAY and NODISPLAY commands can be used to selectively display or suppress the Result windows at certain points in the batch file.

For example:

SELECT * FROM customer 
WHERE state="CA";
NODISPLAY;            --Suppress Result Screen
IF FAIL EXIT;
UPDATE customer SET balance = balance - $50
WHERE state="CA";
SELECT customer.*, orders.o_no, orders.o_date
FROM customer, orders
WHERE state = "CA";
DISPLAY;            --Display Result Screen

This example suppresses the Result screen of the first query and displays it for the second.