Alex, you may also create an alias for "long byte", at least for SAPDB 7.4:
create domain BLOB long byte Now you can use BLOB in your DDL scripts. Regards, Martin ----- Dinamica - J2EE Framework Free, easy and powerful http://www.martincordova.com > 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
