MQT AUTOMATIC SUMMARY TABLES

[cristi22]

Hello All -

Thanks a lot for your help!!!

I created an MQT & I can't access it
I runstats & set integrety on it

MESSAGE:

SQL0668N Operation not allowed for reason code "1" on table
"BASYS.L522_GROUP". SQLSTATE=57016
[red]
SQL0668N Operation not allowed for reason code "1" on table "BASYS.L522_GROUP
Explanation:

1 The table is in Check Pending state. The integrity of the table is not enforced and the content of the table may be invalid. An operation on a parent table or an underlying table that is not in a check pending state may also receive this error if a dependent table is in a check pending state.
[/red]

CREATE TABLE L522_GROUP AS 
(
	SELECT 
	 MEMBER_WORK_PERIOD.MEMBER_KEY 
	, MEMBER_WORK_PERIOD.EMPLOYER_NO
	
	, SUM ( CASE WHEN MEMBER_WORK_PERIOD.WORK_PERIOD IN ( '200407','200408','200409') THEN MEMBER_WORK_PERIOD_FUND.QUANTITY END ) AS Q3_2004
	, SUM ( CASE WHEN MEMBER_WORK_PERIOD.WORK_PERIOD IN ( '200410','200411','200412') THEN MEMBER_WORK_PERIOD_FUND.QUANTITY END ) AS Q4_2004
	, SUM ( CASE WHEN MEMBER_WORK_PERIOD.WORK_PERIOD IN ( '200501','200502','200503') THEN MEMBER_WORK_PERIOD_FUND.QUANTITY END ) AS Q1_2005
	, SUM ( CASE WHEN MEMBER_WORK_PERIOD.WORK_PERIOD IN ( '200504','200505','200506') THEN MEMBER_WORK_PERIOD_FUND.QUANTITY END ) AS Q2_2005
	, MEMBER_WORK_PERIOD_FUND.APP      
	, MEMBER_WORK_PERIOD_FUND.FUND   


FROM   
	MEMBER_WORK_PERIOD_FUND, MEMBER_WORK_PERIOD
WHERE
	MEMBER_WORK_PERIOD_FUND.MVPOS=MEMBER_WORK_PERIOD.MVPOS  
		AND MEMBER_WORK_PERIOD.MEMBER_KEY=MEMBER_WORK_PERIOD_FUND.MEMBER_KEY AND  FUND='L522P' AND APP='HW'  

	 AND DATE(SUBSTR(MEMBER_WORK_PERIOD.WORK_PERIOD,1,4)|| '-'|| 
        	 SUBSTR(MEMBER_WORK_PERIOD.WORK_PERIOD,5,2)|| '-01') < DATE('2005-07-01') 

	AND DATE(SUBSTR(MEMBER_WORK_PERIOD.WORK_PERIOD,1,4)|| '-'|| 
        	 SUBSTR(MEMBER_WORK_PERIOD.WORK_PERIOD,5,2)|| '-01') > DATE('2004-06-01')
	-- AND MEMBER_WORK_PERIOD.MEMBER_KEY='010365411'
GROUP BY
	MEMBER_WORK_PERIOD.EMPLOYER_NO 	
	,MEMBER_WORK_PERIOD.MEMBER_KEY
	,MEMBER_WORK_PERIOD_FUND.APP      
	,MEMBER_WORK_PERIOD_FUND.FUND   
) DATA INITIALLY DEFERRED REFRESH DEFERRED

thanks a lot for your help!
Cristi

 

[cristi22]

PLEASE DISREGARD!!!!