teradata table

Database
Enthusiast

teradata table

Hi all ;
Here is the error : please help me with this , 3707 :syntax,error expected something like '(' between the word 'd_clm_bipd' and the 'no' keyword.

CREATE SET TABLE OPMI4HIST_SBOXT.POLICIES , NO FALLBACK ,

NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
POL_NBR INTEGER,
ACTV_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
ACTV_DT TIMESTAMP(6) NOT NULL,
LST_UPDT_DT TIMESTAMP(6) NOT NULL,
LST_UPDT_INIT_NM CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
INAC_DT TIMESTAMP(6) NOT NULL,
OBSERVATION_START_DTTM TIMESTAMP(6) NOT NULL,
OBSERVATION_END_DTTM TIMESTAMP(6) NOT NULL,
LOADSQNC INTEGER,
)
PRIMARY INDEX( POL_NBR );

1 REPLY
Enthusiast

Re: teradata table

there should be no LOADSQNC INTEGER,
comma at the end of the word integer