isql -a ${base_} -user ${user_} -pass ${pass_}  -o ${ddl_file} 2>${err_f}

/* Table: CALENDAR_, Owner: Owner */
CREATE TABLE CALENDAR_ (
        DATE_ BAS$DATE NOT NULL,
        BANKS_DAY BAS$BOOL default 1,
        YEAR_ COMPUTED BY (extract(year from date_)),
        QUARTER_ COMPUTED BY ((cast(ceil(cast(extract(month from cast(DATE_ as date)) as double precision)/3.0) as smallint))),
        MONTH_ COMPUTED BY (extract(month from date_)),
        DAY_OF_MONTH COMPUTED BY (extract(day from date_)),
        DAY_OF_YEAR COMPUTED BY (cast((extract(yearday from date_)+1)as smallint)),
CONSTRAINT PK_CALENDAR PRIMARY KEY (DATE_));

/* Table: CALENDAR_, Owner: Owner */
CREATE TABLE CALENDAR_ (
        DATE_ BAS$DATE NOT NULL,
        BANKS_DAY BAS$BOOL default 1,
        YEAR_ SMALLINT COMPUTED BY (NULL),
        QUARTER_ SMALLINT COMPUTED BY (NULL),
        MONTH_ SMALLINT COMPUTED BY (NULL),
        DAY_OF_MONTH SMALLINT COMPUTED BY (NULL),
        DAY_OF_YEAR SMALLINT COMPUTED BY (NULL),
CONSTRAINT PK_CALENDAR PRIMARY KEY (DATE_));

ALTER TABLE CALENDAR_
        ALTER YEAR_ TYPE SMALLINT COMPUTED BY (extract(year from date_)),
        ALTER QUARTER_ TYPE SMALLINT COMPUTED BY ((cast(ceil(cast(extract(month from cast(DATE_ as timestamp)) as double precision)/3.0) as smallint))),
        ALTER MONTH_ TYPE SMALLINT COMPUTED BY (extract(month from date_)),
        ALTER DAY_OF_MONTH TYPE SMALLINT COMPUTED BY (extract(day from date_)),
        ALTER DAY_OF_YEAR TYPE SMALLINT COMPUTED BY (cast((extract(yearday from date_)+1)as smallint));