Generate table script problems

[blom0344]

Anyone know why this causes error when run in command center:

CREATE TABLE target.BAY (
SIT_SITE_ID VARCHAR (4) NOT NULL,
ZON_ID VARCHAR (3) NOT NULL,
BAY_ID VARCHAR (3) NOT NULL,
BAY_STATUS VARCHAR (2),
BAY_DATE_HELD DATE,
BAY_TIME_HELD TIME,
BAY_DESCRIPTION VARCHAR (30),
BAY_SEQUENCE INTEGER (10),
BAY_ROUTE VARCHAR (2),
BAY_TASK_REQUIRED VARCHAR (1),
PRIMARY KEY ( SIT_SITE_ID, ZON_ID, BAY_ID ))

The error is caused by the INTEGER(10) , changing it to DECIMAL (10,0) will erase the error and will create the table. Afterwards I can change the DECIMAL setting to INTEGER with no problem !!!!!!!
Running scripts in the script window of command center gives ALWAYS error messages , while the identical script runs faultlessly in the interactive pane ...... T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[blom0344]

Ai,

Solved, should be INTEGER instead of INTEGER(10).

Sorry. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com