SAS Component Language Dictionary

ICVALUE

Returns the column names or the condition associated with an integrity constraint

Category:

SAS Table

Syntax
Details
Example
See Also

Syntax

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

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 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();