Each row in the SYSUSERMESSAGE system view holds a user-defined message for an error condition. The underlying system table for this view is ISYSUSERMESSAGE.


Previous versions of the catalog contained a SYSUSERMESSAGES system table. That table has been renamed to be ISYSUSERMESSAGE (without an 'S'), and is the underlying table for this view.

Column name Data type Description
error INTEGER A unique identifying number for the error condition.
uid UNSIGNED INT The user number that defined the message.
description VARCHAR(255) The message corresponding to the error condition.
langid SMALLINT Reserved.
 Constraints on underlying system table