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.

The systracemsgs table describes each globalized trace message.


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.

The trace-message text can be a string of text in the appropriate language and code set for the locale, and can contain tokens to indicate where to substitute a piece of text. Token names are delimited between percent (%) symbols. The following INSERT statement puts a new message called qp1_exit in the systracemsgs table:

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.

This second message is the French version of the qp1_exit message and therefore the systracemsgs row specifies a French locale on a UNIX™ system (fr_fr.8859-1):

INSERT INTO informix.systracemsgs(name, locale, message)
VALUES ('qp1_exit', 'fr_fr.8859-1',
   'Le numéro de message en sortie était  \
   l'entrée est toujours %i%')

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.