SAS Component Language Dictionary |
Returns the column names or the condition associated with an integrity
constraint
icvalue=ICVALUE(table-id,icname);
|
-
icvalue
-
contains the names of one or more columns
from the SAS table identified by table-id. When ictype is CHECK, icvalue returns
the condition that values must meet.
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
ICVALUE returns the names of columns that
are associated with the specified integrity constraint. If ictype is CHECK and is specified
as a condition, then ICVALUE returns the condition that is assigned to the
constraint.
Return the value of the UQ integrity constraint. If
ICVALUE returns a blank, then display the error message. Because the constraint
UQ (which was created in the example for ICCREATE)
specified that columns D and E must contain unique values, COLLIST
would contain D E.
tableid=open('mylib.one','i');
collist=icvalue(tableid,'uq');
if (collist=' ') then _msg_=sysmsg();
ICCREATE
ICDELETE
ICTYPE
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.