------------------------------------------------
-- DDL Statements for table "DB2     "."SKLAD_O_OB_GOOD"
------------------------------------------------
 SET CURRENT SCHEMA = "DB2     ";
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","DB2";
CREATE SUMMARY TABLE SKLAD_O_OB_GOOD AS ( SELECT TA.TYPE_S AS TYPE_S, TA.PLU
AS PLU, TA.DATES AS DATES, TA.sect as SECT, COUNT(*) AS SUM_ALLCNT,
SUM(TA.CNT)
AS SUM_CNT, SUM(TA.sumr) AS SUM_R, SUM(TA.sumz) AS SUM_Z FROM ( SELECT
'+' as type_s,T1.plu as plu, t1.dates as dates,t1.sect as sect, t1.cnt
 AS CNT, t1.sumr as sumr, t1.sumz as sumz FROM SKLAD_CART1 as T1 where
t1.pf<>'0' UNION ALL SELECT '-' as type_s,T1.plu as plu, t1.dates as
dates,t1.sect
as sect, -t1.cnt AS CNT, -(t1.sumr+t1.sump-t1.sumsk) as sumr, -t1.sumz
as sumz FROM SKLAD_CART2 as T1 where t1.pf<>'0' ) AS TA GROUP BY
TA.TYPE_S,TA.PLU,TA.DATES,TA.SECT
) DATA INITIALLY DEFERRED REFRESH DEFERRED;

SET SCHEMA 'DB2';

SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","DB2";

CREATE TABLE DB2.SKLAD_O_OB_GOOD
    ( TYPE_S, PLU, DATES, SECT, SUM_ALLCNT,
    SUM_CNT, SUM_R, SUM_Z )
AS  (
--> Warning - Unable to retrieve SQL text from DB2 catalog.
) DATA INITIALLY DEFERRED
  REFRESH DEFERRED
  IN USERSPACE1;

CREATE SUMMARY TABLE BUH_SKLADPAY AS ( 
SELECT 
SKLAD_DOCNUM AS SKLAD_DOCNUM, 
COUNT(*) AS SUM_ALLCNT,
SUM(SUMM) AS SUM 
FROM BUH_DOCS  GROUP BY SKLAD_DOCNUM)
DATA INITIALLY DEFERRED REFRESH DEFERRED^

set integrity for BUH_SKLADPAY materialized query immediate  unchecked^
create table BUH_SKLADPAY_s for BUH_SKLADPAY propagate immediate^
set integrity for BUH_SKLADPAY_s staging immediate unchecked^