Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
ESQL/C GuideThe HCL OneDB™ ESQL/C Programmer's Manual explains how to use , the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
Dynamic SQL
Determine SQL statementsIf you do not know until run time what SQL statement to execute, you can dynamically determine that statement with the DESCRIBE statement and use a dynamic-management structure to hold any values that the statement sends to or receives from the database server.
The DESCRIBE statementThe DESCRIBE statement obtains information about database columns or expressions in a prepared statement.
Check for a WHERE clause

Check for a WHERE clause

When DESCRIBE analyzes a prepared DELETE or UPDATE statement, it indicates if the statement includes a WHERE clause, as follows:

It sets the sqlca.sqlwarn.sqlwarn0 and sqlca.sqlwarn.sqlwarn4 fields to W if the prepared statement was an UPDATE or DELETE without a WHERE clause.
It sets the SQLSTATE variable to a warning value of "01I07", which is specific to HCL OneDB™.

Your program can check for either of these conditions to determine the type of DELETE or UPDATE statement that was executed. If the DELETE or UPDATE does not contain a WHERE clause, the database server deletes or updates all rows in the table.