zOs/SQL/CREDBQQ
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBAF (810) Extract time : 2006-09-21 15:45 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=N UF=N SP=N SQ=N --
-- Grants : SG=N DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Database DGDB9998 --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Database=QQ01A1A Stogroup=GSMS
------------------------------------------------------------------------
--
drop DATABASE qq99A1A;
commit;
CREATE DATABASE qq99A1A
BUFFERPOOL BP2
INDEXBP BP1
CCSID EBCDIC
STOGROUP GSMS;
-- Tablespace=qq99A1A.A051A
------------------------------------------------------------------------
--
CREATE TABLESPACE A051A
IN qq99A1A
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=OA1A.TQQ051A In qq99A1A.A051A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TQQ051A
(QQ051TXT CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
QQ051ID CHAR(10) FOR SBCS DATA NOT NULL,
QQ051FOR CHAR(10) FOR SBCS DATA WITH DEFAULT NULL)
IN qq99A1A.A051A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=qq99A1A
-- Index=OA1A.IQQ051A0 On OA1A.TQQ051A
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.IQQ051A0
ON OA1A.TQQ051A
(QQ051ID ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","s100447" ;
--
CREATE VIEW OA1A.VQQ051V1 AS
SELECT *
FROM OA1A.TQQ051A ;
--
------------------------------------------------------------------------
-- View=OA1A.VQQ051V2
------------------------------------------------------------------------
--
--
CREATE VIEW OA1A.VQQ051V2 AS
SELECT *
FROM OA1A.TQQ051A ;
--
CREATE VIEW OA1A.VQQ051VA1 AS
SELECT *
FROM OA1A.TQQ051A ;
--
CREATE VIEW OA1A.VQQ051VA2 AS
SELECT *
FROM OA1A.TQQ051A ;