SYS_ROUTINE_ERRORS

Information on the the most recent events which were errored or suspected of being errored when routines (procedures and UDFs) were executed. The DEBUG ROUTINE pragma can also result in additional information being logged.

Column name	Data type	Contents
SPECIFIC_CATALOG	CHAR(18)	Name of the database to which the routine belongs
SPECIFIC_SCHEMA	CHAR(31)	Name of the schema to which the routine belongs
SPECIFIC_NAME	CHAR(31)	Specific name of the routine
START_TIME	TIMESTAMP(3)	Start time of the routine
ERROR_TIME	TIMESTAMP(3)	Time the error event occurred
ERROR_STATE	CHAR(5)	SQLSTATE, if an exception condition occurred Blank, otherwise
ERROR_TEXT	VARCHAR(256)	Message text
LINE_NUMBER	INTEGER	Line number of the errored statement in the text of the routine 0 if the place could not be determined
COLUMN_NUMBER	INTEGER	Column number of the errored statement in the text of the routine 0 if the place could not be determined
HOST_NAME	CHAR(8)	Host name from the identification of the requesting user
APPLICATION_NAME	CHAR(8)	Application name from the identification of the requesting user
CUSTOMER_NAME	CHAR(8)	Name of the requesting user from the identification of the requesting user
CONVERSATION_ID	CHAR(8)	Identification of the requesting user with respect to UTM and SESAM-DBAccess
TAC_NAME	CHAR(8)	Job name of the user ID or name of the program unit which called the routine
MODULE_NAME	CHAR(8)	Name of the compilation unit in which the routine was called
STATEMENT_NAME	VARCHAR(18)	Internal name of the SQL statement which called the routine

Table 125: SYS_ROUTINE_ERRORS view of the SYS_INFO_SCHEMA