on 06-03-2010 5:31 AM
Hi All,
I am getting the following error when I try to add a constraint to my table created in MaxDB. Below are the Query and the Error message:
Query:
CREATE TABLE "SAMPLE"."MULTILINGUAL_TABLE" (
"MANUFACTURER" VARCHAR (50) ASCII NOT NULL,
"PRODUCTNAME" VARCHAR(50) ASCII NOT NULL,
"MATERIALNUMBER" VARCHAR(50) ASCII NOT NULL,
"MATERIALDESC" VARCHAR(50) ASCII NOT NULL,
"SYNONYM_NAME" VARCHAR(50) ASCII NOT NULL)
ALTER TABLE "SAMPLE"."MULTILINGUAL_TABLEu201D ADD CONSTRAINT "PK_MULTILINGUAL_TABLE" PRIMARY KEY ("MANUFACTURER","PRODUCTNAME","MATERIALNUMBER","MATERIALDESC","SYNONYM_NAME")
Error:
Error Executing 'ALTER TABLE "SAMPLE"."MULTILINGUAL_TABLEu201D ADD CONSTRAINT "PK_MULTILINGUAL_TABLE" PRIMARY KEY ...' [-5015] (at 58): Missing keyword:MODIFY,COLUMN,ADD,DROP,UPDATE,TYPE,SAMPLE,PACKED,NOT,NOCACHE,FOREIGN,FOR,FACT,DYNAMIC,DIMENSION,CLUSTER ...
Please let me know how to create a constraint in MaxDB?
Regards,
Poojith MV
Hi,
maybe these links to the reference manual will help:
http://help.sap.com/saphelp_nwce72/helpdata/en/45/3e175e23874a18e10000000a114a6b/frameset.htm
http://help.sap.com/saphelp_nwce72/helpdata/en/45/36812f4c292b31e10000000a1553f7/frameset.htm
http://help.sap.com/saphelp_nwce72/helpdata/en/45/3e176123874a18e10000000a114a6b/frameset.htm
There you can see, that the combination of constraint-name and primary key - definition is not supported.
Best regards,
Elke
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.