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]
