Parameter not working fine.
In "admin_db2_warehouse.xml", for the queryid "WWCAL14", we need to change the database name as highlighted below: SELECT (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ?) - (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ? ) AS MONTH_DIFF FROM ARC_DWH.SYSTABLES WITH UR Instead of SELECT (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ?) - (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ? ) AS MONTH_DIFF FROM SYSIBM.SYSTABLES WITH UR