SAS Component Language Dictionary |
Returns the type of integrity constraint that is assigned to a
SAS table
ictype=ICTYPE(table-id,icname);
|
-
ictype
-
contains the type of integrity constraint
that is returned. The constraints are listed below and are defined in ICCREATE:
|
'CHECK' |
|
'FOREIGN' |
|
'NOT-NULL' |
|
'PRIMARY' |
|
'UNIQUE' |
Type:
Character
-
table-id
-
contains the identifier for the SAS table,
which is returned by the OPEN function.
Type: Numeric
-
icname
-
is the name of the integrity constraint.
Type: Character
ICTYPE returns the type of integrity constraint
for a SAS table when you specify the name of the constraint.
Return the type of the UQ integrity constraint that
is assigned to the SAS table MYLIB.ONE. Because the constraint UQ (which was
created in the example for ICCREATE)
was UNIQUE, the value of TYPE will be UNIQUE.
tableid=open('mylib.one','i');
type=ictype(tableid,'uq');
...more SCL statements...
rc=close(tableid);
ICCREATE
ICDELETE
ICVALUE
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.