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™.
DELETE statementUse the DELETE statement to delete one or more rows from a table, or to delete one or more elements from a collection variable of SPL or of .
SQLSTATE Values in a Database That Is Not ANSI-Compliant

SQLSTATE Values in a Database That Is Not ANSI-Compliant

In a database that is not ANSI compliant, the database server does not return a warning when it finds no rows satisfying the WHERE clause of a DELETE statement. In this case, the SQLSTATE code is 00000 and the SQLCODE code is zero (0). If the DELETE . . . WHERE is part of a multistatement prepared object, however, and no rows are returned, the database server does issue a warning. It sets SQLSTATE to 02000 and sets the SQLCODE value to 100.

For information on the ANSI/ISO-compliance status of values returned to the SQLSTATE variable, see the section SQLSTATE Support for the ANSI/ISO Standard for SQL.