Checking for the Existence of a WHERE Clause

If the DESCRIBE statement detects that a prepared statement contains an UPDATE or DELETE statement without a WHERE clause, the DESCRIBE statement sets the sqlca.sqlwarn.sqlwarn4 variable to W.

When you do not specify a WHERE clause in either a DELETE or UPDATE statement, the database server performs the delete or update operation on the entire table. Check the sqlca.sqlwarn.sqlwarn4 variable to avoid unintended global changes to your table.