Re: create table

[Nick Roper]

OK, got it!

Combination of missing parentheses and a missing ',' after the last column definition.

Now try:

CREATE TABLE TEST.LdgrMaster
( LD_ACCTID char (10) NOT NULL
,LD_DTEKEYED_YMD char (8) NOT NULL
,LD_LEDCTR char (5) NOT NULL
,LD_AGNT char (4) NULL
,LD_TIME char (4) NULL,

PRIMARY KEY (LD_ACCTID ,LD_DTEKEYED_YMD ,LD_LEDCTR)

) TYPE=MYISAM;

Works for me :-)





--
Nick Roper