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.
NOT FOUND Keywords

NOT FOUND Keywords

If you use the NOT FOUND keywords, exception handling for SELECT and FETCH statements (including implicit SELECT and FETCH statements in FOREACH and UNLOAD statements) is treated differently from other SQL statements. The NOT FOUND keyword checks for the following cases:

The End of Data condition: a FETCH statement that attempts to get a row beyond the first or last row in the active set
The Not Found condition: a SELECT statement that returns no rows

In each case, the sqlcode variable is set to 100, and the SQLSTATE variable has a class code of 02. For the name of the sqlcode variable in each HCL® OneDB® product, see the table in SQLERROR Keyword.

The following statement calls the no_rows( ) function each time the NOT FOUND condition exists:

WHENEVER NOT FOUND CALL no_rows

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