SET NOEXEC (TSQL Statement)

parses and compiles the batch, but doesn’t execute it.

Syntax

SET NOEXEC { ON | OFF }

Remarks

A batch is processed by RSQL as follows:

• The parsing stage transforms the text of the batch into an AST tree.
• The compilation stage specifies the datatypes of the nodes of the AST tree, and creates an executable bytecode object.
• The execution stage executes the bytecode object.

When the option NOEXEC is ON, the batch is parsed and compiled, but not executed.

This way, you can check if the batch has no syntax error without executing it.