Globalized exception messages
The DataBlade® API function mi_db_error_raise() sends an exception message to an exception callback.
This message can be either of the following:
- A literal message, which you provide as the third argument to mi_db_error_raise()
- A customized message that is associated with a value
of SQLSTATE, which you provide as the third argument
to mi_db_error_raise()
The mi_db_error_raise() function can raise exceptions with customized messages, which DataBlade modules and UDRs can store in the syserrors system catalog table. The syserrors table maps these messages to five-character SQLSTATE values. In the syserrors table, you can associate a locale with the text of a customized message.
For general information about how to specify a literal message in mi_db_error_raise() and how to specify a customized message for mi_db_error_raise(), see the topics on how to handle exceptions and events in the HCL OneDB™ DataBlade API Programmer's Guide.
This section describes the following tasks about how to raise locale-specific
exception messages:
- How to add a locale-specific exception message to the syserrors system catalog table
- How the choice of locale in a customized message affects the way that mi_db_error_raise() searches for a customized message
- How to specify parameter markers that contain non-ASCII characters