When using the MODIFY statement in an application, the DBMS Server returns the number of rows modified in the SQLCA's sqlerrd(3) field. If the statement does not modify any rows, the DBMS Server sets the SQLCA's sqlcode to 100.

The preprocessor does not verify the syntax of the with_clause. The values in the with_clause options can be specified using host language variables. Any other parameters cannot be specified using host language variables.