Hi,
in dbmcli the following statement fails with -5006: Missing identifier
sql_execute CREATE TABLE SecondaryMembership ( UserID INT NOT NULL, GroupID INT NOT
NULL, UNIQUE (UserID, GroupID))
while the following two work just fine
sql_execute CREATE TABLE SecondaryMembership ( UserID INT NOT NULL, GroupID INT NOT
NULL)
sql_execute CREATE TABLE SecondaryMembership ( UserID INT NOT NULL, GroupID INT NOT
NULL, CONSTRAINT c_1 UNIQUE (UserID, GroupID))
If I understand the documentation on CREATE TABLE correctly, the
"CONSTRAINT <index_name>" in "<unique_definition>" should be optional.
What's going wrong here?
Btw, I'm testing SAPDB version 7.4.3.7 (RPM installation) on SuSE 7.2 linux.
Bye,
Peter
--
Peter Conrad Tel: +49 6102 / 80 99 072
[ t]ivano Software GmbH Fax: +49 6102 / 80 99 071
Bahnhofstr. 18
63263 Neu-Isenburg
Germany
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
