IBM Tivoli Netcool/OMNIbus, Version 7.4

Verifying your SQL syntax (CHECK STATEMENT command)

The CHECK STATEMENT command parses and checks the syntax of the SQL commands enclosed in quotation marks and returns either a success message or a description of any errors.

Syntax

CHECK STATEMENT 'command; command; ...';

Because the CHECK STATEMENT command does not run the SQL commands, runtime errors are not detected. Additionally, some spurious errors may be displayed if there is a series of commands that relies on the preceding commands being run.