Checking for Existence of a WHERE Clause

If the DESCRIBE INPUT statement detects that a prepared object contains an UPDATE or DELETE statement without a WHERE clause, the database server 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 action on the entire table. Check the sqlca.sqlwarn.sqlwarn4 variable after DESCRIBE INPUT executes to avoid unintended global changes to your table.