/********************************************************************************* ** ** Source: NCR Documentation ** Data Dictionary ** Release V2R6.1 ** B035-1092-115A ** November 2005 ** ** Author of statements: Ulrich Arndt - www.data2knowledge.de ** ulrich.arndt@data2knowledge.de ** ** First written: 2006/02/15 ** 2006/03/16 Add comments/corrections of Mike Dempsey ** ** NO WARRANTY ON CORRECTNESS AND COMPLETENESS OF THIS SCRIPT AND IT CONTENT! ** ***********************************************************************************/ CREATE TABLE TABLEKIND_V2R61_REF ( TABLEKIND CHAR(2) NOT NULL, TABLEKIND_DESC VARCHAR(10000) NOT NULL ) UNIQUE PRIMARY INDEX (TABLEKIND); INSERT INTO TABLEKIND_V2R61_REF VALUES ('A','AGGREGATE UDF'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('B','COMBINED AGGREGATE AND ORDERED ANALYTICAL FUNCTION'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('E','EXTERNAL STORED PROCEDURE'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('F','SCALAR UDF'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('G','TRIGGER'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('H','INSTANCE OR CONSTRUCTOR METHOD'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('I','JOIN INDEX'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('J','JOURNAL'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('M','MACRO'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('N','HASH INDEX'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('P','STORED PROCEDURE'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('Q','QUEUE TABLE'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('R','TABLE FUNCTION'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('S','ORDERED ANALYTICAL FUNCTION'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('T','TABLE'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('U','USER-DEFINED DATA TYPE'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('V','VIEW'); INSERT INTO TABLEKIND_V2R61_REF VALUES ('X','AUTHORIZATION'); COLLECT STATS TABLEKIND_V2R61_REF INDEX (TABLEKIND); CREATE VIEW V_TABLEKIND_REF AS SELECT TABLEKIND, TABLEKIND_DESC FROM TABLEKIND_V2R61_REF; /* CHECK IF CURRENTLY COMPLET */ SELECT T.TABLEKIND FROM DBC.TABLES T WHERE NOT EXISTS (SELECT * FROM V_TABLEKIND_REF R WHERE R.TABLEKIND = T.TABLEKIND ) GROUP BY TABLEKIND ORDER BY TABLEKIND ;