Hi, thanks for your reply. Unfortunately I can't find information on this in the online docs. Could you, please, point me to some relevant piece of documentation?
Thanks again! Alex > 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] > -- +++ 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]
