Hello Alex, The type to use for long binary data is not BLOB, it is LONG BYTE. Apparantly the statement was more for Oracle, not for MaxDB/SAP DB.
Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: "Alex B�r" [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 23, 2004 12:50 PM > To: [EMAIL PROTECTED] > Subject: missing delimiter error in CREATE TABLE for BLOB type column > > > Hi everyone, > > I have been given the SQL statement below. I was told that it > was created > for SAP-DB, but I don't know for which version. In MaxDB it > won't work. > Error message: > > "Error: com.sap.dbtech.jdbc.exceptions.DatabaseException: > [-5016] (at 257): > Missing delimiter: )" > > Here's the SQL statement: > > CREATE TABLE TPERSON ("PKEY" INTEGER NOT NULL, "FIRSTNAME" > VARCHAR (25), > "LASTNAME" VARCHAR (25), "LOGINNAME" VARCHAR (10) NOT NULL, > "EMAIL" VARCHAR > (60), "PASSWD" VARCHAR (80), "PHONE" VARCHAR (18), "DEPKEY" INTEGER, > "VALIDUNTIL" DATE, "PREFERENCES" BLOB SUB_TYPE 1, "LASTEDIT" > TIMESTAMP, > "DELETED" CHAR (1) default 'N', PRIMARY KEY(PKEY)) > > Position 257 is the first letter of "SUB_TYPE". > > Could anyone tell me what's wrong with the statement? > > Thanks! > > > Alex > > -- > +++ Jetzt WLAN-Router f�r alle DSL-Einsteiger und Wechsler +++ > GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
