Chapter Contents |
Previous |
Next |
ICVALUE |
Category: | SAS Table |
Syntax | |
Details | |
Example | |
See Also |
Syntax |
icvalue=ICVALUE(table-id,icname); |
CHECK
, icvalue returns the condition that values must meet.
Type: Character
Type: Numeric
Type: Character
Details |
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.
Example |
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 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();
See Also |
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.