Toad World® Forums

Toad for DB2 LUW v6.1.0.51 - Toad Crashed after Clicking Explain Toolbar Icon

Highlighted the following SQL in an editor and clicked on the Explain toolbar icon.

SELECT *
FROM DMA01.DLY_FPS_DATA_CREDIT AS FP
LEFT JOIN DMA01.DLY_AIF_DATA_CREDIT AS AIF
ON FP.ALTRT_SEQUENCE_12_NR = AIF.ALTRT_SEQUENCE_12_NR
AND FP.HUB_CD = AIF.HUB_CD
AND FP.CYCLE_DT = AIF.CYCLE_DT
AND FP.SEQUENCE_12_NR = AIF.SEQUENCE_12_NR
WHERE FP.CYCLE_DT = ‘05-01-2015’;

Hi Richard,

Thank you for bug report, the issue has already been fixed and will be included in next beta drop.

Zdenek