/*******************************************************************************
The next statement causes the following error:

Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
ACCTYPE_ID.
At line 5, column 18.
*******************************************************************************/
CREATE TRIGGER ACCTYPE_BI FOR ACCTYPE
ACTIVE BEFORE INSERT POSITION  0 
AS
BEGIN
  IF (ACCTYPE_ID IS NULL) THEN
    NEW.ACCTYPE_ID = GEN_ID(GEN_ACCTYPE_ACCTYPE_ID,  1 );
END^

CREATE TABLE ACCTYPE (
    ACCTYPE_ID BIGINT NOT NULL,
    ACCTYPE VARCHAR( 15 ));