Neoview SQL Reference Manual (R2.3)

, EMPL_ADDRESS VARCHAR(50) CHARACTER SET ISO88591 NO DEFAULT -- NOT NULL
, DEPT_NO INT NO DEFAULT -- NOT NULL
, SALARY NUMERIC(10, 2) DEFAULT 1000.00
, CONSTRAINT SCH.EMPL_836528881_1454 PRIMARY KEY (EMPL_NO ASC)
, CONSTRAINT SCH.EMPL_314277881_1454 CHECK (SCH.EMPL.EMPL_NO IS NOT
NULL AND SCH.EMPL.EMPL_NAME IS NOT NULL AND SCH.EMPL.EMPL_ADDRESS
IS NOT NULL AND SCH.EMPL.DEPT_NO IS NOT NULL)
)
HASH PARTITION BY (EMPL_NO)
MAX TABLE SIZE 2000
;
CREATE INDEX EMPL_DEPT_NO ON SCH.EMPL
(
DEPT_NO ASC
)
HASH PARTITION (DEPT_NO)
;
ALTER TABLE SCH.EMPL
ADD CONSTRAINT SCH.EMPL_SALARY_CHECK CHECK (SCH.EMPL.SALARY >= 1000)
DROPPABLE;
ALTER TABLE SCH.EMPL
ADD CONSTRAINT SCH.EMPL_DEPT_NO_CHECK CHECK (SCH.EMPL.DEPT_NO > 0)
DROPPABLE;
CREATE TRIGGER SCH.DEPT_TRIG AFTER UPDATE ON SCH.EMPL REFERENCING OLD
AS OLDROW, NEW AS NEWROW FOR EACH ROW WHEN (OLDROW.DEPT_NO <> NEWROW.DEPT_NO)
INSERT INTO SCH.DEPT VALUES (OLDROW.EMPL_NO, 'new dept');
-- Table has an IUD log.
GRANT SELECT ON TABLE SCH.EMPL TO PUBLIC;
GRANT DELETE ON TABLE SCH.EMPL TO “role_user1” WITH GRANT OPTION;
GRANT REFERENCES (C2) ON TABLE SCH.EMPL TO “role_user4”;
-- showddl on materialized view
SHOWDDL EMPL_MV, PRIVILEGES
-- showddl output
CREATE MATERIALIZED VIEW SCH.EMPL_MV
AS SELECT max(SCH.EMPL.SALARY) AS SALARY, SCH.EMPL.DEPT_NO AS DEPT_NO
FROM SCH.EMPL GROUP BY SCH.EMPL.DEPT_NO;
-- The system added the following columns to the select list:
-- count(*) AS SYS_COUNTSTAR1
-- count(SCH.EMPL.SALARY) AS SYS_COUNT2
-- showddl on dept table
SHOWDDL DEPT, PRIVILEGES
-- showddl output
-- Schema level privileges
-- GRANT SELECT ON SCHEMA SCH TO “ROLE.READER”;
CREATE TABLE SCH.DEPT
(
DEPT_NO INT NO DEFAULT -- NOT NULL
, DEPT_NAME VARCHAR(20) CHARACTER SET ISO88591 NO DEFAULT -- NOT NULL
, CONSTRAINT SCH.DEPT_849937374_7746 PRIMARY KEY (DEPT_NO ASC)
, CONSTRAINT SCH.DEPT_985137374_7746 CHECK (SCH.DEPT.DEPT_NO IS NOT
NULL AND SCH.DEPT.DEPT_NAME IS NOT NULL)
)
HASH PARTITION BY (DEPT_NO)
178 SQL Statements