SET SQL DIALECT 1;

/* Domain definitions */
CREATE DOMAIN CAPCODE AS VARCHAR(10);
CREATE DOMAIN ISCHAR AS CHAR(4)
    DEFAULT 'NUM'
    CHECK(VALUE = 'NUM' OR VALUE = 'CHAR');
CREATE DOMAIN RESERVENO1 AS VARCHAR(14);
CREATE DOMAIN RESERVENO2 AS VARCHAR(14);
CREATE DOMAIN TERMID AS SMALLINT;
CREATE DOMAIN TERMMODEL AS VARCHAR(15)
    DEFAULT '-';
CREATE DOMAIN TERMNO AS VARCHAR(10)
    DEFAULT '-';

/* Table: TERM_TBL, Owner: SYSDBA */

CREATE TABLE TERM_TBL
(
  TERM_ID    TERMID NOT NULL,
  TERM_NO    TERMNO NOT NULL,
  CAPCODE    CAPCODE NOT NULL,
  TERM_MODEL    TERMMODEL NOT NULL,
  IS_CHAR    ISCHAR NOT NULL,
  RESERVE_NO1    RESERVENO1,
  RESERVE_NO2    RESERVENO2,
UNIQUE (CAPCODE),
CONSTRAINT TERM_NO PRIMARY KEY (TERM_NO)
);

CREATE GENERATOR TERM_ID_GEN;
SET TERM ^ ;


/* Triggers only will work for SQL triggers */

CREATE TRIGGER SET_TERM_ID FOR TERM_TBL
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
   new.term_id = gen_id(term_id_gen, 1);
END
^

COMMIT WORK ^
SET TERM ;^

/* Grant Roles for this database */

GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TERM_TBL TO PUBLIC WITH

//===========================================
이렇게 하니까 이상없이 만들어지는데요..
즐프하세요.......