asseco_vagrant/config/struktury/PROSW3

--#SET TERMINATOR &
-- TABLESPACES
SET CURRENT SQLID = 'W3'&
CREATE TABLESPACE SW3WNNAG IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ROW
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3NGPOZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ROW
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSKD IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSKO IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSKS IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNDDZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNDOP IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNDZA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNODZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNOOP IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNOZA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNRDC IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNROP IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNRZA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSOP IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSZA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSWZM IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSWZH IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSMPO IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3#PT04 IN BW301
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  CCSID UNICODE
  COMPRESS YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3#PT08 IN BW301
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  SEGSIZE 32
  BUFFERPOOL BP8K4
  LOCKSIZE ANY
  CLOSE YES
  CCSID UNICODE
  COMPRESS YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE LOB TABLESPACE SW3#PT31 IN BW301
  DSSIZE 32 G
  USING STOGROUP GW301 PRIQTY 1600 SECQTY -1 ERASE NO
  GBPCACHE NONE
  BUFFERPOOL BP32K4
  LOCKSIZE ANY
  CLOSE YES
  LOCKMAX SYSTEM&
CREATE LOB TABLESPACE SW3#PT32 IN BW301
  DSSIZE 32 G
  USING STOGROUP GW301 PRIQTY 1600 SECQTY -1 ERASE NO
  GBPCACHE NONE
  BUFFERPOOL BP32K4
  LOCKSIZE ANY
  CLOSE YES
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSBLA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3ZLEXM IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3WNSKR IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSPRA IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSPRZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSWAR IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSMBL IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSORZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSZWR IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSNOT IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSADR IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3ZLNFZ IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3300A IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSWZN IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3ZLSIO IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSTER IN BW301
  DSSIZE 32 G
  NUMPARTS 1
  MAXPARTITIONS 4
  USING STOGROUP GW301 PRIQTY 720 SECQTY -1 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  COMPRESS YES
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  MAXROWS 255
  LOCKMAX SYSTEM&
CREATE LOB TABLESPACE SW3#PT33 IN BW301
  DSSIZE 4 G
  USING STOGROUP GW301 PRIQTY -1 SECQTY -1 ERASE NO
  GBPCACHE NONE
  BUFFERPOOL BP32K4
  CLOSE YES
  LOCKMAX SYSTEM&
CREATE LOB TABLESPACE SW3#PT34 IN BW301
  DSSIZE 4 G
  USING STOGROUP GW301 PRIQTY -1 SECQTY -1 ERASE NO
  GBPCACHE NONE
  BUFFERPOOL BP32K4
  CLOSE YES
  LOCKMAX SYSTEM&
CREATE LOB TABLESPACE SW3#PT35 IN BW301
  DSSIZE 4 G
  USING STOGROUP GW301 PRIQTY -1 SECQTY -1 ERASE NO
  GBPCACHE NONE
  BUFFERPOOL BP32K4
  CLOSE YES
  LOCKMAX SYSTEM&
CREATE TABLESPACE SW3DSPOG IN BW301
  USING STOGROUP GW301 PRIQTY 80008 SECQTY 8004 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  SEGSIZE 32
  BUFFERPOOL BP12
  LOCKSIZE ANY
  CLOSE YES
  COMPRESS NO
  MAXROWS 255
  LOCKMAX SYSTEM&
COMMIT&
-- TABLES
SET CURRENT SQLID = 'W3'&
CREATE TABLE W3.DS_WNSK_NAG(
  ID_WN INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  IDPISMAEPWD INTEGER NOT NULL,
  ZNAK_PISMA_EPWD CHAR(30) NOT NULL,
  ID_ZRODL_WN CHAR(128),
  ZRODLO CHAR(1) NOT NULL,
  KOD_BANKU CHAR(3),
  DATA_REJ TIMESTAMP NOT NULL,
  DATA_REJ_KSI TIMESTAMP NOT NULL WITH DEFAULT,
  DATA_ZMIANY TIMESTAMP NOT NULL WITH DEFAULT,
  DATA_WPLYWU DATE NOT NULL,
  DATA_ZLOZENIA DATE NOT NULL,
  PRACOWNIK CHAR(40),
  DATA_WER_SYS DATE,
  NR_RACH_BANK CHAR(26) NOT NULL,
  ZALACZNIKI CHAR(1) NOT NULL WITH DEFAULT 'N',
  STATUS_WN SMALLINT NOT NULL,
  CZAS_ZM_EPWD TIMESTAMP,
  STATUS_EPWD SMALLINT,
  NR_SPRAWY CHAR(40),
  TYP_WN CHAR(10) NOT NULL,
  WERSJA INTEGER NOT NULL,
  CZAS_WYSLANIA TIMESTAMP,
  WN_ID_CRS INTEGER,
  WN_ID_CRU INTEGER,
  WN_ID_CRCZR INTEGER,
  INST_ID_CRP INTEGER,
  INST_ID_CRI INTEGER,
  WN_NAZWISKO VARCHAR(40),
  WN_IMIE VARCHAR(30),
  WN_NAZWA_PL VARCHAR(100),
  ROKOD SMALLINT NOT NULL,
  ROKDO SMALLINT NOT NULL,
  ROLA CHAR(2) NOT NULL,
  WN_SKORYG CHAR(1),
  PRZYCZ_BEZROZP SMALLINT,
  UKR_WN VARCHAR(3)
) IN BW301.SW3WNNAG&
-- GRANTS
GRANT ALTER ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_NAG TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_NAG TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_NAG TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_NAG
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_NAG_POZ(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  DZ_STANPRZ SMALLINT NOT NULL,
  DZ_ST_ID SMALLINT,
  DZ_ST_WERMER SMALLINT,
  GRUPA_TABDEC VARCHAR(50),
  DZ_ST_WERWZAJ SMALLINT,
  DZ_STATUS SMALLINT,
  DATA_REJ_POZ TIMESTAMP NOT NULL WITH DEFAULT,
  DATA_ZMIANY_ST TIMESTAMP NOT NULL WITH DEFAULT,
  DATA_ZMIANY TIMESTAMP NOT NULL,
  DZ_CZY_PESEL CHAR(1),
  DZ_ID_CRS INTEGER,
  DZ_ID_CRU INTEGER,
  DZ_ID_CRCZR INTEGER,
  DZ_IMIE VARCHAR(30),
  DZ_NAZWISKO VARCHAR(40),
  DZ_PESEL VARCHAR(11),
  DZ_RODZDOK CHAR(1),
  DZ_NRDOK VARCHAR(9),
  DZ_DATAUR DATE,
  WN_ID_CRS_CRI INTEGER,
  WN_ROLA CHAR(1),
  ROK_SZK_OD SMALLINT NOT NULL,
  RODZAJ_WN CHAR(1) NOT NULL WITH DEFAULT 'W',
  DATA_WNIOSKU DATE NOT NULL,
  DATA_OKOL DATE NOT NULL,
  P_DATA_WYSLANIA DATE,
  P_DATA_DORECZENIA DATE,
  P_SYGNATURA VARCHAR(40),
  P_DATA_PISMA DATE,
  DATA_PISMA_POPRZ DATE,
  RODZAJ_UPR SMALLINT,
  KWOTA_SWIAD DECIMAL(10,2),
  DATA_ROZSTRZ DATE,
  STATUS_EPWD SMALLINT,
  CZAS_ZM_EPWD TIMESTAMP,
  ID_POST_EPWD INTEGER,
  UPR_STATUS CHAR(1) NOT NULL WITH DEFAULT 'B',
  UPR_ID INTEGER,
  PRACOWNIK CHAR(40),
  WZN_ID INTEGER,
  PRZYCZ_BEZROZP SMALLINT,
  TYP_OKOL SMALLINT NOT NULL WITH DEFAULT 1,
  GRUPA_WIEK CHAR(20),
  OBYWATELSTWO CHAR(20),
  POWOD CHAR(2),
  UKR_DZ VARCHAR(3)
) IN BW301.SW3NGPOZ&
-- GRANTS
GRANT SELECT ON W3.DS_NAG_POZ TO YOWNRP&
GRANT ALTER ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_NAG_POZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_NAG_POZ TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_NAG_POZ
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_D(
  DSIDWN INTEGER NOT NULL,
  DSWERSJA INTEGER NOT NULL,
  DSPODMIOT CHAR(1),
  DSINAZWAINSTYTUCJI VARCHAR(100),
  DSIREGON VARCHAR(14),
  DSOIMIE VARCHAR(30),
  DSONAZWISKO VARCHAR(40),
  DSOPESEL VARCHAR(11),
  DSNIP VARCHAR(10),
  DSKODPOCZT VARCHAR(10),
  DSMIEJSCOWOSC VARCHAR(56),
  DSULICA VARCHAR(100),
  DSBUDYNEK VARCHAR(9),
  DSLOKAL VARCHAR(10),
  DSSKRPOCZT VARCHAR(10),
  DSKRAJ VARCHAR(25),
  DSEMAIL VARCHAR(50),
  DSTELEFON VARCHAR(40),
  DSROKOD SMALLINT NOT NULL,
  DSROKDO SMALLINT NOT NULL,
  DSPNIP VARCHAR(10) NOT NULL,
  DSPREGON VARCHAR(14) NOT NULL,
  DSPNAZWAINSTYTUCJI VARCHAR(62) NOT NULL,
  DSPULICA VARCHAR(100),
  DSPNRDOMU VARCHAR(12) NOT NULL,
  DSPNRLOKALU VARCHAR(12),
  DSPKODPOCZT VARCHAR(6) NOT NULL,
  DSPMIEJSCOWOSC VARCHAR(56) NOT NULL,
  DSPGMINA VARCHAR(39),
  DSPGMINAKOD VARCHAR(7),
  DSPPOWIAT VARCHAR(36) NOT NULL,
  DSPWOJEWODZTWO VARCHAR(36) NOT NULL,
  DSPTELEFON VARCHAR(19) NOT NULL,
  DSPEMAIL VARCHAR(50) NOT NULL,
  DSDPESEL VARCHAR(11),
  DSDRODZDOK CHAR(1),
  DSDNRDOK VARCHAR(9),
  DSDDATAUR DATE NOT NULL,
  DSDIMIE VARCHAR(30) NOT NULL,
  DSDNAZWISKO VARCHAR(40) NOT NULL,
  DSNRRACHBANK VARCHAR(26) NOT NULL,
  DSDATA DATE NOT NULL
) IN BW301.SW3WNSKD&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_D TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_D TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_D
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_O(
  DSIDWN INTEGER NOT NULL,
  DSWERSJA INTEGER NOT NULL,
  DSPODMIOT CHAR(1),
  DSINAZWAINSTYTUCJI VARCHAR(100),
  DSIREGON VARCHAR(14),
  DSOIMIE VARCHAR(30),
  DSONAZWISKO VARCHAR(40),
  DSOPESEL VARCHAR(11),
  DSNIP VARCHAR(10),
  DSKODPOCZT VARCHAR(10),
  DSMIEJSCOWOSC VARCHAR(56),
  DSULICA VARCHAR(100),
  DSBUDYNEK VARCHAR(9),
  DSLOKAL VARCHAR(10),
  DSSKRPOCZT VARCHAR(10),
  DSKRAJ VARCHAR(25),
  DSEMAIL VARCHAR(50),
  DSTELEFON VARCHAR(40),
  DSROKOD SMALLINT NOT NULL,
  DSROKDO SMALLINT NOT NULL,
  DSOPIEKUNKOD CHAR(2) NOT NULL,
  DSOPIEKUN VARCHAR(500) NOT NULL,
  DSWPESEL VARCHAR(11),
  DSWRODZDOK CHAR(1),
  DSWNRDOK VARCHAR(9),
  DSWDATAUR DATE NOT NULL,
  DSWIMIE VARCHAR(30) NOT NULL,
  DSWNAZWISKO VARCHAR(40) NOT NULL,
  DSWOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSWOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSWULICA VARCHAR(100),
  DSWNRDOMU VARCHAR(12),
  DSWNRLOKALU VARCHAR(12),
  DSWKODPOCZT VARCHAR(6),
  DSWZAGRKODPOCZT VARCHAR(12),
  DSWMIEJSCOWOSC VARCHAR(56) NOT NULL,
  DSWGMINA VARCHAR(39),
  DSWGMINAKOD VARCHAR(7),
  DSWPOWIAT VARCHAR(36),
  DSWWOJEWODZTWO VARCHAR(36),
  DSWNAZWAPANSTWAKOD CHAR(2) NOT NULL,
  DSWNAZWAPANSTWA VARCHAR(30) NOT NULL,
  DSWTELEFON VARCHAR(19) NOT NULL,
  DSWEMAIL VARCHAR(50) NOT NULL,
  DSRNRRACHBANK VARCHAR(26) NOT NULL,
  DSDATA DATE NOT NULL
) IN BW301.SW3WNSKO&
-- GRANTS
GRANT ALTER ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_O TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_O TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_O
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_S(
  DSIDWN INTEGER NOT NULL,
  DSWERSJA INTEGER NOT NULL,
  DSPODMIOT CHAR(1),
  DSINAZWAINSTYTUCJI VARCHAR(100),
  DSIREGON VARCHAR(14),
  DSOIMIE VARCHAR(30),
  DSONAZWISKO VARCHAR(40),
  DSOPESEL VARCHAR(11),
  DSNIP VARCHAR(10),
  DSKODPOCZT VARCHAR(10),
  DSMIEJSCOWOSC VARCHAR(56),
  DSULICA VARCHAR(100),
  DSBUDYNEK VARCHAR(9),
  DSLOKAL VARCHAR(10),
  DSSKRPOCZT VARCHAR(10),
  DSKRAJ VARCHAR(25),
  DSEMAIL VARCHAR(50),
  DSTELEFON VARCHAR(40),
  DSROKOD SMALLINT NOT NULL,
  DSROKDO SMALLINT NOT NULL,
  DSOPIEKUNKOD CHAR(2) NOT NULL,
  DSOPIEKUN VARCHAR(500) NOT NULL,
  DSWPESEL VARCHAR(11),
  DSWRODZDOK CHAR(1),
  DSWNRDOK VARCHAR(9),
  DSWDATAUR DATE NOT NULL,
  DSWIMIE VARCHAR(30) NOT NULL,
  DSWNAZWISKO VARCHAR(40) NOT NULL,
  DSWOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSWOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSWULICA VARCHAR(100),
  DSWNRDOMU VARCHAR(12),
  DSWNRLOKALU VARCHAR(12),
  DSWKODPOCZT VARCHAR(6),
  DSWZAGRKODPOCZT VARCHAR(12),
  DSWMIEJSCOWOSC VARCHAR(56) NOT NULL,
  DSWGMINA VARCHAR(39),
  DSWGMINAKOD VARCHAR(7),
  DSWPOWIAT VARCHAR(36),
  DSWWOJEWODZTWO VARCHAR(36),
  DSWNAZWAPANSTWAKOD CHAR(2) NOT NULL,
  DSWNAZWAPANSTWA VARCHAR(30) NOT NULL,
  DSWTELEFON VARCHAR(19) NOT NULL,
  DSWEMAIL VARCHAR(50) NOT NULL,
  DSRNRRACHBANK VARCHAR(26) NOT NULL,
  DSSPOWODKOD CHAR(2),
  DSSPOWOD VARCHAR(500),
  DSDUCZDOSZKOLYTAK CHAR(1),
  DSDUCZDOSZKOLYNIE CHAR(1),
  DSDNIEPSPRTAK CHAR(1),
  DSDNIEPSPRNIE CHAR(1),
  DSDORZONIEPSPRKOD CHAR(2),
  DSDORZONIEPSPR VARCHAR(500),
  DSSRODZSZKOLYKOD CHAR(2),
  DSSRODZAJSZKOLY VARCHAR(500),
  DSSNAZWASZKOLY VARCHAR(300),
  DSSULICA VARCHAR(100),
  DSSNUMERDOMU VARCHAR(12),
  DSSNUMERLOKALU VARCHAR(12),
  DSSKODPOCZT VARCHAR(6),
  DSSZAGRKODPOCZT VARCHAR(12),
  DSSMIEJSCOWOSC VARCHAR(56),
  DSSNAZWAPANSTWAKOD CHAR(2),
  DSSNAZWAPANSTWA VARCHAR(30),
  DSDATA DATE NOT NULL
) IN BW301.SW3WNSKS&
-- GRANTS
GRANT ALTER ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_S TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_S TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_S
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_D_DZIECKO(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSPOZYCJA INTEGER NOT NULL,
  DSDPESEL VARCHAR(11),
  DSDRODZDOK CHAR(1),
  DSDNRDOK VARCHAR(9),
  DSDDATAUR DATE NOT NULL,
  DSDIMIE VARCHAR(30) NOT NULL,
  DSDNAZWISKO VARCHAR(40) NOT NULL,
  DSDOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSDOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSDUCZDOSZKOLYTAK CHAR(1),
  DSDUCZDOSZKOLYNIE CHAR(1),
  DSDUCZDOZERTAK CHAR(1),
  DSDUCZDOZERNIE CHAR(1),
  DSDUCZZAJRWTAK CHAR(1),
  DSDUCZZAJRWNIE CHAR(1),
  DSDNIEPSPRTAK CHAR(1),
  DSDNIEPSPRNIE CHAR(1),
  DSDORZONIEPSPRKOD CHAR(2),
  DSDORZONIEPSPR VARCHAR(500),
  DSSRODZSZKOLYKOD CHAR(2),
  DSSRODZAJSZKOLY VARCHAR(500),
  DSSNAZWASZKOLY VARCHAR(300),
  DSSULICA VARCHAR(100),
  DSSNRDOMU VARCHAR(12),
  DSSNRLOKALU VARCHAR(12),
  DSSKODPOCZT VARCHAR(6),
  DSSZAGRKODPOCZT VARCHAR(12),
  DSSMIEJSCOWOSC VARCHAR(56),
  DSSNAZWAPANSTWAKOD CHAR(2),
  DSSNAZWAPANSTWA VARCHAR(30)
) IN BW301.SW3WNDDZ&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_D_DZIECKO TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_D_DZIECKO TO YODZ01&
GRANT ALTER ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_D_DZIECKO TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_D_DZIECKO
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_D_OP(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSOPTYP CHAR(1) NOT NULL,
  DSOPKOD CHAR(2) NOT NULL,
  DSOPWERSJA CHAR(3) NOT NULL,
  DSOAKCEPTACJA CHAR(1),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNDOP&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_D_OP TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_D_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D_OP TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_D_OP
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_D_ZAL(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSZRODZZALKOD CHAR(2) NOT NULL,
  DSZOPISRODZZAL VARCHAR(500),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNDZA&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_D_ZAL TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_D_ZAL TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_D_ZAL TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_D_ZAL
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_O_DZIECKO(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSPOZYCJA INTEGER NOT NULL,
  DSDPESEL VARCHAR(11),
  DSDRODZDOK CHAR(1),
  DSDNRDOK VARCHAR(9),
  DSDDATAUR DATE NOT NULL,
  DSDIMIE VARCHAR(30) NOT NULL,
  DSDNAZWISKO VARCHAR(40) NOT NULL,
  DSDOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSDOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSDUCZDOSZKOLYTAK CHAR(1),
  DSDUCZDOSZKOLYNIE CHAR(1),
  DSDUCZDOZERTAK CHAR(1),
  DSDUCZDOZERNIE CHAR(1),
  DSDUCZZAJRWTAK CHAR(1),
  DSDUCZZAJRWNIE CHAR(1),
  DSDNIEPSPRTAK CHAR(1),
  DSDNIEPSPRNIE CHAR(1),
  DSDORZONIEPSPRKOD CHAR(2),
  DSDORZONIEPSPR VARCHAR(500),
  DSSRODZSZKOLYKOD CHAR(2),
  DSSRODZAJSZKOLY VARCHAR(500),
  DSSNAZWASZKOLY VARCHAR(300),
  DSSULICA VARCHAR(100),
  DSSNRDOMU VARCHAR(12),
  DSSNRLOKALU VARCHAR(12),
  DSSKODPOCZT VARCHAR(6),
  DSSZAGRKODPOCZT VARCHAR(12),
  DSSMIEJSCOWOSC VARCHAR(56),
  DSSNAZWAPANSTWAKOD CHAR(2),
  DSSNAZWAPANSTWA VARCHAR(30)
) IN BW301.SW3WNODZ&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_O_DZIECKO TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_O_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O_DZIECKO TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_O_DZIECKO
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_O_OP(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSOPTYP CHAR(1) NOT NULL,
  DSOPKOD CHAR(2) NOT NULL,
  DSOPWERSJA CHAR(3) NOT NULL,
  DSOAKCEPTACJA CHAR(1),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNOOP&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_O_OP TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_O_OP TO YODZ01&
GRANT ALTER ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_O_OP TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_O_OP
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_O_ZAL(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSZRODZZALKOD CHAR(2) NOT NULL,
  DSZOPISRODZZAL VARCHAR(500),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNOZA&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_O_ZAL TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_O_ZAL TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_O_ZAL TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_O_ZAL
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_R_DZIECKO(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSPOZYCJA INTEGER NOT NULL,
  DSDPESEL VARCHAR(11),
  DSDRODZDOK CHAR(1),
  DSDNRDOK VARCHAR(9),
  DSDDATAUR DATE NOT NULL,
  DSDIMIE VARCHAR(30) NOT NULL,
  DSDNAZWISKO VARCHAR(40) NOT NULL,
  DSDOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSDOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSDUCZDOSZKOLYTAK CHAR(1),
  DSDUCZDOSZKOLYNIE CHAR(1),
  DSDUCZDOZERTAK CHAR(1),
  DSDUCZDOZERNIE CHAR(1),
  DSDUCZZAJRWTAK CHAR(1),
  DSDUCZZAJRWNIE CHAR(1),
  DSDNIEPSPRTAK CHAR(1),
  DSDNIEPSPRNIE CHAR(1),
  DSDORZONIEPSPRKOD CHAR(2),
  DSDORZONIEPSPR VARCHAR(500),
  DSSRODZSZKOLYKOD CHAR(2),
  DSSRODZAJSZKOLY VARCHAR(500),
  DSSNAZWASZKOLY VARCHAR(300),
  DSSULICA VARCHAR(100),
  DSSNRDOMU VARCHAR(12),
  DSSNRLOKALU VARCHAR(12),
  DSSKODPOCZT VARCHAR(6),
  DSSZAGRKODPOCZT VARCHAR(12),
  DSSMIEJSCOWOSC VARCHAR(56),
  DSSNAZWAPANSTWAKOD CHAR(2),
  DSSNAZWAPANSTWA VARCHAR(30)
) IN BW301.SW3WNRDC&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_R_DZIECKO TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_R_DZIECKO TO YODZ01&
GRANT ALTER ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_R_DZIECKO TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_R_DZIECKO
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_R_OP(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSOPTYP CHAR(1) NOT NULL,
  DSOPKOD CHAR(2) NOT NULL,
  DSOPWERSJA CHAR(3) NOT NULL,
  DSOAKCEPTACJA CHAR(1),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNROP&
-- GRANTS
GRANT ALTER ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_R_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_R_OP TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_R_OP TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_R_OP
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_R_ZAL(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSZRODZZALKOD CHAR(2) NOT NULL,
  DSZOPISRODZZAL VARCHAR(500),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNRZA&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_R_ZAL TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_R_ZAL TO YODZ01&
GRANT ALTER ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_R_ZAL TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_R_ZAL
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_S_OP(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSPTYP CHAR(1) NOT NULL,
  DSOPKOD CHAR(2) NOT NULL,
  DSOPWERSJA CHAR(3) NOT NULL,
  DSOAKCEPTACJA CHAR(1),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNSOP&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_S_OP TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_S_OP TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S_OP TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_S_OP
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_S_ZAL(
  DSID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  DSIDWN INTEGER NOT NULL,
  DSZRODZZALKOD CHAR(2) NOT NULL,
  DSZOPISRODZZAL VARCHAR(500),
  DSDATA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3WNSZA&
-- GRANTS
GRANT ALTER ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_S_ZAL TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_S_ZAL TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_S_ZAL TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_S_ZAL
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_ZMIANA(
  ID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT,
  NOWY_STATUS SMALLINT,
  STARY_STATUS SMALLINT,
  TYP VARCHAR(50) NOT NULL,
  CZAS_OPERACJI TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3DSWZM&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_ZMIANA TO YOWNRP&
GRANT SELECT ON W3.DS_WNSK_ZMIANA TO YODZ01&
GRANT ALTER ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_ZMIANA TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_ZMIANA
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WNSK_ZMIANA_HIST(
  ID INTEGER NOT NULL,
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT,
  NOWY_STATUS SMALLINT,
  STARY_STATUS SMALLINT,
  TYP VARCHAR(50) NOT NULL,
  CZAS_OPERACJI TIMESTAMP,
  CZAS_WSTAWIENIA TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3DSWZH&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_ZMIANA_HIST TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_ZMIANA_HIST TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_ZMIANA_HIST TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_ZMIANA_HIST
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_MF2EPWD_POZ(
  ID_ZLEC INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  IDPISMAEPWD INTEGER NOT NULL,
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  TYP_WN CHAR(10) NOT NULL,
  DTCZAS_UTW TIMESTAMP NOT NULL WITH DEFAULT,
  STATUS_POZ SMALLINT NOT NULL,
  STATUS_EPWD SMALLINT NOT NULL,
  DTCZAS_ZMN TIMESTAMP
) IN BW301.SW3DSMPO&
-- GRANTS
GRANT SELECT ON W3.DS_MF2EPWD_POZ TO YODZ01&
GRANT ALTER ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_MF2EPWD_POZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_MF2EPWD_POZ TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_MF2EPWD_POZ
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DSN_DETCOST_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  PLANNO SMALLINT NOT NULL,
  OPENIO FLOAT NOT NULL,
  OPENCPU FLOAT NOT NULL,
  OPENCOST FLOAT NOT NULL,
  DMIO FLOAT NOT NULL,
  DMCPU FLOAT NOT NULL,
  DMTOT FLOAT NOT NULL,
  SUBQIO FLOAT NOT NULL,
  SUBQCPU FLOAT NOT NULL,
  SUBQCOST FLOAT NOT NULL,
  BASEIO FLOAT NOT NULL,
  BASECPU FLOAT NOT NULL,
  BASETOT FLOAT NOT NULL,
  ONECOMPROWS FLOAT NOT NULL,
  IMLEAF FLOAT NOT NULL,
  IMIO FLOAT NOT NULL,
  IMPREFH CHAR(2) NOT NULL,
  IMMPRED INTEGER NOT NULL,
  IMFF FLOAT NOT NULL,
  IMSRPRED INTEGER NOT NULL,
  IMFFADJ FLOAT NOT NULL,
  IMSCANCST FLOAT NOT NULL,
  IMROWCST FLOAT NOT NULL,
  IMPAGECST FLOAT NOT NULL,
  IMRIDSORT FLOAT NOT NULL,
  IMMERGCST FLOAT NOT NULL,
  IMCPU FLOAT NOT NULL,
  IMTOT FLOAT NOT NULL,
  IMSEQNO SMALLINT NOT NULL,
  DMPREFH CHAR(2) NOT NULL,
  DMCLUDIO FLOAT NOT NULL,
  DMNCLUDIO FLOAT NOT NULL,
  DMPREDS INTEGER NOT NULL,
  DMSROWS FLOAT NOT NULL,
  DMSCANCST FLOAT NOT NULL,
  DMCOLS SMALLINT NOT NULL,
  DMROWS FLOAT NOT NULL,
  RDSROWCST FLOAT NOT NULL,
  DMPAGECST FLOAT NOT NULL,
  DMDATAIO FLOAT NOT NULL,
  DMDATACPU FLOAT NOT NULL,
  DMDATATOT FLOAT NOT NULL,
  RDSROW FLOAT NOT NULL,
  SNCOLS SMALLINT NOT NULL,
  SNROWS FLOAT NOT NULL,
  SNRECSZ INTEGER NOT NULL,
  SNPAGES FLOAT NOT NULL,
  SNRUNS FLOAT NOT NULL,
  SNMERGES FLOAT NOT NULL,
  SNIOCOST FLOAT NOT NULL,
  SNCPUCOST FLOAT NOT NULL,
  SNCOST FLOAT NOT NULL,
  SNSCANIO FLOAT NOT NULL,
  SNSCANCPU FLOAT NOT NULL,
  SNSCANCOST FLOAT NOT NULL,
  SCCOLS SMALLINT NOT NULL,
  SCROWS FLOAT NOT NULL,
  SCRECSZ INTEGER NOT NULL,
  SCPAGES FLOAT NOT NULL,
  SCRUNS FLOAT NOT NULL,
  SCMERGES FLOAT NOT NULL,
  SCIOCOST FLOAT NOT NULL,
  SCCPUCOST FLOAT NOT NULL,
  SCCOST FLOAT NOT NULL,
  SCSCANIO FLOAT NOT NULL,
  SCSCANCPU FLOAT NOT NULL,
  SCSCANCOST FLOAT NOT NULL,
  COMPCARD FLOAT NOT NULL,
  COMPIOCOST FLOAT NOT NULL,
  COMPCPUCOST FLOAT NOT NULL,
  COMPCOST FLOAT NOT NULL,
  JOINCOLS SMALLINT NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  COSTBLK INTEGER NOT NULL,
  COSTSTOR INTEGER NOT NULL,
  MPBLK INTEGER NOT NULL,
  MPSTOR INTEGER NOT NULL,
  COMPOSITES INTEGER NOT NULL,
  CLIPPED INTEGER NOT NULL,
  "PARTITION" INTEGER NOT NULL,
  TABREF VARCHAR(64) FOR BIT DATA NOT NULL,
  MAX_COMPOSITES INTEGER NOT NULL,
  MAX_STOR INTEGER NOT NULL,
  MAX_CPU INTEGER NOT NULL,
  MAX_ELAP INTEGER NOT NULL,
  TBL_JOINED_THRESH INTEGER NOT NULL,
  STOR_USED INTEGER NOT NULL,
  CPU_USED INTEGER NOT NULL,
  ELAPSED INTEGER NOT NULL,
  MIN_CARD_KEEP FLOAT NOT NULL,
  MAX_CARD_KEEP FLOAT NOT NULL,
  MIN_COST_KEEP FLOAT NOT NULL,
  MAX_COST_KEEP FLOAT NOT NULL,
  MIN_VALUE_KEEP FLOAT NOT NULL,
  MIN_VALUE_CARD_KEEP FLOAT NOT NULL,
  MIN_VALUE_COST_KEEP FLOAT NOT NULL,
  MAX_VALUE_KEEP FLOAT NOT NULL,
  MAX_VALUE_CARD_KEEP FLOAT NOT NULL,
  MAX_VALUE_COST_KEEP FLOAT NOT NULL,
  MIN_CARD_CLIP FLOAT NOT NULL,
  MAX_CARD_CLIP FLOAT NOT NULL,
  MIN_COST_CLIP FLOAT NOT NULL,
  MAX_COST_CLIP FLOAT NOT NULL,
  MIN_VALUE_CLIP FLOAT NOT NULL,
  MIN_VALUE_CARD_CLIP FLOAT NOT NULL,
  MIN_VALUE_COST_CLIP FLOAT NOT NULL,
  MAX_VALUE_CLIP FLOAT NOT NULL,
  MAX_VALUE_CARD_CLIP FLOAT NOT NULL,
  MAX_VALUE_COST_CLIP FLOAT NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  PSEQIOCOST FLOAT NOT NULL,
  PSEQCPUCOST FLOAT NOT NULL,
  PSEQCOST FLOAT NOT NULL,
  PADJIOCOST FLOAT NOT NULL,
  PADJCPUCOST FLOAT NOT NULL,
  PADJCOST FLOAT NOT NULL,
  UNCERTAINTY FLOAT NOT NULL WITH DEFAULT,
  UNCERTAINTY_1T FLOAT NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  IMNP FLOAT NOT NULL WITH DEFAULT,
  DMNP FLOAT NOT NULL WITH DEFAULT,
  IMJC FLOAT NOT NULL WITH DEFAULT,
  IMFC FLOAT NOT NULL WITH DEFAULT,
  IMJBC FLOAT NOT NULL WITH DEFAULT,
  IMJFC FLOAT NOT NULL WITH DEFAULT,
  CRED INTEGER NOT NULL WITH DEFAULT,
  IXSCAN_SKIP_DUPS CHAR(1) NOT NULL WITH DEFAULT 'N',
  IXSCAN_SKIP_SCREEN CHAR(1) NOT NULL WITH DEFAULT 'N',
  EARLY_OUT CHAR(1) NOT NULL WITH DEFAULT ' ',
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  BLOCK_FETCH CHAR(1) NOT NULL WITH DEFAULT 'N',
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_DETCOST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_DETCOST_TABLE TO WNSEL&
GRANT SELECT ON W3.DSN_DETCOST_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_FILTER_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  PLANNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  ORDERNO INTEGER NOT NULL,
  PREDNO INTEGER NOT NULL,
  STAGE CHAR(9) NOT NULL,
  ORDERCLASS INTEGER NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  MIXOPSEQNO SMALLINT NOT NULL,
  REEVAL CHAR(1) NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  PUSHDOWN CHAR(1) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_FILTER_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_FILTER_TABLE TO WNSEL&
GRANT SELECT ON W3.DSN_FILTER_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_PGRANGE_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  TABNO SMALLINT NOT NULL,
  RANGE SMALLINT NOT NULL,
  FIRSTPART SMALLINT NOT NULL,
  LASTPART SMALLINT NOT NULL,
  "NUMPARTS" SMALLINT NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_PGRANGE_TABLE TO YA1ZPM&
GRANT SELECT ON W3.DSN_PGRANGE_TABLE TO WNSEL&
GRANT ALTER ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_PGRANGE_TABLE TO W3
  WITH GRANT OPTION&
-- TABLES
CREATE TABLE W3.DSN_PGROUP_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  PLANNAME VARCHAR(24) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  VERSION VARCHAR(122) NOT NULL,
  GROUPID SMALLINT NOT NULL,
  FIRSTPLAN SMALLINT NOT NULL,
  LASTPLAN SMALLINT NOT NULL,
  CPUCOST FLOAT NOT NULL,
  IOCOST FLOAT NOT NULL,
  BESTTIME FLOAT NOT NULL,
  DEGREE SMALLINT NOT NULL,
  MODE CHAR(1) NOT NULL,
  REASON SMALLINT NOT NULL,
  LOCALCPU SMALLINT NOT NULL,
  TOTALCPU SMALLINT NOT NULL,
  FIRSTBASE SMALLINT,
  LARGETS CHAR(1),
  PARTKIND CHAR(1),
  GROUPTYPE CHAR(3),
  "ORDER" CHAR(1),
  "STYLE" CHAR(4),
  RANGEKIND CHAR(1),
  NKEYCOLS SMALLINT,
  LOWBOUND VARCHAR(40) FOR BIT DATA,
  HIGHBOUND VARCHAR(40) FOR BIT DATA,
  LOWKEY VARCHAR(40) FOR BIT DATA,
  HIGHKEY VARCHAR(40) FOR BIT DATA,
  FIRSTPAGE CHAR(4) FOR BIT DATA,
  LASTPAGE CHAR(4) FOR BIT DATA,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  HOST_REASON SMALLINT,
  PARA_TYPE CHAR(4),
  PART_INNER CHAR(1),
  GRNU_KEYRNG CHAR(1),
  OPEN_KEYRNG CHAR(1),
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  STRAW_MODEL CHAR(1) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_PGROUP_TABLE TO YA1ZPM&
GRANT ALTER ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_PGROUP_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PGROUP_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_PREDICAT_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  PREDNO INTEGER NOT NULL,
  TYPE CHAR(8) NOT NULL,
  LEFT_HAND_SIDE VARCHAR(128) NOT NULL,
  LEFT_HAND_PNO INTEGER NOT NULL,
  LHS_TABNO SMALLINT NOT NULL,
  LHS_QBNO SMALLINT NOT NULL,
  RIGHT_HAND_SIDE VARCHAR(128) NOT NULL,
  RIGHT_HAND_PNO INTEGER NOT NULL,
  RHS_TABNO SMALLINT NOT NULL,
  RHS_QBNO SMALLINT NOT NULL,
  FILTER_FACTOR FLOAT NOT NULL,
  BOOLEAN_TERM CHAR(1) NOT NULL,
  SEARCHARG CHAR(1) NOT NULL,
  "JOIN" CHAR(1) NOT NULL,
  AFTER_JOIN CHAR(1) NOT NULL,
  ADDED_PRED CHAR(1) NOT NULL,
  REDUNDANT_PRED CHAR(1) NOT NULL,
  DIRECT_ACCESS CHAR(1) NOT NULL,
  KEYFIELD CHAR(1) NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  CATEGORY SMALLINT NOT NULL,
  CATEGORY_B SMALLINT NOT NULL,
  TEXT VARCHAR(2000) NOT NULL,
  PRED_ENCODE CHAR(1) NOT NULL WITH DEFAULT,
  PRED_CCSID SMALLINT NOT NULL WITH DEFAULT,
  PRED_MCCSID SMALLINT NOT NULL WITH DEFAULT,
  MARKER CHAR(1) NOT NULL WITH DEFAULT,
  PARENT_PNO INTEGER NOT NULL,
  NEGATION CHAR(1) NOT NULL,
  LITERALS VARCHAR(128) NOT NULL,
  CLAUSE CHAR(8) NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  ORIGIN CHAR(1) NOT NULL WITH DEFAULT,
  UNCERTAINTY FLOAT NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_PREDICAT_TABLE TO YA1ZPM&
GRANT ALTER ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_PREDICAT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PREDICAT_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_PTASK_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  PGDNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  LPTNO SMALLINT NOT NULL,
  KEYCOLID SMALLINT,
  DPSI CHAR(1) NOT NULL,
  LPTLOKEY VARCHAR(40) FOR BIT DATA,
  LPTHIKEY VARCHAR(40) FOR BIT DATA,
  LPTLOPAG CHAR(4) FOR BIT DATA,
  LPTHIPAG CHAR(4) FOR BIT DATA,
  LPTLOPG CHAR(4) FOR BIT DATA,
  LPTHIPG CHAR(4) FOR BIT DATA,
  LPTLOPT SMALLINT,
  LPTHIPT SMALLINT,
  KEYCOLDT SMALLINT,
  KEYCOLPREC SMALLINT,
  KEYCOLSCAL SMALLINT,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_PTASK_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PTASK_TABLE TO WNSEL&
GRANT SELECT ON W3.DSN_PTASK_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_QUERY_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  TYPE CHAR(8) NOT NULL,
  QUERY_STAGE CHAR(8) NOT NULL,
  SEQNO INTEGER NOT NULL,
  NODE_DATA CLOB NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  QUERY_ROWID ROWID NOT NULL GENERATED ALWAYS,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  HASHKEY INTEGER NOT NULL,
  HAS_PRED CHAR(1) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_QUERY_TABLE TO YA1ZPM&
GRANT SELECT ON W3.DSN_QUERY_TABLE TO WNSEL&
GRANT ALTER ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_QUERY_TABLE TO W3
  WITH GRANT OPTION&
-- TABLES
CREATE TABLE W3.DSN_SORTKEY_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  PLANNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  SORTNO SMALLINT NOT NULL,
  ORDERNO SMALLINT NOT NULL,
  EXPTYPE CHAR(3) NOT NULL,
  TEXT VARCHAR(128) NOT NULL,
  TABNO SMALLINT NOT NULL,
  COLNO SMALLINT NOT NULL,
  DATATYPE CHAR(18) NOT NULL,
  LENGTH INTEGER NOT NULL,
  "CCSID" INTEGER NOT NULL,
  ORDERCLASS INTEGER NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_SORTKEY_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_SORTKEY_TABLE TO YA1ZPM&
GRANT SELECT ON W3.DSN_SORTKEY_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_SORT_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  PLANNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  SORTC CHAR(5) NOT NULL WITH DEFAULT,
  SORTN CHAR(5) NOT NULL WITH DEFAULT,
  SORTNO SMALLINT NOT NULL,
  KEYSIZE SMALLINT NOT NULL,
  ORDERCLASS INTEGER NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_SORT_TABLE TO YA1ZPM&
GRANT ALTER ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_SORT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_SORT_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_STATEMENT_CACHE_TABLE(
  STMT_ID INTEGER NOT NULL,
  STMT_TOKEN VARCHAR(240),
  "COLLID" VARCHAR(128) NOT NULL,
  PROGRAM_NAME VARCHAR(128) NOT NULL,
  INV_DROPALT CHAR(1) NOT NULL,
  INV_REVOKE CHAR(1) NOT NULL,
  INV_LRU CHAR(1) NOT NULL,
  INV_RUNSTATS CHAR(1) NOT NULL,
  CACHED_TS TIMESTAMP NOT NULL,
  USERS INTEGER NOT NULL,
  COPIES INTEGER NOT NULL,
  LINES INTEGER NOT NULL,
  PRIMAUTH VARCHAR(128) NOT NULL,
  CURSQLID VARCHAR(128) NOT NULL,
  BIND_QUALIFIER VARCHAR(128) NOT NULL,
  BIND_ISO CHAR(2) NOT NULL,
  BIND_CDATA CHAR(1) NOT NULL,
  BIND_DYNRL CHAR(1) NOT NULL,
  BIND_DEGRE CHAR(1) NOT NULL,
  BIND_SQLRL CHAR(1) NOT NULL,
  BIND_CHOLD CHAR(1) NOT NULL,
  STAT_TS TIMESTAMP NOT NULL,
  STAT_EXEC INTEGER NOT NULL,
  STAT_GPAG INTEGER NOT NULL,
  STAT_SYNR INTEGER NOT NULL,
  STAT_WRIT INTEGER NOT NULL,
  STAT_EROW INTEGER NOT NULL,
  STAT_PROW INTEGER NOT NULL,
  STAT_SORT INTEGER NOT NULL,
  STAT_INDX INTEGER NOT NULL,
  STAT_RSCN INTEGER NOT NULL,
  STAT_PGRP INTEGER NOT NULL,
  STAT_ELAP FLOAT NOT NULL,
  STAT_CPU FLOAT NOT NULL,
  STAT_SUS_SYNIO FLOAT NOT NULL,
  STAT_SUS_LOCK FLOAT NOT NULL,
  STAT_SUS_SWIT FLOAT NOT NULL,
  STAT_SUS_GLCK FLOAT NOT NULL,
  STAT_SUS_OTHR FLOAT NOT NULL,
  STAT_SUS_OTHW FLOAT NOT NULL,
  STAT_RIDLIMT INTEGER NOT NULL,
  STAT_RIDSTOR INTEGER NOT NULL,
  EXPLAIN_TS TIMESTAMP NOT NULL,
  "SCHEMA" VARCHAR(128) NOT NULL,
  STMT_TEXT CLOB NOT NULL,
  STMT_ROWID ROWID NOT NULL GENERATED ALWAYS,
  BIND_RO_TYPE CHAR(1) NOT NULL WITH DEFAULT,
  BIND_RA_TOT INTEGER NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL WITH DEFAULT,
  STAT_EXECB BIGINT NOT NULL WITH DEFAULT,
  STAT_GPAGB BIGINT NOT NULL WITH DEFAULT,
  STAT_SYNRB BIGINT NOT NULL WITH DEFAULT,
  STAT_WRITB BIGINT NOT NULL WITH DEFAULT,
  STAT_EROWB BIGINT NOT NULL WITH DEFAULT,
  STAT_PROWB BIGINT NOT NULL WITH DEFAULT,
  STAT_SORTB BIGINT NOT NULL WITH DEFAULT,
  STAT_INDXB BIGINT NOT NULL WITH DEFAULT,
  STAT_RSCNB BIGINT NOT NULL WITH DEFAULT,
  STAT_PGRPB BIGINT NOT NULL WITH DEFAULT,
  STAT_RIDLIMTB BIGINT NOT NULL WITH DEFAULT,
  STAT_RIDSTORB BIGINT NOT NULL WITH DEFAULT,
  LITERAL_REPL CHAR(1) NOT NULL WITH DEFAULT,
  STAT_SUS_LATCH FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_PLATCH FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_DRAIN FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_CLAIM FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_LOG FLOAT NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  ACCELERATED CHAR(10) NOT NULL WITH DEFAULT 'NO',
  STAT_ACC_ELAP BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_CPU BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_ROW BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_BYTE BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_1ROW BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_DB2 BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_EXEC BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_WAIT BIGINT NOT NULL WITH DEFAULT,
  ACCEL_OFFLOAD_ELIGIBLE CHAR(1) NOT NULL WITH DEFAULT 'N',
  ACCELERATOR_NAME VARCHAR(128),
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT,
  STBLGRP VARCHAR(128) NOT NULL WITH DEFAULT,
  QUERY_HASH CHAR(16) FOR BIT DATA NOT NULL WITH DEFAULT,
  QUERY_HASH_VERSION INTEGER NOT NULL WITH DEFAULT -1,
  STABILIZED CHAR(1) NOT NULL WITH DEFAULT,
  APPLCOMPAT VARCHAR(10) NOT NULL WITH DEFAULT,
  CNO BIGINT NOT NULL WITH DEFAULT,
  STAT_SUS_CHILDLLOCK FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_OTHERLLOCK FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_PAGESETPLOCK FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_PAGEPLOCK FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_OTHERPLOCK FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_PIPE FLOAT NOT NULL WITH DEFAULT,
  STAT_SUS_PQSYNC FLOAT NOT NULL WITH DEFAULT,
  STAT_ACC_TWDP BIGINT NOT NULL WITH DEFAULT,
  STAT_ACC_NWDP BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_STATEMENT_CACHE_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STATEMENT_CACHE_TABLE TO WNSEL&
GRANT SELECT ON W3.DSN_STATEMENT_CACHE_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_STATEMNT_TABLE(
  "QUERYNO" INTEGER NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  STMT_TYPE CHAR(6) NOT NULL WITH DEFAULT,
  COST_CATEGORY CHAR(1) NOT NULL WITH DEFAULT,
  PROCMS INTEGER NOT NULL WITH DEFAULT,
  PROCSU INTEGER NOT NULL WITH DEFAULT,
  REASON VARCHAR(254) NOT NULL WITH DEFAULT,
  STMT_ENCODE CHAR(1) NOT NULL WITH DEFAULT,
  TOTAL_COST FLOAT NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  APCOMPARE_STATUS CHAR(1) NOT NULL WITH DEFAULT,
  APREUSE_STATUS CHAR(1) NOT NULL WITH DEFAULT,
  APREUSE_VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  APREUSE_COPYID INTEGER NOT NULL WITH DEFAULT -1,
  EXPLAIN_TYPE CHAR(1) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT,
  QUERY_HASH CHAR(16) FOR BIT DATA NOT NULL WITH DEFAULT,
  FUNCTION_LVL VARCHAR(10) NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT ALTER ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_STATEMNT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STATEMNT_TABLE TO WNSEL&
GRANT SELECT ON W3.DSN_STATEMNT_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_STRUCT_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  PARENT SMALLINT NOT NULL,
  TIMES FLOAT NOT NULL,
  ROWCOUNT INTEGER NOT NULL,
  ATOPEN CHAR(1) NOT NULL,
  CONTEXT CHAR(10) NOT NULL,
  ORDERNO SMALLINT NOT NULL,
  DOATOPEN_PARENT SMALLINT NOT NULL,
  QBLOCK_TYPE CHAR(6) NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  QUERY_STAGE CHAR(8) NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  ORIGIN CHAR(1) NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_STRUCT_TABLE TO YA1ZPM&
GRANT SELECT ON W3.DSN_STRUCT_TABLE TO WNSEL&
GRANT ALTER ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_STRUCT_TABLE TO W3
  WITH GRANT OPTION&
-- TABLES
CREATE TABLE W3.DSN_VIEWREF_TABLE(
  "QUERYNO" INTEGER NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  CREATOR VARCHAR(128) NOT NULL WITH DEFAULT,
  NAME VARCHAR(128) NOT NULL WITH DEFAULT,
  TYPE CHAR(1) NOT NULL WITH DEFAULT,
  MQTUSE SMALLINT NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_VIEWREF_TABLE TO YA1ZPM&
GRANT SELECT ON W3.DSN_VIEWREF_TABLE TO WNSEL&
GRANT ALTER ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_VIEWREF_TABLE TO W3
  WITH GRANT OPTION&
-- TABLES
CREATE TABLE W3.DSN_VIRTUAL_INDEXES(
  TBCREATOR VARCHAR(128) NOT NULL,
  TBNAME VARCHAR(128) NOT NULL,
  IXCREATOR VARCHAR(128) NOT NULL,
  IXNAME VARCHAR(128) NOT NULL,
  ENABLE CHAR(1) NOT NULL,
  MODE CHAR(1) NOT NULL,
  UNIQUERULE CHAR(1) NOT NULL,
  COLCOUNT SMALLINT NOT NULL,
  CLUSTERING CHAR(1) NOT NULL,
  NLEAF INTEGER NOT NULL,
  NLEVELS SMALLINT NOT NULL,
  INDEXTYPE CHAR(1) NOT NULL WITH DEFAULT,
  PGSIZE SMALLINT NOT NULL,
  FIRSTKEYCARDF FLOAT NOT NULL WITH DEFAULT -1,
  FULLKEYCARDF FLOAT NOT NULL WITH DEFAULT -1,
  CLUSTERRATIOF FLOAT NOT NULL WITH DEFAULT,
  "PADDED" CHAR(1) NOT NULL WITH DEFAULT,
  COLNO1 SMALLINT,
  ORDERING1 CHAR(1),
  COLNO2 SMALLINT,
  ORDERING2 CHAR(1),
  COLNO3 SMALLINT,
  ORDERING3 CHAR(1),
  COLNO4 SMALLINT,
  ORDERING4 CHAR(1),
  COLNO5 SMALLINT,
  ORDERING5 CHAR(1),
  COLNO6 SMALLINT,
  ORDERING6 CHAR(1),
  COLNO7 SMALLINT,
  ORDERING7 CHAR(1),
  COLNO8 SMALLINT,
  ORDERING8 CHAR(1),
  COLNO9 SMALLINT,
  ORDERING9 CHAR(1),
  COLNO10 SMALLINT,
  ORDERING10 CHAR(1),
  COLNO11 SMALLINT,
  ORDERING11 CHAR(1),
  COLNO12 SMALLINT,
  ORDERING12 CHAR(1),
  COLNO13 SMALLINT,
  ORDERING13 CHAR(1),
  COLNO14 SMALLINT,
  ORDERING14 CHAR(1),
  COLNO15 SMALLINT,
  ORDERING15 CHAR(1),
  COLNO16 SMALLINT,
  ORDERING16 CHAR(1),
  COLNO17 SMALLINT,
  ORDERING17 CHAR(1),
  COLNO18 SMALLINT,
  ORDERING18 CHAR(1),
  COLNO19 SMALLINT,
  ORDERING19 CHAR(1),
  COLNO20 SMALLINT,
  ORDERING20 CHAR(1),
  COLNO21 SMALLINT,
  ORDERING21 CHAR(1),
  COLNO22 SMALLINT,
  ORDERING22 CHAR(1),
  COLNO23 SMALLINT,
  ORDERING23 CHAR(1),
  COLNO24 SMALLINT,
  ORDERING24 CHAR(1),
  COLNO25 SMALLINT,
  ORDERING25 CHAR(1),
  COLNO26 SMALLINT,
  ORDERING26 CHAR(1),
  COLNO27 SMALLINT,
  ORDERING27 CHAR(1),
  COLNO28 SMALLINT,
  ORDERING28 CHAR(1),
  COLNO29 SMALLINT,
  ORDERING29 CHAR(1),
  COLNO30 SMALLINT,
  ORDERING30 CHAR(1),
  COLNO31 SMALLINT,
  ORDERING31 CHAR(1),
  COLNO32 SMALLINT,
  ORDERING32 CHAR(1),
  COLNO33 SMALLINT,
  ORDERING33 CHAR(1),
  COLNO34 SMALLINT,
  ORDERING34 CHAR(1),
  COLNO35 SMALLINT,
  ORDERING35 CHAR(1),
  COLNO36 SMALLINT,
  ORDERING36 CHAR(1),
  COLNO37 SMALLINT,
  ORDERING37 CHAR(1),
  COLNO38 SMALLINT,
  ORDERING38 CHAR(1),
  COLNO39 SMALLINT,
  ORDERING39 CHAR(1),
  COLNO40 SMALLINT,
  ORDERING40 CHAR(1),
  COLNO41 SMALLINT,
  ORDERING41 CHAR(1),
  COLNO42 SMALLINT,
  ORDERING42 CHAR(1),
  COLNO43 SMALLINT,
  ORDERING43 CHAR(1),
  COLNO44 SMALLINT,
  ORDERING44 CHAR(1),
  COLNO45 SMALLINT,
  ORDERING45 CHAR(1),
  COLNO46 SMALLINT,
  ORDERING46 CHAR(1),
  COLNO47 SMALLINT,
  ORDERING47 CHAR(1),
  COLNO48 SMALLINT,
  ORDERING48 CHAR(1),
  COLNO49 SMALLINT,
  ORDERING49 CHAR(1),
  COLNO50 SMALLINT,
  ORDERING50 CHAR(1),
  COLNO51 SMALLINT,
  ORDERING51 CHAR(1),
  COLNO52 SMALLINT,
  ORDERING52 CHAR(1),
  COLNO53 SMALLINT,
  ORDERING53 CHAR(1),
  COLNO54 SMALLINT,
  ORDERING54 CHAR(1),
  COLNO55 SMALLINT,
  ORDERING55 CHAR(1),
  COLNO56 SMALLINT,
  ORDERING56 CHAR(1),
  COLNO57 SMALLINT,
  ORDERING57 CHAR(1),
  COLNO58 SMALLINT,
  ORDERING58 CHAR(1),
  COLNO59 SMALLINT,
  ORDERING59 CHAR(1),
  COLNO60 SMALLINT,
  ORDERING60 CHAR(1),
  COLNO61 SMALLINT,
  ORDERING61 CHAR(1),
  COLNO62 SMALLINT,
  ORDERING62 CHAR(1),
  COLNO63 SMALLINT,
  ORDERING63 CHAR(1),
  COLNO64 SMALLINT,
  ORDERING64 CHAR(1),
  KEYTARGET_COUNT SMALLINT NOT NULL WITH DEFAULT,
  UNIQUE_COUNT SMALLINT NOT NULL WITH DEFAULT,
  IX_EXTENSION_TYPE CHAR(1) NOT NULL WITH DEFAULT,
  DATAREPEATFACTORF FLOAT NOT NULL WITH DEFAULT -1,
  SPARSE CHAR(1) NOT NULL WITH DEFAULT 'N'
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.DSN_VIRTUAL_INDEXES TO WNSEL&
GRANT SELECT ON W3.DSN_VIRTUAL_INDEXES TO YA1ZPM&
GRANT ALTER ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_VIRTUAL_INDEXES TO W3
  WITH GRANT OPTION&
-- TABLES
CREATE TABLE W3.PLAN_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  PLANNO SMALLINT NOT NULL,
  METHOD SMALLINT NOT NULL,
  CREATOR VARCHAR(128) NOT NULL,
  TNAME VARCHAR(128) NOT NULL,
  TABNO SMALLINT NOT NULL,
  ACCESSTYPE CHAR(2) NOT NULL,
  MATCHCOLS SMALLINT NOT NULL,
  ACCESSCREATOR VARCHAR(128) NOT NULL,
  ACCESSNAME VARCHAR(128) NOT NULL,
  INDEXONLY CHAR(1) NOT NULL,
  SORTN_UNIQ CHAR(1) NOT NULL,
  SORTN_JOIN CHAR(1) NOT NULL,
  SORTN_ORDERBY CHAR(1) NOT NULL,
  SORTN_GROUPBY CHAR(1) NOT NULL,
  SORTC_UNIQ CHAR(1) NOT NULL,
  SORTC_JOIN CHAR(1) NOT NULL,
  SORTC_ORDERBY CHAR(1) NOT NULL,
  SORTC_GROUPBY CHAR(1) NOT NULL,
  TSLOCKMODE CHAR(3) NOT NULL,
  TIMESTAMP CHAR(16) NOT NULL,
  REMARKS VARCHAR(762) NOT NULL,
  PREFETCH CHAR(1) NOT NULL WITH DEFAULT,
  COLUMN_FN_EVAL CHAR(1) NOT NULL WITH DEFAULT,
  MIXOPSEQ SMALLINT NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  ACCESS_DEGREE SMALLINT,
  ACCESS_PGROUP_ID SMALLINT,
  JOIN_DEGREE SMALLINT,
  JOIN_PGROUP_ID SMALLINT,
  SORTC_PGROUP_ID SMALLINT,
  SORTN_PGROUP_ID SMALLINT,
  PARALLELISM_MODE CHAR(1),
  MERGE_JOIN_COLS SMALLINT,
  CORRELATION_NAME VARCHAR(128),
  PAGE_RANGE CHAR(1) NOT NULL WITH DEFAULT,
  JOIN_TYPE CHAR(1) NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL WITH DEFAULT,
  IBM_SERVICE_DATA VARCHAR(254) FOR BIT DATA NOT NULL WITH DEFAULT,
  WHEN_OPTIMIZE CHAR(1) NOT NULL WITH DEFAULT,
  QBLOCK_TYPE CHAR(6) NOT NULL WITH DEFAULT,
  BIND_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  OPTHINT VARCHAR(128) NOT NULL WITH DEFAULT,
  HINT_USED VARCHAR(128) NOT NULL WITH DEFAULT,
  PRIMARY_ACCESSTYPE CHAR(1) NOT NULL WITH DEFAULT,
  PARENT_QBLOCKNO SMALLINT NOT NULL WITH DEFAULT,
  TABLE_TYPE CHAR(1),
  TABLE_ENCODE CHAR(1) NOT NULL WITH DEFAULT,
  TABLE_SCCSID SMALLINT NOT NULL WITH DEFAULT,
  TABLE_MCCSID SMALLINT NOT NULL WITH DEFAULT,
  TABLE_DCCSID SMALLINT NOT NULL WITH DEFAULT,
  ROUTINE_ID INTEGER NOT NULL WITH DEFAULT,
  CTEREF SMALLINT NOT NULL WITH DEFAULT,
  STMTTOKEN VARCHAR(240),
  PARENT_PLANNO SMALLINT NOT NULL WITH DEFAULT,
  BIND_EXPLAIN_ONLY CHAR(1) NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  MERGC CHAR(1) NOT NULL WITH DEFAULT,
  MERGN CHAR(1) NOT NULL WITH DEFAULT,
  SCAN_DIRECTION CHAR(1),
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT04&
-- GRANTS
GRANT SELECT ON W3.PLAN_TABLE TO WNSEL&
GRANT ALTER ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.PLAN_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.PLAN_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.DSN_FUNCTION_TABLE(
  "QUERYNO" INTEGER NOT NULL WITH DEFAULT,
  QBLOCKNO INTEGER NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  SCHEMA_NAME VARCHAR(128) NOT NULL WITH DEFAULT,
  FUNCTION_NAME VARCHAR(128) NOT NULL WITH DEFAULT,
  SPEC_FUNC_NAME VARCHAR(128) NOT NULL WITH DEFAULT,
  FUNCTION_TYPE CHAR(2) NOT NULL WITH DEFAULT,
  VIEW_CREATOR VARCHAR(128) NOT NULL WITH DEFAULT,
  VIEW_NAME VARCHAR(128) NOT NULL WITH DEFAULT,
  "PATH" VARCHAR(2048) NOT NULL WITH DEFAULT,
  FUNCTION_TEXT VARCHAR(1500) NOT NULL WITH DEFAULT,
  FUNC_VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  SECURE CHAR(1) NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT08&
-- GRANTS
GRANT SELECT ON W3.DSN_FUNCTION_TABLE TO WNSEL&
GRANT ALTER ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_FUNCTION_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_FUNCTION_TABLE TO YA1ZPM&
-- TABLES
CREATE TABLE W3.EPWD2MF_DS_BLAD(
  ID_AWIZA INTEGER NOT NULL,
  ID_PISMA INTEGER NOT NULL,
  TRESC VARCHAR(2000) NOT NULL,
  CZAS_ZASIL TIMESTAMP NOT NULL WITH DEFAULT
) IN BW301.SW3DSBLA&
-- GRANTS
GRANT SELECT ON W3.EPWD2MF_DS_BLAD TO YOWNRP&
GRANT SELECT ON W3.EPWD2MF_DS_BLAD TO YODZ01&
GRANT ALTER ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.EPWD2MF_DS_BLAD TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.EPWD2MF_DS_BLAD
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: 1.0'&
-- TABLES
CREATE TABLE W3.DS_ZLEC_EKSMOON(
  ID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WNIOSKU INTEGER NOT NULL,
  ID_POZYCJI INTEGER NOT NULL,
  ZNAK_PISMA_EPWD CHAR(30) NOT NULL,
  ID_CRS_DZIECKA INTEGER,
  DATA_WERYF_ORZ DATE NOT NULL,
  ROK_OD SMALLINT NOT NULL,
  IMIE_1 VARCHAR(60) NOT NULL,
  IMIE_2 VARCHAR(60),
  NAZWISKO VARCHAR(80) NOT NULL,
  PESEL CHAR(11),
  DATA_UR DATE,
  STAN_ZAPYTANIA INTEGER NOT NULL WITH DEFAULT 0,
  CZAS_UTW_ZAPYT TIMESTAMP NOT NULL WITH DEFAULT,
  CZAS_PRZETW_ZAPYT TIMESTAMP,
  CZAS_ODP_ZAPYT TIMESTAMP,
  STATUS_ODP INTEGER,
  DATA_ZLOZ_WN_ORZ DATE,
  DATA_WYDANIA_ORZ DATE,
  OKRES_WAZ_ORZ DATE,
  STOPIEN_NIEPEL INTEGER,
  CZY_DATA_COVID INTEGER
) IN BW301.SW3ZLEXM&
-- GRANTS
GRANT ALTER ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_ZLEC_EKSMOON TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ZLEC_EKSMOON TO YODZ01&
GRANT SELECT ON W3.DS_ZLEC_EKSMOON TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_ZLEC_EKSMOON
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: 1.0'&
-- TABLES
CREATE TABLE W3.DS_WNSK_R(
  DSIDWN INTEGER NOT NULL,
  DSWERSJA INTEGER NOT NULL,
  DSPODMIOT CHAR(1),
  DSINAZWAINSTYTUCJI VARCHAR(100),
  DSIREGON VARCHAR(14),
  DSOIMIE VARCHAR(30),
  DSONAZWISKO VARCHAR(40),
  DSOPESEL VARCHAR(11),
  DSNIP VARCHAR(10),
  DSKODPOCZT VARCHAR(10),
  DSMIEJSCOWOSC VARCHAR(56),
  DSULICA VARCHAR(100),
  DSBUDYNEK VARCHAR(9),
  DSLOKAL VARCHAR(10),
  DSSKRPOCZT VARCHAR(10),
  DSKRAJ VARCHAR(25),
  DSEMAIL VARCHAR(50),
  DSTELEFON VARCHAR(40),
  DSROKOD SMALLINT NOT NULL,
  DSROKDO SMALLINT NOT NULL,
  DSWPESEL VARCHAR(11),
  DSWRODZDOK CHAR(1),
  DSWNRDOK VARCHAR(9),
  DSWDATAUR DATE NOT NULL,
  DSWIMIE VARCHAR(30) NOT NULL,
  DSWNAZWISKO VARCHAR(40) NOT NULL,
  DSWSTANCYWILNYKOD CHAR(2) NOT NULL,
  DSWSTANCYWILNY VARCHAR(500) NOT NULL,
  DSWOBYWATELSTWOKOD CHAR(2) NOT NULL,
  DSWOBYWATELSTWO VARCHAR(60) NOT NULL,
  DSWULICA VARCHAR(100),
  DSWNRDOMU VARCHAR(12),
  DSWNRLOKALU VARCHAR(12),
  DSWKODPOCZT VARCHAR(6),
  DSWZAGRKODPOCZT VARCHAR(12),
  DSWMIEJSCOWOSC VARCHAR(56) NOT NULL,
  DSWGMINA VARCHAR(39),
  DSWGMINAKOD VARCHAR(7),
  DSWPOWIAT VARCHAR(36),
  DSWWOJEWODZTWO VARCHAR(36),
  DSWNAZWAPANSTWAKOD CHAR(2) NOT NULL,
  DSWNAZWAPANSTWA VARCHAR(30) NOT NULL,
  DSWTELEFON VARCHAR(19) NOT NULL,
  DSWEMAIL VARCHAR(50) NOT NULL,
  DSRNRRACHBANK VARCHAR(26) NOT NULL,
  DSDATA DATE
) IN BW301.SW3WNSKR&
-- GRANTS
GRANT SELECT ON W3.DS_WNSK_R TO YODZ01&
GRANT SELECT ON W3.DS_WNSK_R TO YOWNRP&
GRANT ALTER ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WNSK_R TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WNSK_R
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: 1.0'&
-- TABLES
CREATE TABLE W3.DS_PRAWO(
  ID_PRAWO INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  NR_KOL SMALLINT NOT NULL,
  WN_ID_CRS_CRI INTEGER,
  DZ_ID_CRS INTEGER NOT NULL,
  STATUS_PRAWA CHAR(1) NOT NULL,
  WYNIK CHAR(1) NOT NULL,
  GRUPA_TABDEC VARCHAR(50),
  ZRODLO CHAR(1) NOT NULL,
  PRACOWNIK CHAR(40),
  KWOTA_SWIAD DECIMAL(10,2),
  DATA_PRAWA DATE,
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  DTCZAS_ZMN TIMESTAMP NOT NULL,
  DATA_OKOL DATE NOT NULL,
  P_DATA_WYSLANIA DATE,
  P_DATA_DORECZENIA DATE,
  P_SYGNATURA VARCHAR(40),
  P_DATA_PISMA DATE,
  RACH_BANK CHAR(26) NOT NULL,
  STATUS_SP SMALLINT NOT NULL WITH DEFAULT 0,
  APROBANT CHAR(40)
) IN BW301.SW3DSPRA&
-- GRANTS
GRANT SELECT ON W3.DS_PRAWO TO YODZ01&
GRANT ALTER ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_PRAWO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_PRAWO TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_PRAWO
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_PRZYCZYNA(
  ID_PRAWO INTEGER NOT NULL,
  RODZAJ CHAR(1) NOT NULL,
  KOD_PRZYCZYNY SMALLINT NOT NULL,
  ZRODLO CHAR(1) NOT NULL,
  PRACOWNIK CHAR(40),
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  DTCZAS_ZMN TIMESTAMP NOT NULL
) IN BW301.SW3DSPRZ&
-- GRANTS
GRANT SELECT ON W3.DS_PRZYCZYNA TO YODZ01&
GRANT ALTER ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_PRZYCZYNA TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_PRZYCZYNA TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_PRZYCZYNA
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WARUNEK(
  ID_PRAWO INTEGER NOT NULL,
  KOD_WARUNKU SMALLINT NOT NULL,
  SYMBOL_WARTOSCI VARCHAR(15) NOT NULL,
  SPELNIONY CHAR(1),
  ZRODLO CHAR(1) NOT NULL,
  PRACOWNIK CHAR(40),
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  DTCZAS_ZMN TIMESTAMP NOT NULL,
  ID_PRAWO_INN INTEGER,
  ID_WN_INN INTEGER,
  NR_POZ_INN SMALLINT,
  RODZ_SWIAD_INN CHAR(3)
) IN BW301.SW3DSWAR&
-- GRANTS
GRANT SELECT ON W3.DS_WARUNEK TO YODZ01&
GRANT SELECT ON W3.DS_WARUNEK TO YOWNRP&
GRANT ALTER ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WARUNEK TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WARUNEK
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_MF2EPWD_BLAD(
  IDZAPISU INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  IDPISMAEPWD INTEGER NOT NULL,
  DATAUTWORZENIA TIMESTAMP NOT NULL,
  TYPWNIOSKU CHAR(10) NOT NULL,
  NRPOZYCJI SMALLINT,
  IDZLEC INTEGER,
  OPIS VARCHAR(4000)
) IN BW301.SW3DSMBL&
-- GRANTS
GRANT SELECT ON W3.DS_MF2EPWD_BLAD TO YODZ01&
GRANT SELECT ON W3.DS_MF2EPWD_BLAD TO YOWNRP&
GRANT ALTER ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_MF2EPWD_BLAD TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_MF2EPWD_BLAD
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_ORZECZ(
  ID_PRAWO INTEGER NOT NULL,
  DZ_ID_CRS INTEGER NOT NULL,
  SYMBOL_WARUNKU VARCHAR(20) NOT NULL,
  TYP_ORZECZ INTEGER,
  STOPIEN INTEGER,
  DT_ZLOZENIA DATE,
  DT_WYDANIA DATE NOT NULL,
  DT_WAZN DATE,
  DTCZAS_REJ TIMESTAMP NOT NULL
) IN BW301.SW3DSORZ&
-- GRANTS
GRANT ALTER ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_ORZECZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ORZECZ TO YOWNRP&
GRANT SELECT ON W3.DS_ORZECZ TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_ORZECZ
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WYPL_ZWR(
  ID_ZDARZENIA INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  RODZ_ZDARZENIA CHAR(1) NOT NULL,
  KWOTA DECIMAL(10,2) NOT NULL,
  ID_POST_EPWD INTEGER NOT NULL,
  DATA_ZDARZENIA DATE NOT NULL,
  ID_UPR INTEGER NOT NULL,
  ID_ODDZIALU INTEGER NOT NULL,
  ID_POZ_WYPL INTEGER NOT NULL,
  ID_SKL_WYPL INTEGER NOT NULL,
  STATUS_EPWD SMALLINT NOT NULL,
  CZAS_ZM_EPWD TIMESTAMP,
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  BLAD_EPWD VARCHAR(1000)
) IN BW301.SW3DSZWR&
-- GRANTS
GRANT ALTER ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WYPL_ZWR TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WYPL_ZWR TO YOWNRP&
GRANT SELECT ON W3.DS_WYPL_ZWR TO YODZ01&
-- COMMENTS
COMMENT ON TABLE W3.DS_WYPL_ZWR
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_NOT_PRAC(
  ID_NOT INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT,
  ID_PRAWO INTEGER,
  KOD_WARUNKU SMALLINT,
  DTCZAS_UTW TIMESTAMP NOT NULL WITH DEFAULT,
  PRACOWNIK CHAR(40) NOT NULL,
  NOTATKA VARCHAR(1000) NOT NULL
) IN BW301.SW3DSNOT&
-- GRANTS
GRANT ALTER ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_NOT_PRAC TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_NOT_PRAC TO YODZ01&
GRANT SELECT ON W3.DS_NOT_PRAC TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_NOT_PRAC
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_ADRES(
  ID_ADR INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  IDPISMAEPWD INTEGER NOT NULL,
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT,
  RODZ_ADR CHAR(1) NOT NULL,
  ULICA VARCHAR(100),
  NR_DOMU VARCHAR(12),
  NR_LOKALU VARCHAR(12),
  KOD_POCZT VARCHAR(6),
  ZAGR_KOD_POCZT VARCHAR(12),
  MIEJSCOWOSC VARCHAR(56) NOT NULL,
  GMINA VARCHAR(39),
  GMINA_KOD VARCHAR(7),
  POWIAT VARCHAR(36),
  WOJEWODZTWO VARCHAR(36),
  PANSTWO VARCHAR(30),
  PANSTWO_KOD CHAR(2),
  EMAIL VARCHAR(50),
  TELEFON VARCHAR(19),
  PRACOWNIK CHAR(40) NOT NULL,
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  NOTATKA VARCHAR(1024)
) IN BW301.SW3DSADR&
-- GRANTS
GRANT ALTER ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_ADRES TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ADRES TO YODZ01&
GRANT SELECT ON W3.DS_ADRES TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_ADRES
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_ZLEC_NFZ(
  ID INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WNIOSKU INTEGER NOT NULL,
  ID_POZYCJI INTEGER NOT NULL,
  ZNAK_PISMA_EPWD CHAR(30) NOT NULL,
  ROK_OD SMALLINT NOT NULL,
  PESEL CHAR(11) NOT NULL,
  STAN_ZAPYTANIA INTEGER NOT NULL WITH DEFAULT 0,
  CZAS_UTW_ZAPYT TIMESTAMP NOT NULL WITH DEFAULT,
  CZAS_PRZETW_ZAPYT TIMESTAMP,
  CZAS_ODP_ZAPYT TIMESTAMP,
  STATUS_ODP SMALLINT,
  ODP_NFZ SMALLINT
) IN BW301.SW3ZLNFZ&
-- GRANTS
GRANT SELECT ON W3.DS_ZLEC_NFZ TO YODZ01&
GRANT ALTER ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_ZLEC_NFZ TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_ZLEC_NFZ TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_ZLEC_NFZ
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - WER: BAZOWA'&
-- TABLES
CREATE TABLE W3.SW300A(
  PESEL_DZIECKA VARCHAR(11),
  DOK_TYP_DZIECKA VARCHAR(2),
  DOK_SERIA_NR_DZIECKA VARCHAR(20),
  IMIE_DZIECKA VARCHAR(100),
  NAZWISKO_DZIECKA VARCHAR(150),
  PESEL_UPRAW VARCHAR(11),
  DOK_TYP_UPRAW VARCHAR(2),
  DOK_SERIA_UPRAW VARCHAR(20),
  IMIE_UPRAW VARCHAR(100),
  NAZWISKO_UPRAW VARCHAR(150),
  DATA_UR_UPRAW DATE
) IN BW301.SW3300A&
-- GRANTS
GRANT SELECT ON W3.SW300A TO YOWNRP&
GRANT SELECT ON W3.SW300A TO YODZ01&
GRANT ALTER ON W3.SW300A TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.SW300A TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.SW300A TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.SW300A TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.SW300A TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.SW300A TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.SW300A
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_WZNOWIENIE(
  ID_WZN INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  ID_PRAWO INTEGER,
  ID_POST INTEGER NOT NULL,
  KOD_PRZYCZYNY SMALLINT NOT NULL,
  DATA_WZN DATE NOT NULL,
  DTCZAS_UTW TIMESTAMP NOT NULL WITH DEFAULT,
  PRACOWNIK CHAR(40) NOT NULL,
  SYGNATURA CHAR(40),
  TJO INTEGER,
  REFERENT CHAR(40),
  NOTATKA VARCHAR(1000)
) IN BW301.SW3DSWZN&
-- GRANTS
GRANT SELECT ON W3.DS_WZNOWIENIE TO YOWNRP&
GRANT SELECT ON W3.DS_WZNOWIENIE TO YODZ01&
GRANT ALTER ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_WZNOWIENIE TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_WZNOWIENIE
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DS_INF_SIO(
  ID_ZAPISU INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  ROK_SZK_OD SMALLINT NOT NULL,
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  DZ_ID_CRS INTEGER NOT NULL,
  DZ_IMIE VARCHAR(30),
  DZ_NAZWISKO VARCHAR(40),
  DZ_PESEL VARCHAR(11),
  DZ_NRDOK VARCHAR(9),
  DZ_DATAUR DATE,
  DATA_OD DATE NOT NULL,
  DATA_DO DATE NOT NULL,
  RSPO INTEGER,
  KLASA VARCHAR(30),
  NAUKA_OD DATE,
  NAUKA_DO DATE,
  STATUS_ODP SMALLINT NOT NULL,
  STATUS_EPWD SMALLINT,
  CZAS_ZM_EPWD TIMESTAMP,
  BLAD_EPWD VARCHAR(1000)
) IN BW301.SW3ZLSIO&
-- GRANTS
GRANT SELECT ON W3.DS_INF_SIO TO YOWNRP&
GRANT SELECT ON W3.DS_INF_SIO TO YODZ01&
GRANT ALTER ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_INF_SIO TO W3
  WITH GRANT OPTION&
-- COMMENTS
COMMENT ON TABLE W3.DS_INF_SIO
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: 1.0CO(1)'&
-- TABLES
CREATE TABLE W3.DS_TERYT_WNSK(
  ID_WN INTEGER NOT NULL,
  DATA_REJ TIMESTAMP NOT NULL,
  DATA_ZMIANY TIMESTAMP NOT NULL WITH DEFAULT,
  GMINA_KOD VARCHAR(7),
  KOD_PANSTWA CHAR(2),
  UZYTKOWNIK VARCHAR(64) NOT NULL WITH DEFAULT 'CBB'
) IN BW301.SW3DSTER&
-- GRANTS
GRANT SELECT ON W3.DS_TERYT_WNSK TO YODZ01&
GRANT ALTER ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_TERYT_WNSK TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_TERYT_WNSK TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_TERYT_WNSK
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
-- TABLES
CREATE TABLE W3.DSN_COLDIST_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  APPLNAME VARCHAR(128) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL,
  GROUP_MEMBER VARCHAR(128) NOT NULL,
  SECTNOI INTEGER NOT NULL,
  VERSION VARCHAR(122) NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  "SCHEMA" VARCHAR(128) NOT NULL,
  TBNAME VARCHAR(128) NOT NULL,
  NAME VARCHAR(128) NOT NULL,
  COLVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  TYPE CHAR(1) NOT NULL,
  CARDF FLOAT NOT NULL,
  COLGROUPCOLNO VARCHAR(254) FOR BIT DATA NOT NULL,
  NUMCOLUMNS SMALLINT NOT NULL,
  FREQUENCYF FLOAT NOT NULL,
  QUANTILENO SMALLINT NOT NULL,
  LOWVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  HIGHVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_COLDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_COLDIST_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_KEYTGTDIST_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  APPLNAME VARCHAR(128) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL,
  GROUP_MEMBER VARCHAR(128) NOT NULL,
  SECTNOI INTEGER NOT NULL,
  VERSION VARCHAR(122) NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  IXSCHEMA VARCHAR(128) NOT NULL,
  IXNAME VARCHAR(128) NOT NULL,
  KEYSEQ VARCHAR(128) NOT NULL,
  KEYVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  TYPE CHAR(1) NOT NULL,
  CARDF FLOAT NOT NULL,
  KEYGROUPKEYNO VARCHAR(254) FOR BIT DATA NOT NULL,
  NUMKEYS SMALLINT NOT NULL,
  FREQUENCYF FLOAT NOT NULL,
  QUANTILENO SMALLINT NOT NULL,
  LOWVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  HIGHVALUE VARCHAR(2000) FOR BIT DATA NOT NULL,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_KEYTGTDIST_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_KEYTGTDIST_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_PREDICATE_SELECTIVITY(
  "QUERYNO" INTEGER NOT NULL,
  QBLOCKNO SMALLINT NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  PREDNO INTEGER NOT NULL,
  INSTANCE SMALLINT NOT NULL,
  SELECTIVITY FLOAT NOT NULL,
  WEIGHT FLOAT NOT NULL,
  ASSUMPTION VARCHAR(128) NOT NULL,
  INSERT_TIME TIMESTAMP NOT NULL
    GENERATED ALWAYS
    FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP,
  EXPLAIN_TIME TIMESTAMP,
  REMARKS VARCHAR(762),
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT,
  PER_STMT_ID BIGINT NOT NULL WITH DEFAULT
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_PREDICATE_SELECTIVITY TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_PREDICATE_SELECTIVITY TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_QUERYINFO_TABLE(
  "QUERYNO" INTEGER NOT NULL WITH DEFAULT,
  QBLOCKNO SMALLINT NOT NULL WITH DEFAULT,
  QINAME1 VARCHAR(128) NOT NULL WITH DEFAULT,
  QINAME2 VARCHAR(128) NOT NULL WITH DEFAULT,
  APPLNAME VARCHAR(24) NOT NULL WITH DEFAULT,
  PROGNAME VARCHAR(128) NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  "COLLID" VARCHAR(128) NOT NULL WITH DEFAULT,
  GROUP_MEMBER VARCHAR(24) NOT NULL WITH DEFAULT,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  SEQNO INTEGER NOT NULL WITH DEFAULT,
  EXPLAIN_TIME TIMESTAMP NOT NULL WITH DEFAULT,
  TYPE CHAR(8) NOT NULL WITH DEFAULT,
  REASON_CODE SMALLINT NOT NULL WITH DEFAULT,
  QI_DATA CLOB NOT NULL WITH DEFAULT,
  SERVICE_INFO BLOB NOT NULL WITH DEFAULT,
  QB_INFO_ROWID ROWID NOT NULL GENERATED ALWAYS,
  EXPANSION_REASON CHAR(2) NOT NULL WITH DEFAULT
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_QUERYINFO_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_QUERYINFO_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_STAT_FEEDBACK(
  "QUERYNO" INTEGER NOT NULL,
  APPLNAME VARCHAR(24) NOT NULL,
  PROGNAME VARCHAR(128) NOT NULL,
  "COLLID" VARCHAR(128) NOT NULL,
  GROUP_MEMBER VARCHAR(24) NOT NULL,
  EXPLAIN_TIME TIMESTAMP NOT NULL,
  SECTNOI INTEGER NOT NULL WITH DEFAULT,
  VERSION VARCHAR(122) NOT NULL WITH DEFAULT,
  TBCREATOR VARCHAR(128) NOT NULL,
  TBNAME VARCHAR(128) NOT NULL,
  IXCREATOR VARCHAR(128) NOT NULL,
  IXNAME VARCHAR(128) NOT NULL,
  COLNAME VARCHAR(128) NOT NULL,
  NUMCOLUMNS SMALLINT NOT NULL,
  COLGROUPCOLNO VARCHAR(254) FOR BIT DATA NOT NULL,
  TYPE CHAR(1) NOT NULL,
  DBNAME VARCHAR(24) NOT NULL,
  TSNAME VARCHAR(24) NOT NULL,
  REASON CHAR(8) NOT NULL,
  REMARKS VARCHAR(254) NOT NULL
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_STAT_FEEDBACK TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_STAT_FEEDBACK TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_USERQUERY_TABLE(
  "QUERYNO" INTEGER NOT NULL,
  "SCHEMA" VARCHAR(128) NOT NULL WITH DEFAULT ' ',
  HINT_SCOPE SMALLINT NOT NULL WITH DEFAULT 0,
  QUERY_TEXT CLOB NOT NULL,
  QUERY_ROWID ROWID NOT NULL GENERATED ALWAYS,
  QUERYID BIGINT NOT NULL WITH DEFAULT 0,
  USERFILTER CHAR(8) NOT NULL WITH DEFAULT ' ',
  OTHER_OPTIONS CHAR(128) NOT NULL WITH DEFAULT ' ',
  "COLLECTION" VARCHAR(128) NOT NULL WITH DEFAULT ' ',
  "PACKAGE" VARCHAR(128) NOT NULL WITH DEFAULT ' ',
  VERSION VARCHAR(128) NOT NULL WITH DEFAULT ' ',
  REOPT CHAR(1) NOT NULL WITH DEFAULT ' ',
  STARJOIN CHAR(1) NOT NULL WITH DEFAULT ' ',
  MAX_PAR_DEGREE INTEGER NOT NULL WITH DEFAULT -1,
  DEF_CURR_DEGREE CHAR(3) NOT NULL WITH DEFAULT ' ',
  SJTABLES INTEGER NOT NULL WITH DEFAULT -1,
  OTHER_PARMS VARCHAR(128) NOT NULL WITH DEFAULT ' ',
  SELECTVTY_OVERRIDE CHAR(1) NOT NULL WITH DEFAULT 'N',
  ACCESSPATH_HINT CHAR(1) NOT NULL WITH DEFAULT ' ',
  OPTION_OVERRIDE CHAR(1) NOT NULL WITH DEFAULT ' '
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_USERQUERY_TABLE TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_USERQUERY_TABLE TO WNSEL&
-- TABLES
CREATE TABLE W3.DSN_VIRTUAL_KEYTARGETS(
  ENABLE CHAR(1) NOT NULL,
  IXNAME VARCHAR(128) NOT NULL,
  IXSCHEMA VARCHAR(128) NOT NULL,
  KEYSEQ SMALLINT NOT NULL WITH DEFAULT,
  COLNO SMALLINT NOT NULL WITH DEFAULT,
  ORDERING CHAR(1) NOT NULL,
  TYPESCHEMA VARCHAR(128) NOT NULL,
  TYPENAME VARCHAR(128) NOT NULL,
  LENGTH SMALLINT NOT NULL,
  LENGTH2 INTEGER NOT NULL,
  SCALE SMALLINT NOT NULL WITH DEFAULT,
  "NULLS" CHAR(1) NOT NULL WITH DEFAULT 'N',
  "CCSID" INTEGER NOT NULL,
  SUBTYPE CHAR(1) NOT NULL,
  DERIVED_FROM VARCHAR(4000) NOT NULL,
  CARDF FLOAT NOT NULL WITH DEFAULT -1
) IN BW301.SW3#PT08&
-- GRANTS
GRANT ALTER ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DSN_VIRTUAL_KEYTARGETS TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DSN_VIRTUAL_KEYTARGETS TO WNSEL&
-- TABLES
CREATE TABLE W3.DS_POG(
  ID_ZAPISU INTEGER NOT NULL
    GENERATED BY DEFAULT AS IDENTITY(
      START WITH 1,
      INCREMENT BY 1,
      NO CACHE
    ),
  IDPISMAWNIOSEK INTEGER NOT NULL,
  IDPISMAZAL INTEGER NOT NULL,
  ZALTYP VARCHAR(30) NOT NULL,
  DTCZAS_REJ TIMESTAMP NOT NULL WITH DEFAULT,
  DTWPLYWUZAL TIMESTAMP,
  TYPWNIOSKU CHAR(10) NOT NULL
) IN BW301.SW3DSPOG&
-- GRANTS
GRANT SELECT ON W3.DS_POG TO YODZ01&
GRANT ALTER ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT DELETE ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT INDEX ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT INSERT ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT UPDATE ON W3.DS_POG TO W3
  WITH GRANT OPTION&
GRANT SELECT ON W3.DS_POG TO YOWNRP&
-- COMMENTS
COMMENT ON TABLE W3.DS_POG
  IS 'WROBEL KRZYSZTOF - GDYNIA - PZPS - wer: BAZOWA'&
COMMIT&
-- AUXILARY TABLE
SET CURRENT SQLID = 'W3'&
CREATE AUX TABLE W3.DSN_QUERY_AUX
  IN BW301.SW3#PT31 STORES DSN_QUERY_TABLE
  COLUMN NODE_DATA&
CREATE AUX TABLE W3.DSN_STATEMENT_CACHE_AUX
  IN BW301.SW3#PT32 STORES DSN_STATEMENT_CACHE_TABLE
  COLUMN STMT_TEXT&
CREATE AUX TABLE W3.DSN_QUERYINFO_AUX
  IN BW301.SW3#PT33 STORES DSN_QUERYINFO_TABLE
  COLUMN QI_DATA&
CREATE AUX TABLE W3.DSN_QUERYINFO_AUX2
  IN BW301.SW3#PT34 STORES DSN_QUERYINFO_TABLE
  COLUMN SERVICE_INFO&
CREATE AUX TABLE W3.DSN_USERQUERY_TABLE_AUX
  IN BW301.SW3#PT35 STORES DSN_USERQUERY_TABLE
  COLUMN QUERY_TEXT&
COMMIT&
-- TEMPORARY TABLES
SET CURRENT SQLID = 'W3'&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WERYF(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  STATUS_POZ SMALLINT NOT NULL,
  DATA_ZLOZENIA DATE NOT NULL,
  TYP_WN CHAR(10),
  RODZAJ_WN CHAR(1),
  ID_CRS INTEGER,
  ID_CRS_CRI INTEGER,
  DZ_IDCRU INTEGER,
  WN_IDCRU INTEGER,
  WN_IDCZR INTEGER,
  WN_IDCRP INTEGER,
  WN_IMIE CHAR(30),
  WN_NAZWISKO CHAR(40),
  ROLA CHAR(1),
  ROKOD SMALLINT,
  ROKDO SMALLINT,
  DZ_IMIE CHAR(30),
  DZ_NAZWISKO CHAR(40),
  DZ_PESEL CHAR(11),
  DZ_DATAUR DATE,
  KWOTA_SWIAD DECIMAL(10,2),
  DATA_OKOL DATE,
  UPR_STATUS CHAR(1),
  UPR_ID INTEGER,
  UPR_WYNIK CHAR(1),
  UPR_DATA DATE,
  NR_KOL SMALLINT,
  ID_POST_EPWD INTEGER,
  ID_PISMA_EPWD INTEGER,
  NR_SPRAWY_EPWD CHAR(40),
  ZNAK_PISMA_EPWD CHAR(30),
  NR_RACH_BANK CHAR(26),
  PRACOWNIK CHAR(40),
  APROBANT CHAR(40),
  NAZWA_KONTA CHAR(64),
  UKR CHAR(1),
  UKR_WN CHAR(3),
  STATUS_ODP_EKSMOON SMALLINT,
  STATUS_ODP_NFZ SMALLINT,
  PAR_DT_ZLOZ_DO DATE,
  PAR_DT_POCZ_RSZ DATE
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_PACZKA(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  DSWPESEL CHAR(11),
  DSWRODZDOK CHAR(1),
  DSWNRDOK CHAR(9),
  DSWDATAUR DATE,
  DSWOBYWATELSTWOKOD CHAR(2),
  DSWNAZWAPANSTWAKOD CHAR(2),
  DSDPESEL CHAR(11),
  DSDDATAUR DATE,
  DSDRODZDOK CHAR(1),
  DSDNRDOK CHAR(9),
  DSSNAZWAPANSTWAKOD CHAR(2),
  DSDNIEPSPRTAK CHAR(1),
  DSDUCZDOSZKOLYTAK CHAR(1),
  DSDUCZDOZER CHAR(1),
  DSDUCZZAJRW CHAR(1),
  DSSPOWODKOD CHAR(2),
  PANSTWO_SZKOLA_WN CHAR(1),
  ZAL08 CHAR(1),
  ZAL09 CHAR(1),
  WIEK_DZ_ROCZ SMALLINT,
  WIEK_DZ DECIMAL(6,2),
  PLEC_WN CHAR(9),
  PLEC_DZ CHAR(9),
  STAN_CYWIL CHAR(1),
  OBYWATELSTWO_RU_KOD CHAR(3),
  TR_IMIE CHAR(22),
  TR_NAZWISKO CHAR(31),
  TR_NAZWISKO_R CHAR(31),
  TR_IMIE_OJCA CHAR(120),
  TR_NAZWISKO_R_OJCA CHAR(120),
  TR_IMIE_MATKI CHAR(120),
  TR_NAZWISKO_R_MATKI CHAR(120),
  TR_NAZWISKO_DZ CHAR(31)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_DANE_DOD(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  TYP CHAR(2),
  DATA_ZG DATE,
  ID_UPR INTEGER,
  TYP_ZMIANA CHAR(1),
  ZLEC CHAR(1),
  JEST_POG CHAR(1)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_PRZESLANKI(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  ROLA CHAR(1),
  POWOD CHAR(2),
  OBYWATELSTWO_WN CHAR(20),
  OBYWATELSTWO_RU CHAR(20),
  ZGODNOSC_OBYWAT CHAR(1),
  PANSTWO_WNSK CHAR(20),
  GRUPA_ROK CHAR(20),
  GRUPA_F CHAR(20),
  GRUPA_G CHAR(20),
  OSW_NIEPELNO CHAR(3),
  OSW_SZKO CHAR(3),
  OSW_ZER CHAR(3),
  OSW_ZAJ CHAR(3),
  PANSTWO_SZK_WN CHAR(20),
  PANSTWO_SZK_DZ CHAR(20),
  TERMIN CHAR(3),
  ZAL_NIEPELNO CHAR(3),
  ZAL_NAPRZ CHAR(3),
  PARENTYZACJA CHAR(3),
  ZGON_DZ CHAR(3),
  PLEC CHAR(1),
  UKR_WN CHAR(3),
  STAN_CYWIL CHAR(50)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WARUNKI_DOD(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  WERYFIKACJA CHAR(1) NOT NULL,
  WARUNEK_SYMBOL CHAR(30) NOT NULL,
  WYNIK_WER CHAR(3)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_PRZESLANKI_EPWD(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  RODZAJ CHAR(1),
  SYMBOL CHAR(20),
  WARTOSC CHAR(15),
  KOD_PRZYCZ INTEGER,
  WERYF_INNE_SYMBOL CHAR(30)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_DECYZJA(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  KOD_WYNIK CHAR(1),
  RODZ_DECYZJI CHAR(1)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_STATUS(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  STATUS SMALLINT
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WO_ORZECZ(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  DATA_WYDANIA_ORZ DATE NOT NULL,
  DATA_ZLOZENIA_ORZ DATE,
  DATA_WAZN_ORZ DATE,
  TYP_ORZECZ INTEGER,
  STOPIEN_NIEP INTEGER,
  CZAS_ODP_ZAPYT TIMESTAMP
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WARUNKI_POPRZEDNIE(
  ID_CRS_CRI INTEGER NOT NULL,
  SYMBOL CHAR(20) NOT NULL,
  P_ID_WN INTEGER,
  P_NR_POZ SMALLINT,
  P_ID_CRS INTEGER,
  P_ID_UPR INTEGER,
  P_RODZ_SWIAD CHAR(3),
  P_KOD_OKRES_SWIAD CHAR(2),
  P_TYP_WN CHAR(10),
  P_ROLA CHAR(2),
  P_STATUS SMALLINT,
  P_ZRODLO CHAR(1),
  P_DT_OD DATE,
  P_DT_DO DATE,
  P_DATA_ZMN DATE,
  P_DATA_ZMN_WAR DATE,
  P_DATA_ROZSTRZ DATE,
  P_ID_WN_INN INTEGER,
  P_NR_POZ_INN SMALLINT,
  P_ID_UPR_INN INTEGER,
  P_RODZ_SWIAD_INN CHAR(3)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WARUNKI_ZMIANA(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  SYMBOL CHAR(20) NOT NULL,
  WARTOSC CHAR(15),
  REF_ID_WN INTEGER,
  REF_NR_POZ SMALLINT,
  REF_ID_UPR INTEGER,
  REF_RODZ_SWIAD CHAR(3),
  KOD_PRZYCZ INTEGER
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_ODP_ZLEC(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  ODP_SG_Z CHAR(1),
  ODP_SG_D CHAR(1),
  ODP_UKR CHAR(1),
  ODP_PIECZA CHAR(1),
  ODP_EKSMOON CHAR(1),
  ODP_SG_POWOD CHAR(1),
  ODP_SG_DATA_WYJAZD DATE,
  ODP_SG_DATA_WJAZD DATE,
  ODP_SG_DTDO_UPRAW DATE,
  ODP_SG_NR_REJ CHAR(30),
  ODP_SG_WYKLUCZ CHAR(25),
  ODP_UKR_OPIEK CHAR(11),
  ODP_UKR_POKREW VARCHAR(50),
  ODP_PIECZA_ST CHAR(1),
  ODP_PIECZA_GR_PESEL CHAR(11),
  ODP_PIECZA_GR_NRDOK VARCHAR(30),
  ID_ZLEC_PIECZA INTEGER
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_PACZKA2(
  ID_CRS INTEGER NOT NULL,
  ID_CRS_CRI INTEGER NOT NULL,
  TYP CHAR(1) NOT NULL,
  MAX_ID_POZYCJA_S2 INTEGER
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_WERYF_WZAJEMNA(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  UPR_ID INTEGER,
  STATUS_POZ SMALLINT NOT NULL,
  ID_CRS INTEGER,
  DZ_IMIE CHAR(30),
  DZ_NAZWISKO CHAR(40),
  DZ_PESEL CHAR(11),
  UKR_DZ VARCHAR(3),
  ID_CRS_CRI INTEGER,
  ROLA CHAR(1),
  DATA_ZLOZENIA DATE NOT NULL,
  TYP_WN CHAR(10),
  WARUNEK_ZAM VARCHAR(15),
  WARUNEK_POBYT VARCHAR(15),
  JEST_POG CHAR(1) NOT NULL,
  PIERWSZY CHAR(1),
  OSTATNI CHAR(1),
  PIERWSZY_ID_WN INTEGER,
  PIERWSZY_NR_POZ SMALLINT,
  OSTATNI_ID_WN INTEGER,
  OSTATNI_NR_POZ SMALLINT
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_STATUS_NOWE(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  DZ_STATUS_NOWY SMALLINT NOT NULL,
  KWOTA_SWIAD DECIMAL(10,2),
  RODZAJ_UPR SMALLINT,
  KOREKTA CHAR(1) NOT NULL,
  SPOZNIONY CHAR(1) NOT NULL,
  INNY_PARA_NOWY_STATUS SMALLINT
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_INNY_PARA(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  INNY_PARA_ID_WN INTEGER,
  INNY_PARA_NR_POZ SMALLINT,
  INNY_PARA_STATUS SMALLINT,
  INNY_PARA_KWOTA DECIMAL(10,2),
  INNY_PARA_DATA DATE,
  INNY_PARA_DTDORECZ DATE,
  INNY_PARA_DTDORECZ_PLUS_DNI DATE,
  INNY_PARA_DTWYSL DATE,
  INNY_PARA_DTWYSL_PLUS_DNI DATE,
  INNY_PARA_PRAWO SMALLINT,
  INNY_PARA_UPR_ID INTEGER,
  INNY_PARA_DTPISMOPOPRZ DATE
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_INNY_DZIECKO(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  INNY_DZIECKO_ID_WN INTEGER,
  INNY_DZIECKO_NR_POZ SMALLINT,
  INNY_DZIECKO_STATUS SMALLINT,
  INNY_DZIECKO_UPR_ID INTEGER
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_INNY_WN(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  INNY_ZMIANA_PRZES CHAR(1)
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_BLEDY(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  ID_UPR INTEGER NOT NULL,
  KOD_BLEDU SMALLINT NOT NULL
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_BLEDY_3001(
  ID_UPR INTEGER NOT NULL
)&
CREATE GLOBAL TEMPORARY TABLE W3.GTCDSW_BLEDY_3007(
  ID_WN INTEGER NOT NULL,
  NR_POZ SMALLINT NOT NULL,
  ID_WN_POPRZ INTEGER NOT NULL,
  NR_POZ_POPRZ SMALLINT NOT NULL,
  ID_UPR_POPRZ INTEGER NOT NULL
)&
COMMIT&
-- ALIASES
SET CURRENT SQLID = 'W3'&
CREATE ALIAS W3.PESEL_OFA FOR PR.PESEL_OFA&
CREATE ALIAS W3.PESEL_SC FOR PR.PESEL_SC&
CREATE ALIAS W3.PESEL_ZM FOR PR.PESEL_ZM&
CREATE ALIAS W3.PESEL_OB FOR PR.PESEL_OB&
CREATE ALIAS W3.PESEL_AKTUAL FOR PR.PESEL_AKTUAL&
CREATE ALIAS W3.PESEL_SL FOR PR.PESEL_SL&
COMMIT&
-- INDEXES
SET CURRENT SQLID = 'W3'&
CREATE UNIQUE INDEX W3.CX_WNNAG
  ON W3.DS_WNSK_NAG(
  ID_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X1_WNNAG
  ON W3.DS_WNSK_NAG(
  IDPISMAEPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_WNNAG
  ON W3.DS_WNSK_NAG(
  WN_ID_CRS)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_NGPOZ
  ON W3.DS_NAG_POZ(
  ID_WN,
  NR_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_NGPOZ
  ON W3.DS_NAG_POZ(
  DATA_ZMIANY_ST)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSKD
  ON W3.DS_WNSK_D(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSKO
  ON W3.DS_WNSK_O(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSKS
  ON W3.DS_WNSK_S(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNDDZ
  ON W3.DS_WNSK_D_DZIECKO(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X1_WNDDZ
  ON W3.DS_WNSK_D_DZIECKO(
  DSIDWN,
  DSPOZYCJA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNDOP
  ON W3.DS_WNSK_D_OP(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNDZA
  ON W3.DS_WNSK_D_ZAL(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNDZA
  ON W3.DS_WNSK_D_ZAL(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNODZ
  ON W3.DS_WNSK_O_DZIECKO(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X1_WNODZ
  ON W3.DS_WNSK_O_DZIECKO(
  DSIDWN,
  DSPOZYCJA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNOOP
  ON W3.DS_WNSK_O_OP(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNOZA
  ON W3.DS_WNSK_O_ZAL(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNOZA
  ON W3.DS_WNSK_O_ZAL(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNRDC
  ON W3.DS_WNSK_R_DZIECKO(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X1_WNRDC
  ON W3.DS_WNSK_R_DZIECKO(
  DSIDWN,
  DSPOZYCJA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNROP
  ON W3.DS_WNSK_R_OP(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNRZA
  ON W3.DS_WNSK_R_ZAL(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNRZA
  ON W3.DS_WNSK_R_ZAL(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSOP
  ON W3.DS_WNSK_S_OP(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSZA
  ON W3.DS_WNSK_S_ZAL(
  DSID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNSZA
  ON W3.DS_WNSK_S_ZAL(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSWZM
  ON W3.DS_WNSK_ZMIANA(
  ID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSWZM
  ON W3.DS_WNSK_ZMIANA(
  ID_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSWZM
  ON W3.DS_WNSK_ZMIANA(
  TYP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSWZH
  ON W3.DS_WNSK_ZMIANA_HIST(
  ID_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSWZH
  ON W3.DS_WNSK_ZMIANA_HIST(
  TYP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 512 M&
CREATE UNIQUE INDEX W3.CX_DSMPO
  ON W3.DS_MF2EPWD_POZ(
  ID_ZLEC)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSMPO
  ON W3.DS_MF2EPWD_POZ(
  STATUS_EPWD,
  STATUS_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSN_DETCOST_TABLE
  ON W3.DSN_DETCOST_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_FILTER_TABLE
  ON W3.DSN_FILTER_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_PGRANGE_TABLE
  ON W3.DSN_PGRANGE_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_PGROUP_TABLE
  ON W3.DSN_PGROUP_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_PREDICAT_TABLE
  ON W3.DSN_PREDICAT_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_PTASK_TABLE
  ON W3.DSN_PTASK_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_QUERY_TABLE
  ON W3.DSN_QUERY_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X2_DSN_QUERY_TABLE
  ON W3.DSN_QUERY_TABLE(
  "QUERYNO",
  TYPE,
  QUERY_STAGE,
  EXPLAIN_TIME,
  SEQNO)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE CHANGED
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_SORTKEY_TABLE
  ON W3.DSN_SORTKEY_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_SORT_TABLE
  ON W3.DSN_SORT_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_STATEMENT_CACHE
  ON W3.DSN_STATEMENT_CACHE_TABLE(
  STMT_ID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X2_DSN_STATEMENT_CACHE
  ON W3.DSN_STATEMENT_CACHE_TABLE(
  STMT_TOKEN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X3_DSN_STATEMENT_CACHE
  ON W3.DSN_STATEMENT_CACHE_TABLE(
  EXPLAIN_TS)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_STATEMNT_TABLE
  ON W3.DSN_STATEMNT_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_STRUCT_TABLE
  ON W3.DSN_STRUCT_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_VIEWREF_TABLE
  ON W3.DSN_VIEWREF_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_VIRTUAL_INDEXES
  ON W3.DSN_VIRTUAL_INDEXES(
  ENABLE,
  MODE,
  TBCREATOR,
  TBNAME,
  IXCREATOR,
  IXNAME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X2_DSN_VIRTUAL_INDEXES
  ON W3.DSN_VIRTUAL_INDEXES(
  TBCREATOR,
  TBNAME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_PLAN_TABLE
  ON W3.PLAN_TABLE(
  "QUERYNO",
  BIND_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.X1_DSN_FUNCTION_TABLE
  ON W3.DSN_FUNCTION_TABLE(
  "QUERYNO",
  EXPLAIN_TIME)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE UNIQUE INDEX W3.X1_DSN_QUERY_AUX
  ON W3.DSN_QUERY_AUX
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 4 G&
CREATE UNIQUE INDEX W3.X1_DSN_STATEMENT_CACHE_AUX
  ON W3.DSN_STATEMENT_CACHE_AUX
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 5
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 4 G&
CREATE UNIQUE INDEX W3.CX_ZLEXM
  ON W3.DS_ZLEC_EKSMOON(
  ID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_ZLEXM
  ON W3.DS_ZLEC_EKSMOON(
  ID_WNIOSKU,
  ID_POZYCJI)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_ZLEXM
  ON W3.DS_ZLEC_EKSMOON(
  ID_CRS_DZIECKA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_WNSKR
  ON W3.DS_WNSK_R(
  DSIDWN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_NGPOZ
  ON W3.DS_NAG_POZ(
  DZ_ID_CRS,
  WN_ID_CRS_CRI)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_NGPOZ
  ON W3.DS_NAG_POZ(
  WN_ID_CRS_CRI,
  DZ_ID_CRS)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X3_WNNAG
  ON W3.DS_WNSK_NAG(
  ID_WN,
  TYP_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_WNNAG
  ON W3.DS_WNSK_NAG(
  STATUS_EPWD,
  STATUS_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X5_WNNAG
  ON W3.DS_WNSK_NAG(
  STATUS_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSPRA
  ON W3.DS_PRAWO(
  ID_PRAWO)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSPRA
  ON W3.DS_PRAWO(
  STATUS_SP,
  WN_ID_CRS_CRI,
  DZ_ID_CRS)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSPRZ
  ON W3.DS_PRZYCZYNA(
  ID_PRAWO,
  KOD_PRZYCZYNY)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSWAR
  ON W3.DS_WARUNEK(
  ID_PRAWO,
  KOD_WARUNKU)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 512 M&
CREATE UNIQUE INDEX W3.X1_DSWAR
  ON W3.DS_WARUNEK(
  ID_PRAWO,
  KOD_WARUNKU,
  SYMBOL_WARTOSCI)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 512 M&
CREATE UNIQUE INDEX W3.CX_DSMBL
  ON W3.DS_MF2EPWD_BLAD(
  IDZAPISU)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSMBL
  ON W3.DS_MF2EPWD_BLAD(
  IDPISMAEPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSORZ
  ON W3.DS_ORZECZ(
  ID_PRAWO)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSZWR
  ON W3.DS_WYPL_ZWR(
  ID_ZDARZENIA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSZWR
  ON W3.DS_WYPL_ZWR(
  ID_POST_EPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSZWR
  ON W3.DS_WYPL_ZWR(
  STATUS_EPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSNOT
  ON W3.DS_NOT_PRAC(
  ID_NOT)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSNOT
  ON W3.DS_NOT_PRAC(
  ID_WN,
  NR_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSMPO
  ON W3.DS_MF2EPWD_POZ(
  STATUS_EPWD,
  ID_ZLEC DESC)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSPRA
  ON W3.DS_PRAWO(
  ID_WN,
  NR_POZ,
  NR_KOL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_NGPOZ
  ON W3.DS_NAG_POZ(
  DZ_STATUS,
  ID_WN,
  NR_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X6_WNNAG
  ON W3.DS_WNSK_NAG(
  STATUS_EPWD,
  ID_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSADR
  ON W3.DS_ADRES(
  ID_ADR)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSADR
  ON W3.DS_ADRES(
  IDPISMAEPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_ZLNFZ
  ON W3.DS_ZLEC_NFZ(
  ID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_ZLNFZ
  ON W3.DS_ZLEC_NFZ(
  ID_WNIOSKU,
  ID_POZYCJI)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.CX_300A
  ON W3.SW300A(
  PESEL_UPRAW)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_300A
  ON W3.SW300A(
  PESEL_DZIECKA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSWZN
  ON W3.DS_WZNOWIENIE(
  ID_WZN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSWZN
  ON W3.DS_WZNOWIENIE(
  ID_WN,
  NR_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X7_WNNAG
  ON W3.DS_WNSK_NAG(
  WN_NAZWISKO,
  WN_IMIE)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X8_WNNAG
  ON W3.DS_WNSK_NAG(
  ZNAK_PISMA_EPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X5_NGPOZ
  ON W3.DS_NAG_POZ(
  DZ_PESEL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X6_NGPOZ
  ON W3.DS_NAG_POZ(
  DZ_NRDOK,
  DZ_RODZDOK)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_DSMPO
  ON W3.DS_MF2EPWD_POZ(
  ID_WN,
  NR_POZ)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X2_300A
  ON W3.SW300A(
  PESEL_DZIECKA,
  PESEL_UPRAW)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_ZLSIO
  ON W3.DS_INF_SIO(
  ID_ZAPISU)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_ZLSIO
  ON W3.DS_INF_SIO(
  DZ_ID_CRS)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X7_NGPOZ
  ON W3.DS_NAG_POZ(
  UPR_ID)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X1_DSTER
  ON W3.DS_TERYT_WNSK(
  ID_WN)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_DSN_PREDICAT_TABLE_IDX2
  ON W3.DSN_PREDICAT_TABLE(
  "QUERYNO",
  PREDNO)
  USING STOGROUP GW301 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 10
  GBPCACHE CHANGED
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 2 G&
CREATE INDEX W3.CX_DSN_PREDSEL_IX1
  ON W3.DSN_PREDICATE_SELECTIVITY(
  "QUERYNO")
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 0
  GBPCACHE NONE
  BUFFERPOOL BP40
  CLOSE YES
  PIECESIZE 2 G&
CREATE UNIQUE INDEX W3.CX_DSN_QUERYINFO_AUXINX
  ON W3.DSN_QUERYINFO_AUX
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 0
  GBPCACHE NONE
  BUFFERPOOL BP40
  CLOSE YES
  PIECESIZE 4 G&
CREATE UNIQUE INDEX W3.CX_DSN_QUERYINFO_AUXINX2
  ON W3.DSN_QUERYINFO_AUX2
  USING STOGROUP GW302 PRIQTY -1 SECQTY -1 ERASE NO
  FREEPAGE 0 PCTFREE 0
  GBPCACHE NONE
  BUFFERPOOL BP40
  CLOSE YES
  PIECESIZE 4 G&
CREATE UNIQUE INDEX W3.CX_DSN_USERQUERY_TABLE_IX1
  ON W3.DSN_USERQUERY_TABLE(
  "QUERYNO")
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 0 PCTFREE 0
  GBPCACHE NONE
  BUFFERPOOL BP40
  CLOSE YES
  PIECESIZE 2 G&
CREATE UNIQUE INDEX W3.X1_DSN_USERQUERY_TABLE_AUX_IX
  ON W3.DSN_USERQUERY_TABLE_AUX
  USING STOGROUP GW302 PRIQTY -1 SECQTY -1 ERASE NO
  FREEPAGE 0 PCTFREE 0
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 4 G&
CREATE INDEX W3.X2_ZLSIO
  ON W3.DS_INF_SIO(
  STATUS_EPWD)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.X3_DSZWR
  ON W3.DS_WYPL_ZWR(
  ID_ODDZIALU,
  DATA_ZDARZENIA,
  ID_POZ_WYPL,
  ID_SKL_WYPL,
  RODZ_ZDARZENIA)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNSKD
  ON W3.DS_WNSK_D(
  DSDPESEL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_WNSKD
  ON W3.DS_WNSK_D(
  DSPREGON)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_WNSKD
  ON W3.DS_WNSK_D(
  DSPNIP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_WNSKD
  ON W3.DS_WNSK_D(
  DSDNRDOK)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNSKO
  ON W3.DS_WNSK_O(
  DSWPESEL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_WNSKO
  ON W3.DS_WNSK_O(
  DSIREGON)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_WNSKO
  ON W3.DS_WNSK_O(
  DSNIP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_WNSKO
  ON W3.DS_WNSK_O(
  DSWNRDOK)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNSKR
  ON W3.DS_WNSK_R(
  DSWPESEL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_WNSKR
  ON W3.DS_WNSK_R(
  DSIREGON)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_WNSKR
  ON W3.DS_WNSK_R(
  DSNIP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_WNSKR
  ON W3.DS_WNSK_R(
  DSWNRDOK)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_WNSKS
  ON W3.DS_WNSK_S(
  DSWPESEL)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X2_WNSKS
  ON W3.DS_WNSK_S(
  DSIREGON)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X3_WNSKS
  ON W3.DS_WNSK_S(
  DSNIP)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X4_WNSKS
  ON W3.DS_WNSK_S(
  DSWNRDOK)
  USING STOGROUP GW302 PRIQTY 33120 SECQTY 33120 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE UNIQUE INDEX W3.CX_DSPOG
  ON W3.DS_POG(
  ID_ZAPISU)
  USING STOGROUP GW302 PRIQTY 13112 SECQTY 1312 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  CLUSTER
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
CREATE INDEX W3.X1_DSPOG
  ON W3.DS_POG(
  IDPISMAWNIOSEK)
  USING STOGROUP GW302 PRIQTY 15476 SECQTY 1548 ERASE NO
  FREEPAGE 10 PCTFREE 8
  GBPCACHE NONE
  BUFFERPOOL BP13
  CLOSE YES
  PIECESIZE 128 M&
COMMIT&
-- CHECK CONSTRAINTS
SET CURRENT SQLID = 'W3'&
ALTER TABLE W3.DSN_STATEMENT_CACHE_TABLE
  ADD CONSTRAINT ACCELERATED CHECK(
  "ACCELERATED"
      IN('ACCEL_ONLY',
                 'NO',
                            'NEVER',
                                       'YES'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT CLUSTERING CHECK(
  CLUSTERING IN ('Y', 'N'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT CLUSTERRATIOF CHECK(
  CLUSTERRATIOF >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLCOUNT CHECK(
  COLCOUNT > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO1 CHECK(
  COLNO1 IS NULL OR COLNO1 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO10 CHECK(
  COLNO10 IS NULL OR COLNO10 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO11 CHECK(
  COLNO11 IS NULL OR COLNO11 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO12 CHECK(
  COLNO12 IS NULL OR COLNO12 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO13 CHECK(
  COLNO13 IS NULL OR COLNO13 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO14 CHECK(
  COLNO14 IS NULL OR COLNO14 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO15 CHECK(
  COLNO15 IS NULL OR COLNO15 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO16 CHECK(
  COLNO16 IS NULL OR COLNO16 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO17 CHECK(
  COLNO17 IS NULL OR COLNO17 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO18 CHECK(
  COLNO18 IS NULL OR COLNO18 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO19 CHECK(
  COLNO19 IS NULL OR COLNO19 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO2 CHECK(
  COLNO2 IS NULL OR COLNO2 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO20 CHECK(
  COLNO20 IS NULL OR COLNO20 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO21 CHECK(
  COLNO21 IS NULL OR COLNO21 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO22 CHECK(
  COLNO22 IS NULL OR COLNO22 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO23 CHECK(
  COLNO23 IS NULL OR COLNO23 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO24 CHECK(
  COLNO24 IS NULL OR COLNO24 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO25 CHECK(
  COLNO25 IS NULL OR COLNO25 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO26 CHECK(
  COLNO26 IS NULL OR COLNO26 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO27 CHECK(
  COLNO27 IS NULL OR COLNO27 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO28 CHECK(
  COLNO28 IS NULL OR COLNO28 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO29 CHECK(
  COLNO29 IS NULL OR COLNO29 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO3 CHECK(
  COLNO3 IS NULL OR COLNO3 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO30 CHECK(
  COLNO30 IS NULL OR COLNO30 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO31 CHECK(
  COLNO31 IS NULL OR COLNO31 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO32 CHECK(
  COLNO32 IS NULL OR COLNO32 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO33 CHECK(
  COLNO33 IS NULL OR COLNO33 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO34 CHECK(
  COLNO34 IS NULL OR COLNO34 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO35 CHECK(
  COLNO35 IS NULL OR COLNO35 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO36 CHECK(
  COLNO36 IS NULL OR COLNO36 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO37 CHECK(
  COLNO37 IS NULL OR COLNO37 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO38 CHECK(
  COLNO38 IS NULL OR COLNO38 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO39 CHECK(
  COLNO39 IS NULL OR COLNO39 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO4 CHECK(
  COLNO4 IS NULL OR COLNO4 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO40 CHECK(
  COLNO40 IS NULL OR COLNO40 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO41 CHECK(
  COLNO41 IS NULL OR COLNO41 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO42 CHECK(
  COLNO42 IS NULL OR COLNO42 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO43 CHECK(
  COLNO43 IS NULL OR COLNO43 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO44 CHECK(
  COLNO44 IS NULL OR COLNO44 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO45 CHECK(
  COLNO45 IS NULL OR COLNO45 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO46 CHECK(
  COLNO46 IS NULL OR COLNO46 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO47 CHECK(
  COLNO47 IS NULL OR COLNO47 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO48 CHECK(
  COLNO48 IS NULL OR COLNO48 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO49 CHECK(
  COLNO49 IS NULL OR COLNO49 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO5 CHECK(
  COLNO5 IS NULL OR COLNO5 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO50 CHECK(
  COLNO50 IS NULL OR COLNO50 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO51 CHECK(
  COLNO51 IS NULL OR COLNO51 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO52 CHECK(
  COLNO52 IS NULL OR COLNO52 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO53 CHECK(
  COLNO53 IS NULL OR COLNO53 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO54 CHECK(
  COLNO54 IS NULL OR COLNO54 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO55 CHECK(
  COLNO55 IS NULL OR COLNO55 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO56 CHECK(
  COLNO56 IS NULL OR COLNO56 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO57 CHECK(
  COLNO57 IS NULL OR COLNO57 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO58 CHECK(
  COLNO58 IS NULL OR COLNO58 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO59 CHECK(
  COLNO59 IS NULL OR COLNO59 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO6 CHECK(
  COLNO6 IS NULL OR COLNO6 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO60 CHECK(
  COLNO60 IS NULL OR COLNO60 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO61 CHECK(
  COLNO61 IS NULL OR COLNO61 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO62 CHECK(
  COLNO62 IS NULL OR COLNO62 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO63 CHECK(
  COLNO63 IS NULL OR COLNO63 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO64 CHECK(
  COLNO64 IS NULL OR COLNO64 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO7 CHECK(
  COLNO7 IS NULL OR COLNO7 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO8 CHECK(
  COLNO8 IS NULL OR COLNO8 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT COLNO9 CHECK(
  COLNO9 IS NULL OR COLNO9 > 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ENABLE CHECK(
  ENABLE IN ('Y', 'N'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT FIRSTKEYCARDF CHECK(
  FIRSTKEYCARDF = -1 OR FIRSTKEYCARDF >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT FULLKEYCARDF CHECK(
  FULLKEYCARDF = -1 OR FULLKEYCARDF >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT INDEXTYPE CHECK(
  INDEXTYPE IN ('D', '2'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT MODE CHECK(
  MODE IN ('C', 'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT NLEAF CHECK(
  NLEAF = -1 OR NLEAF >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT NLEVELS CHECK(
  NLEVELS = -1 OR NLEVELS >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING1 CHECK(
  ORDERING1 IS NULL OR ORDERING1 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING10 CHECK(
  ORDERING10 IS NULL OR ORDERING10 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING11 CHECK(
  ORDERING11 IS NULL OR ORDERING11 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING12 CHECK(
  ORDERING12 IS NULL OR ORDERING12 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING13 CHECK(
  ORDERING13 IS NULL OR ORDERING13 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING14 CHECK(
  ORDERING14 IS NULL OR ORDERING14 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING15 CHECK(
  ORDERING15 IS NULL OR ORDERING15 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING16 CHECK(
  ORDERING16 IS NULL OR ORDERING16 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING17 CHECK(
  ORDERING17 IS NULL OR ORDERING17 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING18 CHECK(
  ORDERING18 IS NULL OR ORDERING18 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING19 CHECK(
  ORDERING19 IS NULL OR ORDERING19 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING2 CHECK(
  ORDERING2 IS NULL OR ORDERING2 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING20 CHECK(
  ORDERING20 IS NULL OR ORDERING20 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING21 CHECK(
  ORDERING21 IS NULL OR ORDERING21 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING22 CHECK(
  ORDERING22 IS NULL OR ORDERING22 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING23 CHECK(
  ORDERING23 IS NULL OR ORDERING23 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING24 CHECK(
  ORDERING24 IS NULL OR ORDERING24 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING25 CHECK(
  ORDERING25 IS NULL OR ORDERING25 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING26 CHECK(
  ORDERING26 IS NULL OR ORDERING26 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING27 CHECK(
  ORDERING27 IS NULL OR ORDERING27 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING28 CHECK(
  ORDERING28 IS NULL OR ORDERING28 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING29 CHECK(
  ORDERING29 IS NULL OR ORDERING29 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING3 CHECK(
  ORDERING3 IS NULL OR ORDERING3 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING30 CHECK(
  ORDERING30 IS NULL OR ORDERING30 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING31 CHECK(
  ORDERING31 IS NULL OR ORDERING31 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING32 CHECK(
  ORDERING32 IS NULL OR ORDERING32 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING33 CHECK(
  ORDERING33 IS NULL OR ORDERING33 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING34 CHECK(
  ORDERING34 IS NULL OR ORDERING34 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING35 CHECK(
  ORDERING35 IS NULL OR ORDERING35 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING36 CHECK(
  ORDERING36 IS NULL OR ORDERING36 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING37 CHECK(
  ORDERING37 IS NULL OR ORDERING37 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING38 CHECK(
  ORDERING38 IS NULL OR ORDERING38 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING39 CHECK(
  ORDERING39 IS NULL OR ORDERING39 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING4 CHECK(
  ORDERING4 IS NULL OR ORDERING4 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING40 CHECK(
  ORDERING40 IS NULL OR ORDERING40 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING41 CHECK(
  ORDERING41 IS NULL OR ORDERING41 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING42 CHECK(
  ORDERING42 IS NULL OR ORDERING42 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING43 CHECK(
  ORDERING43 IS NULL OR ORDERING43 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING44 CHECK(
  ORDERING44 IS NULL OR ORDERING44 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING45 CHECK(
  ORDERING45 IS NULL OR ORDERING45 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING46 CHECK(
  ORDERING46 IS NULL OR ORDERING46 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING47 CHECK(
  ORDERING47 IS NULL OR ORDERING47 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING48 CHECK(
  ORDERING48 IS NULL OR ORDERING48 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING49 CHECK(
  ORDERING49 IS NULL OR ORDERING49 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING5 CHECK(
  ORDERING5 IS NULL OR ORDERING5 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING50 CHECK(
  ORDERING50 IS NULL OR ORDERING50 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING51 CHECK(
  ORDERING51 IS NULL OR ORDERING51 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING52 CHECK(
  ORDERING52 IS NULL OR ORDERING52 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING53 CHECK(
  ORDERING53 IS NULL OR ORDERING53 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING54 CHECK(
  ORDERING54 IS NULL OR ORDERING54 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING55 CHECK(
  ORDERING55 IS NULL OR ORDERING55 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING56 CHECK(
  ORDERING56 IS NULL OR ORDERING56 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING57 CHECK(
  ORDERING57 IS NULL OR ORDERING57 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING58 CHECK(
  ORDERING58 IS NULL OR ORDERING58 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING59 CHECK(
  ORDERING59 IS NULL OR ORDERING59 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING6 CHECK(
  ORDERING6 IS NULL OR ORDERING6 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING60 CHECK(
  ORDERING60 IS NULL OR ORDERING60 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING61 CHECK(
  ORDERING61 IS NULL OR ORDERING61 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING62 CHECK(
  ORDERING62 IS NULL OR ORDERING62 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING63 CHECK(
  ORDERING63 IS NULL OR ORDERING63 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING64 CHECK(
  ORDERING64 IS NULL OR ORDERING64 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING7 CHECK(
  ORDERING7 IS NULL OR ORDERING7 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING8 CHECK(
  ORDERING8 IS NULL OR ORDERING8 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT ORDERING9 CHECK(
  ORDERING9 IS NULL OR ORDERING9 IN ('A',  'D'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT PADDED CHECK(
  PADDED IN (' ', 'Y', 'N'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT PGSIZE CHECK(
  PGSIZE IN (4, 8, 16, 32))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT UNIQUERULE CHECK(
  UNIQUERULE IN ('D', 'U'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT KEYTARGET_COUNT CHECK(
  KEYTARGET_COUNT >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT UNIQUE_COUNT CHECK(
  UNIQUE_COUNT >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT IX_EXTENSION_TYPE CHECK(
  IX_EXTENSION_TYPE IN(' ','S','V'))&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT DATAREPEATFACTORF CHECK(
  DATAREPEATFACTORF=-1 OR DATAREPEATFACTORF>=1 )&
ALTER TABLE W3.DSN_VIRTUAL_INDEXES
  ADD CONSTRAINT SPARSE CHECK(
  SPARSE IN('N','Y','X'))&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT CARDF CHECK(
  "CARDF" >= 0
         OR "CARDF" = -1
                    OR "CARDF" = -2)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT CCSID CHECK(
  "CCSID" >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT COLNO CHECK(
  "COLNO" >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT ENABLE CHECK(
  "ENABLE" IN ('Y', 'N'))&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT KEYSEQ CHECK(
  "KEYSEQ" >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT LENGTH CHECK(
  "LENGTH" > 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT LENGTH2 CHECK(
  "LENGTH2" >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT NULLS CHECK(
  "NULLS" IN ('Y', 'N'))&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT ORDERING CHECK(
  "ORDERING" IN ('A'))&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT SCALE CHECK(
  "SCALE" >= 0)&
ALTER TABLE W3.DSN_VIRTUAL_KEYTARGETS
  ADD CONSTRAINT SUBTYPE CHECK(
  "SUBTYPE"
         IN ('B', 'M', 'S', ' '))&
COMMIT&
-- PRIMARY KEYS
SET CURRENT SQLID = 'W3'&
ALTER TABLE W3.DS_WNSK_NAG ADD PRIMARY KEY(
  ID_WN)&
ALTER TABLE W3.DS_NAG_POZ ADD PRIMARY KEY(
  ID_WN,
  NR_POZ)&
ALTER TABLE W3.DS_WNSK_D ADD PRIMARY KEY(
  DSIDWN)&
ALTER TABLE W3.DS_WNSK_O ADD PRIMARY KEY(
  DSIDWN)&
ALTER TABLE W3.DS_WNSK_S ADD PRIMARY KEY(
  DSIDWN)&
ALTER TABLE W3.DS_WNSK_D_DZIECKO ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_D_OP ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_D_ZAL ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_O_DZIECKO ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_O_OP ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_O_ZAL ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_R_DZIECKO ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_R_OP ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_R_ZAL ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_S_OP ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_S_ZAL ADD PRIMARY KEY(
  DSID)&
ALTER TABLE W3.DS_WNSK_ZMIANA ADD PRIMARY KEY(
  ID)&
ALTER TABLE W3.DS_MF2EPWD_POZ ADD PRIMARY KEY(
  ID_ZLEC)&
ALTER TABLE W3.DS_ZLEC_EKSMOON ADD PRIMARY KEY(
  ID)&
ALTER TABLE W3.DS_WNSK_R ADD PRIMARY KEY(
  DSIDWN)&
ALTER TABLE W3.DS_PRAWO ADD PRIMARY KEY(
  ID_PRAWO)&
ALTER TABLE W3.DS_PRZYCZYNA ADD PRIMARY KEY(
  ID_PRAWO,
  KOD_PRZYCZYNY)&
ALTER TABLE W3.DS_WARUNEK ADD PRIMARY KEY(
  ID_PRAWO,
  KOD_WARUNKU)&
ALTER TABLE W3.DS_MF2EPWD_BLAD ADD PRIMARY KEY(
  IDZAPISU)&
ALTER TABLE W3.DS_WYPL_ZWR ADD PRIMARY KEY(
  ID_ZDARZENIA)&
ALTER TABLE W3.DS_NOT_PRAC ADD PRIMARY KEY(
  ID_NOT)&
ALTER TABLE W3.DS_ADRES ADD PRIMARY KEY(
  ID_ADR)&
ALTER TABLE W3.DS_ZLEC_NFZ ADD PRIMARY KEY(
  ID)&
ALTER TABLE W3.DS_WZNOWIENIE ADD PRIMARY KEY(
  ID_WZN)&
ALTER TABLE W3.DS_INF_SIO ADD PRIMARY KEY(
  ID_ZAPISU)&
ALTER TABLE W3.DSN_USERQUERY_TABLE ADD PRIMARY KEY(
  "QUERYNO")&
ALTER TABLE W3.DS_POG ADD PRIMARY KEY(
  ID_ZAPISU)&
COMMIT&
-- UNIQUE KEYS
-- FOREIGN KEYS
SET CURRENT SQLID = 'W3'&
ALTER TABLE W3.DS_NAG_POZ ADD FOREIGN KEY FK1NGPOZ(
    ID_WN)
  REFERENCES W3.DS_WNSK_NAG(
    ID_WN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_D ADD FOREIGN KEY FK1WNSKD(
    DSIDWN)
  REFERENCES W3.DS_WNSK_NAG(
    ID_WN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_O ADD FOREIGN KEY FK1WNSKO(
    DSIDWN)
  REFERENCES W3.DS_WNSK_NAG(
    ID_WN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_S ADD FOREIGN KEY FK1WNSKS(
    DSIDWN)
  REFERENCES W3.DS_WNSK_NAG(
    ID_WN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_D_DZIECKO ADD FOREIGN KEY FK1WNDDZ(
    DSIDWN)
  REFERENCES W3.DS_WNSK_D(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_D_OP ADD FOREIGN KEY FK1WNDOP(
    DSIDWN)
  REFERENCES W3.DS_WNSK_D(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_D_ZAL ADD FOREIGN KEY FK1WNDZA(
    DSIDWN)
  REFERENCES W3.DS_WNSK_D(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_O_DZIECKO ADD FOREIGN KEY FK1WNODZ(
    DSIDWN)
  REFERENCES W3.DS_WNSK_O(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_O_OP ADD FOREIGN KEY FK1WNOOP(
    DSIDWN)
  REFERENCES W3.DS_WNSK_O(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_O_ZAL ADD FOREIGN KEY FK1WNOZA(
    DSIDWN)
  REFERENCES W3.DS_WNSK_O(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_S_OP ADD FOREIGN KEY FK1WNSOP(
    DSIDWN)
  REFERENCES W3.DS_WNSK_S(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_S_ZAL ADD FOREIGN KEY FK1WNSZA(
    DSIDWN)
  REFERENCES W3.DS_WNSK_S(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_R ADD FOREIGN KEY FK1WNSKR(
    DSIDWN)
  REFERENCES W3.DS_WNSK_NAG(
    ID_WN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_R_DZIECKO ADD FOREIGN KEY FK1WNRDC(
    DSIDWN)
  REFERENCES W3.DS_WNSK_R(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_R_OP ADD FOREIGN KEY FK1WNROP(
    DSIDWN)
  REFERENCES W3.DS_WNSK_R(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WNSK_R_ZAL ADD FOREIGN KEY FK1WNRZA(
    DSIDWN)
  REFERENCES W3.DS_WNSK_R(
    DSIDWN) ON DELETE RESTRICT&
ALTER TABLE W3.DS_PRZYCZYNA ADD FOREIGN KEY FK1DSPRZ(
    ID_PRAWO)
  REFERENCES W3.DS_PRAWO(
    ID_PRAWO) ON DELETE RESTRICT&
ALTER TABLE W3.DS_WARUNEK ADD FOREIGN KEY FK1DSWAR(
    ID_PRAWO)
  REFERENCES W3.DS_PRAWO(
    ID_PRAWO) ON DELETE RESTRICT&
COMMIT&
-- TRIGGERS
SET CURRENT SQLID = 'W3'&
SET CURRENT PATH =
  "W3"&
CREATE TRIGGER W3.TR_DS_WYPL_ZWR_I AFTER INSERT ON
DS_WYPL_ZWR REFERENCING NEW AS NV FOR EACH ROW MODE
DB2SQL WHEN (NV.RODZ_ZDARZENIA = 'W') INSERT INTO
DS_WNSK_ZMIANA (ID_WN, TYP) VALUES
(NV.ID_ZDARZENIA, 'wyplata')
&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER W3.TR_DS_ZLEC_NFZ_I
AFTER INSERT ON DS_ZLEC_NFZ
REFERENCING NEW AS NOWY
FOR EACH ROW MODE DB2SQL
WHEN
( NOWY.STAN_ZAPYTANIA = 0 )
UPDATE DS_ZLEC_NFZ
SET STAN_ZAPYTANIA    = 2,
STATUS_ODP        = 0,
CZAS_PRZETW_ZAPYT = CURRENT_TIMESTAMP,
CZAS_ODP_ZAPYT    = CURRENT_TIMESTAMP
WHERE ID = NOWY.ID
&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR_DS_WNSK_NAG_U
 AFTER UPDATE OF STATUS_WN ON DS_WNSK_NAG
 REFERENCING OLD AS OV NEW AS NV
 FOR EACH ROW MODE DB2SQL
 WHEN ( NV.STATUS_WN IN (1,13,98,99) )
  INSERT INTO DS_WNSK_ZMIANA (
   ID_WN,
   TYP,
   NOWY_STATUS,
   STARY_STATUS
  ) VALUES (
   OV.ID_WN,
   'wniosek_status',
   NV.STATUS_WN,
   OV.STATUS_WN
  )


&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR_DS_NAG_POZ_I
 AFTER INSERT ON DS_NAG_POZ
 REFERENCING NEW AS NOWY
 FOR EACH ROW MODE DB2SQL
 WHEN
  ( NOWY.STATUS_EPWD = 1 )
  INSERT INTO DS_MF2EPWD_POZ (
    ID_WN
   ,NR_POZ
   ,TYP_WN
   ,IDPISMAEPWD
   ,STATUS_POZ
   ,STATUS_EPWD
   ,DTCZAS_UTW
  )
  SELECT
    NOWY.ID_WN,
    NOWY.NR_POZ,
    WN.TYP_WN,
    WN.IDPISMAEPWD,
    NOWY.DZ_STATUS,
    1,
    CURRENT TIMESTAMP
  FROM DS_WNSK_NAG WN
  WHERE WN.ID_WN = NOWY.ID_WN


&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR_DS_NAG_POZ_U
 AFTER UPDATE OF STATUS_EPWD ON DS_NAG_POZ
 REFERENCING OLD AS POPRZ NEW AS NOWY
 FOR EACH ROW MODE DB2SQL
 WHEN
  (
   NOWY.STATUS_EPWD = 1 AND
   VALUE(POPRZ.STATUS_EPWD,0) <> 1
  )
  INSERT INTO DS_MF2EPWD_POZ (
    ID_WN
   ,NR_POZ
   ,TYP_WN
   ,IDPISMAEPWD
   ,STATUS_POZ
   ,STATUS_EPWD
   ,DTCZAS_UTW
  )
  SELECT
    NOWY.ID_WN,
    NOWY.NR_POZ,
    WN.TYP_WN,
    WN.IDPISMAEPWD,
    NOWY.DZ_STATUS,
    1,
    CURRENT TIMESTAMP
  FROM DS_WNSK_NAG WN
  WHERE WN.ID_WN = NOWY.ID_WN

&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR2_DS_NAG_POZ_I
 AFTER INSERT ON DS_NAG_POZ
 REFERENCING NEW AS NV
 FOR EACH ROW MODE DB2SQL
  INSERT INTO DS_WNSK_ZMIANA (
    ID_WN,
    TYP
  ) VALUES (
    NV.ID_WN,
    'wniosek'
  )

&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR2_DS_NAG_POZ_U
 AFTER UPDATE OF DZ_STATUS ON DS_NAG_POZ
 REFERENCING OLD AS OV NEW AS NV
 FOR EACH ROW MODE DB2SQL
  WHEN ( NV.DZ_STATUS IN (42,43) )
  INSERT INTO DS_WNSK_ZMIANA (
   ID_WN,
   NR_POZ,
   TYP,
   NOWY_STATUS,
   STARY_STATUS
  ) VALUES (
   OV.ID_WN,
   OV.NR_POZ,
   'dz_status',
   NV.DZ_STATUS,
   OV.DZ_STATUS
  )

&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR3_DS_NAG_POZ_U
 AFTER UPDATE OF STATUS_EPWD ON DS_NAG_POZ
 REFERENCING OLD AS OV NEW AS NV
 FOR EACH ROW MODE DB2SQL
  WHEN ( NV.STATUS_EPWD = 4 AND OV.DZ_STATUS IN
(40,41) )
  INSERT INTO DS_WNSK_ZMIANA (
   ID_WN,
   NR_POZ,
   TYP,
   NOWY_STATUS,
   STARY_STATUS
  ) VALUES (
   OV.ID_WN,
   OV.NR_POZ,
   'dz_status',
   NV.DZ_STATUS,
   OV.DZ_STATUS
  )

&
SET CURRENT PATH =
  "W3"&
CREATE
TRIGGER TR_DS_WNSK_ZMIANA_D
 AFTER DELETE ON DS_WNSK_ZMIANA
 REFERENCING OLD AS OV
 FOR EACH ROW MODE DB2SQL
  INSERT INTO DS_WNSK_ZMIANA_HIST (
   ID,
   ID_WN,
   NR_POZ,
   TYP,
   NOWY_STATUS,
   STARY_STATUS,
   CZAS_OPERACJI
  ) VALUES (
   OV.ID,
   OV.ID_WN,
   OV.NR_POZ,
   OV.TYP,
   OV.NOWY_STATUS,
   OV.STARY_STATUS,
   OV.CZAS_OPERACJI
  )


&
COMMIT&
-- SYNONYMS
SET CURRENT SQLID = 'W3'&
CREATE SYNONYM DOKZR_BLAD
  FOR PD.DOKZR_BLAD&
CREATE SYNONYM DOKZR_BL_DCRBA
  FOR PD.DOKZR_BL_DCRBA&
CREATE SYNONYM DOKZR_BL_DCRZA
  FOR PD.DOKZR_BL_DCRZA&
CREATE SYNONYM DOKZR_BL_ZSWA
  FOR PD.DOKZR_BL_ZSWA&
CREATE SYNONYM DOKZR_NAGL_DP
  FOR PD.DOKZR_NAGL_DP&
CREATE SYNONYM T_DOKCZAS
  FOR PD.T_DOKCZAS&
CREATE SYNONYM S9_INST_DANE_PDST
  FOR PH.S9_INST_DANE_PDST&
CREATE SYNONYM T_IDENTYFWDNZ
  FOR PD.T_IDENTYFWDNZ&
CREATE SYNONYM KCFOFE
  FOR PC.KCFOFE&
CREATE SYNONYM KCRODZ
  FOR PC.KCRODZ&
CREATE SYNONYM KDUBIDCZR
  FOR PC.KDUBIDCZR&
CREATE SYNONYM KHISTZGON
  FOR PC.KHISTZGON&
CREATE SYNONYM KKWKLNTWZCZR
  FOR PC.KKWKLNTWZCZR&
CREATE SYNONYM KKLIENTCZR
  FOR PC.KKLIENTCZR&
CREATE SYNONYM KKLIENT
  FOR PC.KKLIENT&
CREATE SYNONYM KKLIENTWZCZR
  FOR PC.KKLIENTWZCZR&
CREATE SYNONYM KKLIENTWZ
  FOR PC.KKLIENTWZ&
CREATE SYNONYM KPLATNIK
  FOR PC.KPLATNIK&
CREATE SYNONYM KKUBUPL
  FOR PC.KKUBUPL&
CREATE SYNONYM KKWKLNTCZR
  FOR PC.KKWKLNTCZR&
CREATE SYNONYM KKWKLNTWZ
  FOR PC.KKWKLNTWZ&
CREATE SYNONYM KMASTER
  FOR PC.KMASTER&
CREATE SYNONYM KMKLIENT
  FOR PC.KMKLIENT&
CREATE SYNONYM KMPLAT
  FOR PC.KMPLAT&
CREATE SYNONYM KOUBZP
  FOR PC.KOUBZP&
CREATE SYNONYM KDPLID
  FOR PC.KDPLID&
CREATE SYNONYM KPWPLAT
  FOR PC.KPWPLAT&
CREATE SYNONYM KDUBID
  FOR PC.KDUBID&
CREATE SYNONYM KKWKLNT
  FOR PC.KKWKLNT&
CREATE SYNONYM DOKOR_ZUSZIUA
  FOR PD.DOKOR_ZUSZIUA&
CREATE SYNONYM DOKOR_ZUSRIA
  FOR PD.DOKOR_ZUSRIA&
CREATE SYNONYM DOKOR_ZUSZWUA
  FOR PD.DOKOR_ZUSZWUA&
CREATE SYNONYM DOKOR_ZUSZUA
  FOR PD.DOKOR_ZUSZUA&
CREATE SYNONYM DOKOR_ZUSZZA
  FOR PD.DOKOR_ZUSZZA&
CREATE SYNONYM S9_OSF_POZYCJA_OS
  FOR PH.S9_OSF_POZYCJA_OS&
CREATE SYNONYM S9_OSF_UZUP_EWID
  FOR PH.S9_OSF_UZUP_EWID&
CREATE SYNONYM T_PPDZIAL
  FOR PC.T_PPDZIAL&
CREATE SYNONYM PARTYCJA_SD
  FOR PF.PARTYCJA_SD&
CREATE SYNONYM T_ZGLOSZDOUB
  FOR PC.T_ZGLOSZDOUB&
CREATE SYNONYM REGON_JLA
  FOR PR.REGON_JLA&
CREATE SYNONYM REGON_JPA
  FOR PR.REGON_JPA&
CREATE SYNONYM REGON_OFA
  FOR PR.REGON_OFA&
CREATE SYNONYM S_ADRES_PRZEK
  FOR SL.S_ADRES_PRZEK&
CREATE SYNONYM S_ID_GEN_MODULO
  FOR PF.S_ID_GEN_MODULO&
CREATE SYNONYM S_ID_GEN_PART_MAP
  FOR PF.S_ID_GEN_PART_MAP&
CREATE SYNONYM SL_OSWIADCZENIE
  FOR SL.SL_OSWIADCZENIE&
CREATE SYNONYM SL_POUCZENIE
  FOR SL.SL_POUCZENIE&
CREATE SYNONYM SL_POWOD_UCZACA_SIE
  FOR SL.SL_POWOD_UCZACA_SIE&
CREATE SYNONYM SL_ROLA
  FOR SL.SL_ROLA&
CREATE SYNONYM SL_RODZAJ_SZKOLY
  FOR SL.SL_RODZAJ_SZKOLY&
CREATE SYNONYM SL_STAN_CYWILNY
  FOR SL.SL_STAN_CYWILNY&
CREATE SYNONYM T_SPANSTW
  FOR SL.T_SPANSTW&
CREATE SYNONYM SROD_KOL
  FOR PC.SROD_KOL&
CREATE SYNONYM SRODOWISKA
  FOR PC.SRODOWISKA&
CREATE SYNONYM S_STER_IDENT
  FOR PC.S_STER_IDENT&
CREATE SYNONYM S_TYTUB_IDENT
  FOR PC.S_TYTUB_IDENT&
CREATE SYNONYM T_IDENT_PARAM
  FOR PC.T_IDENT_PARAM&
CREATE SYNONYM T_SPARAMETRY
  FOR PC.T_SPARAMETRY&
CREATE SYNONYM T_SRODZAJPARAMETRU
  FOR PC.T_SRODZAJPARAMETRU&
CREATE SYNONYM UNIQUE_ID_DEC_P
  FOR PF.UNIQUE_ID_DEC_P&
CREATE SYNONYM UNIQUE_ID
  FOR PC.UNIQUE_ID&
CREATE SYNONYM T_IDENTYFWDNZU
  FOR PC.T_IDENTYFWDNZU&
CREATE SYNONYM DOKZR_ZUSOSW
  FOR PD.DOKZR_ZUSOSW&
CREATE SYNONYM ZAPBAZ_LOG
  FOR PC.ZAPBAZ_LOG&
CREATE SYNONYM DOKZR_ZUSRIA
  FOR PD.DOKZR_ZUSRIA&
CREATE SYNONYM DOKZR_ZUSZAA
  FOR PD.DOKZR_ZUSZAA&
CREATE SYNONYM DOKZR_ZUSZBA
  FOR PD.DOKZR_ZUSZBA&
CREATE SYNONYM DOKZR_ZUSZCZA
  FOR PD.DOKZR_ZUSZCZA&
CREATE SYNONYM DOKZR_ZUSZFA
  FOR PD.DOKZR_ZUSZFA&
CREATE SYNONYM DOKZR_ZUSZIPA
  FOR PD.DOKZR_ZUSZIPA&
CREATE SYNONYM DOKZR_ZUSZIUA
  FOR PD.DOKZR_ZUSZIUA&
CREATE SYNONYM DOKZR_ZUSZPA
  FOR PD.DOKZR_ZUSZPA&
CREATE SYNONYM DOKZR_ZUSZSWA
  FOR PD.DOKZR_ZUSZSWA&
CREATE SYNONYM DOKZR_ZUSZUA
  FOR PD.DOKZR_ZUSZUA&
CREATE SYNONYM DOKZR_ZUSZWPA
  FOR PD.DOKZR_ZUSZWPA&
CREATE SYNONYM DOKZR_ZUSZWUA
  FOR PD.DOKZR_ZUSZWUA&
CREATE SYNONYM DOKZR_ZUSZZA
  FOR PD.DOKZR_ZUSZZA&
CREATE SYNONYM DS_SL_GRWIEK
  FOR SL.DS_SL_GRWIEK&
CREATE SYNONYM SL_RODZAJ_ORZECZENIA
  FOR SL.SL_RODZAJ_ORZECZENIA&
CREATE SYNONYM DS_SL_PRZYCZYNA_WARUNEK
  FOR SL.DS_SL_PRZYCZYNA_WAR&
CREATE SYNONYM DS_SL_PRZYCZYNA
  FOR SL.DS_SL_PRZYCZYNA&
CREATE SYNONYM SL_RODZAJ_ZALACZNIKA
  FOR SL.SL_RODZAJ_ZALACZNIKA&
CREATE SYNONYM DS_SL_WARUNEK
  FOR SL.DS_SL_WARUNEK&
CREATE SYNONYM DS_SL_WARTOSC_WARUNKU
  FOR SL.DS_SL_WARTOSC_WAR&
CREATE SYNONYM DOKZR_ZUSZCNA
  FOR PD.DOKZR_ZUSZCNA&
CREATE SYNONYM DS_SL_KODY
  FOR SL.DS_SL_KODY&
CREATE SYNONYM DS_SL_PARSYS
  FOR SL.DS_SL_PARSYS&
CREATE SYNONYM DS_SL_PARAM
  FOR SL.DS_SL_PARAM&
CREATE SYNONYM S2_DS_INTERFEJS
  FOR WN.S2_DS_INTERFEJS&
CREATE SYNONYM WO_ORZECZENIE
  FOR PL.WO_ORZECZENIE&
CREATE SYNONYM WO_ORZECZENIE_SZCZ
  FOR PL.WO_ORZECZENIE_SZCZ&
CREATE SYNONYM RP_STRONA
  FOR PH.RP_STRONA&
CREATE SYNONYM S2_DODATKI_DO_SW
  FOR PH.S2_DODATKI_DO_SW&
CREATE SYNONYM S2_PODMIOT
  FOR PH.S2_PODMIOT&
CREATE SYNONYM S2_UPRAWNIENIE
  FOR PH.S2_UPRAWNIENIE&
CREATE SYNONYM S9_S_BANKI
  FOR SL.S9_S_BANKI&
CREATE SYNONYM DS_SL_TABDEC
  FOR SL.DS_SL_TABDEC&
CREATE SYNONYM T_SDZIENWOLNY
  FOR PF.T_SDZIENWOLNY&
CREATE SYNONYM SSP_ZLEC_SG
  FOR W5.SSP_ZLEC_SG&
CREATE SYNONYM SSP_ODP_PIECZA
  FOR W5.SSP_ODP_PIECZA&
CREATE SYNONYM SSP_NAG_POZ
  FOR W5.SSP_NAG_POZ&
CREATE SYNONYM SSP_SL_PARSYS
  FOR SL.SSP_SL_PARSYS&
CREATE SYNONYM SSP_WARUNEK
  FOR W5.SSP_WARUNEK&
CREATE SYNONYM SSP_SL_WARUNEK
  FOR SL.SSP_SL_WARUNEK&
CREATE SYNONYM SSP_ZLEC_PIECZA
  FOR W5.SSP_ZLEC_PIECZA&
CREATE SYNONYM SSP_ZLEC_UKR
  FOR W5.SSP_ZLEC_UKR&
CREATE SYNONYM SSP_WN_ZM_NAG
  FOR W5.SSP_WN_ZM_NAG&
CREATE SYNONYM SL_SW_OKRES_SWIAD
  FOR SL.SL_SW_OKRES_SWIAD&
CREATE SYNONYM SSP_WNSK_NAG
  FOR W5.SSP_WNSK_NAG&
CREATE SYNONYM SSP_DOK_POBYT
  FOR W5.SSP_DOK_POBYT&
CREATE SYNONYM SSP_WNSK_O
  FOR W5.SSP_WNSK_O&
CREATE SYNONYM SSP_WNSK_R
  FOR W5.SSP_WNSK_R&
CREATE SYNONYM SSP_WNSK_SW_U
  FOR W5.SSP_WNSK_SW_U&
CREATE SYNONYM SSP_WNSK_RKO_O
  FOR W5.SSP_WNSK_RKO_O&
CREATE SYNONYM SSP_WNSK_RKO_R
  FOR W5.SSP_WNSK_RKO_R&
CREATE SYNONYM SSP_WNSK_RKO_U
  FOR W5.SSP_WNSK_RKO_U&
CREATE SYNONYM DS_SL_RODZ_ZAL
  FOR SL.DS_SL_RODZ_ZAL&
CREATE SYNONYM KEP_OFA
  FOR PR.KEP_OFA&
CREATE SYNONYM KEP_ORA
  FOR PR.KEP_ORA&
COMMIT&
-- VIEWS
-- ROUTINES
-- EROUTINES
-- SEQUENCES
-- ALTER
SET CURRENT SQLID = 'W3'&
ALTER TABLE DS_INF_SIO ALTER COLUMN ID_ZAPISU
  RESTART WITH 12207780&
COMMIT&
--#SET TERMINATOR