以下は、QryLogEventHisVビューからデータを抽出して、RED SysConを引き起こした式およびイベントの説明を取得する方法を示したSQL文の例です。
WITH RECURSIVE CausalAnalysis(EntryTS, EntryKind, EntryID, EntryName, Activity, ActivityId) AS ( SELECT EntryTS, EntryKind, EntryID, EntryName, Activity, ActivityId FROM DBC.QryLogEventHisV WHERE EntryKind = 'SYSCON' AND EntryName = 'RED' AND Activity = 'ACTIVE' UNION ALL SELECT Cause.EntryTS, Cause.EntryKind, Cause.EntryID, Cause.EntryName, Cause.Activity, Cause.ActivityId FROM CausalAnalysis Condition INNER JOIN DBC.QryLogEventHisV Cause ON Condition.EntryKind = Cause.ActivityId AND Condition.EntryID = Cause.ActivityId ) SELECT * FROM CausalAnalysis ORDER BY 1 DESC;