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.