ASEXPORT Procedure

MATCH SINGLETON Statement

Matches a single DataFlux Authentication Server object with an equivalent SAS Metadata Server object and places the match into the working set of export mappings. The MATCH SINGLETON statement name is followed by the type of object being matched for eventual export. The object type can be DOMAIN, USER, or GROUP. The MATCH SINGLETON statement has two options, CRITERIA and LOG.

Syntax

Optional Arguments

Syntax

MATCH SINGLETON <type> / <match-singleton-options>;

<CRITERIA="match-criteria">

<LOG>

Optional Arguments

CRITERIA="match-criteria"

specifies match criteria used to associate a single DataFlux Authentication Server object with a single SAS Metadata Server object for insertion into the working set of export mappings. The criteria must be valid SQL WHERE syntax that does not use the WHERE keyword. It must reference only the SQL entities available for the type of objects being matched.

The following table lists those entities per object type:

MATCH SINGLETON Entities
Type	SQL Entities Available in Match Criteria WHERE Clause
DOMAINS	All columns in AS.DOMAINS and META.DOMAINS
USERS	All columns in AS.USERS, META.USERS, X.AS_LOGINS_N, and X.MS_LOGINS_N
GROUPS	All columns in AS.GROUPS and META.GROUPS

The MATCH SINGLETON statement always joins objects using the default matching criteria per object type and then subsets based on the user’s CRITERIA= WHERE clause. If omitted, a CRITERIA= value of “1=1” is implied such that no further subsetting occurs. Specifying criteria that produces more than one match results in an error, and no additional mapping is queued for export. The following table documents the default match singleton criteria per object type:

The following table documents the default match singleton criteria per object type:

MATCH SINGLETON Criteria
Type	Default CRITERIA= value
DOMAINS	The domain is neither already exported nor queued for export in the current working set of export mappings.
USERS	(X.AS_LOGINS_N.USER_ID=AS.USERS.ID) and (X.MS_LOGINS_N.OWNER_ID= META.USERS.ID) and The user is neither already exported nor queued for export in the current working set of export mappings.
GROUPS	The group is neither already exported nor queued for export in the current working set of export mappings.

LOG

specifies to print match results in the SAS log.