Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
WHENEVER statementUse the WHENEVER statement to trap exceptions that occur during the execution of SQL statements. The WHENEVER statement is equivalent to placing an exception-checking routine after every SQL statement.
SQLWARNING Keyword

SQLWARNING Keyword

If you use the SQLWARNING keyword, any SQL statement that generates a warning is handled as the WHENEVER SQLWARNING statement directs. If a warning occurs, the first field (sqlca.sqlwarn.sqlwarn0) of the warning structure in SQLCA is set to W, and the SQLSTATE variable is set to a class code of 01.

Besides the first field of the warning structure, a warning also sets an additional field to W. The field that is set indicates what type of warning occurred.

The next statement causes execution to stop if a warning condition exists:

WHENEVER SQLWARNING STOP

If you do not use any WHENEVER SQLWARNING statements in a program, the default action for WHENEVER SQLWARNING is CONTINUE.