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.
Parent topic: EXECUTE statement
Copyright© 2021 HCL Technologies Limited