SAS SPDS table primary constraint unable to add

Question

I am trying to add primary constraint on a SAS SPDS table.

Error i am receivig is - 1. ERROR: Engine SASSPDS does not support integrity constraint operations 2. ERROR: Requested function is not supported.

I am unable to proceed. Query i have used -

1.

PROC DATASETS LIB=libname;
       MODIFY tablename;
       IC CREATE PK_IDENTPRODUKT= primary key (IDENTPRODUKT);
QUIT;

**** and also tried 2.

proc sql;
alter table libname.tablename add constraint PK_IDENTPRODUKT primary key (IDENTPRODUKT);
quit;

Any suggestions.

@cherry_bueno Sounds like you have enough for an answer there! — Joe, Nov 25 '15 at 19:11
@cherry_bueno - You are talking about "SPDE" and the question is about SPDS, please don't paste links blindly without knowing about the question and context. — Vishant, Dec 03 '15 at 18:32

score 0 · Answer 1 · answered Dec 03 '15 at 18:30

0

SPDS was created with ACID compliance and does support INDEX creation. Please refer to the link below which will be very helpful
http://support.sas.com/documentation/cdl/en/spdsug/64018/HTML/default/viewer.htm#p1ssxe4zp7vvijn1wkn1pdjrk891.htm

answered Dec 03 '15 at 18:30

Vishant

1 Answers1