STOP

Syntax

STOP [QUIET]

Description

The STOP command halts SQR and executes a ROLLBACK command (not in Microsoft SQL Server). All report page buffers are flushed if they contain data; however, no headers or footers are printed and the AFTER-PAGE and AFTER-REPORT procedures are not executed.

STOP is useful in testing.

Parameters

Parameter	Description
QUIET	Causes the report to finish with the "SQR: End Of Run" message, instead of ending with an error message.

Example

The following example shows the STOP command:

if #error-status = 1
   rollback
   stop
else
   commit
   stop quiet
end-if