Insert messages in the systracemsgs system catalog table
The systracemsgs system catalog table stores globalized trace messages that you can use to debug your C UDRs.
To create a globalized trace message, insert a row directly into the systracemsgs table.
Column name | Description |
---|---|
name | The name of the trace message |
locale | The locale with which the trace message is to be used |
message | The text of the trace message |
The combination of message name and locale must be unique within the table. Once you insert a new trace class into systracemsgs, the database server assigns it a unique identifier, called a trace-message identifier. It stores the trace-class identifier in the msgid column of systracemsgs. Once a trace message exists in the systracemsgs table, you can specify the message either by name or by trace-message identifier to API tracing functions.
INSERT INTO informix.systracemsgs(name, locale, message)
VALUES ('qp1_exit', 'en_us.8859-1',
'Exiting msg number was the input is still %i%')
This message text is in English and therefore the systracemsgs row specifies the default locale of U.S. English.
Enter message text in the language of the server locale, with any characters available in the server code set. To insert a variable, enclose the variable name with a single percent sign on each end (for example, %a%). When the database server prepares the trace message for output, it replaces each variable with its actual value.