The sqlca Record and EXECUTE

After an EXECUTE statement, the sqlca can reflect two results:

• The sqlca can reflect an error within the EXECUTE statement.

  For example, when an UPDATE ...WHERE statement in a prepared statement processes zero rows, the database server sets sqlca to 100.

• The sqlca can reflect the success or failure of the executed statement.