Utilice un nodo Trace para generar detalles de las excepciones que se producen cuando se generan excepciones de usuario.
El ejemplo siguiente es un extracto de la salida que puede generar un nodo Trace que tiene la propiedad Patrón establecida en un valor que representa una estructura que incluye el árbol de lista de excepciones.
Se muestra una excepción que se ha producido cuando se ha generado una excepción de usuario (con la sentencia ESQL THROW).
ExceptionList = (
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbComputeNode.cpp'
(0x3000000)Line = 402
(0x3000000)Function = 'ImbComputeNode::evaluate'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = 'acd8f35d-e700-0000-0080-b78796c5e70d'
(0x3000000)Label = 'esql_13485_check_defect.Compute1'
(0x3000000)Text = 'Se capta la excepción y vuelve a generarse'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)UserException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbRdl\ImbRdlThrowExceptionStatements.cpp'
(0x3000000)Line = 148
(0x3000000)Function = 'SqlThrowExceptionStatement::execute'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = 'acd8f35d-e700-0000-0080-b78796c5e70d'
(0x3000000)Label = 'esql_13485_check_defect.Compute1'
(0x3000000)Text = 'Excepción SQL generada por el usuario 'USER''
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 1
(0x3000000)Number = 2949
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'USER'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Insert1'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'Insert2'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'etc'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = ''
)
)
)
)