Utilice un nodo Trace para generar detalles de las excepciones que se producen cuando se detecta una excepción de base de datos.
La figura siguiente muestra 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 detectado una excepción de base de datos.
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)RecoverableException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbRdl\ImbRdlExternalDb.cpp'
(0x3000000)Line = 278
(0x3000000)Function = 'SqlExternalDbStmt::executeStmt'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = 'acd8f35d-e700-0000-0080-b78796c5e70d'
(0x3000000)Label = 'esql_13485_check_defect.Compute1'
(0x3000000)Text = 'Se ha producido el error siguiente al ejecutar la sentencia SQL &3. inserts where &4'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2519
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '1'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '1'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'USERDB'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'DELETE FROM DB2ADMIN.STOCK WHERE (STOCK_ID)=(?)'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = '500027, '
)
(0x1000000)DatabaseException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbOdbc.cpp'
(0x3000000)Line = 153
(0x3000000)Function = 'ImbOdbcHandle::checkRcInner'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Excepción SQL de raíz'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2321
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '100'
)
)
)
)
)