ASEXPORT Procedure

MATCH Statement

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

Syntax

MATCH <type> / <match-options>;
<LOG>

Optional Arguments

CRITERIA="match-criteria"

specifies match criteria used to associate DataFlux Authentication Server objects and SAS Metadata Server objects 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 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 statement always joins objects using the default matching criteria per object type and then subsets based on the CRITERIA= WHERE clause specified. If omitted, a CRITERIA= value of “1=1” is implied so that no further subsetting occurs.
The following table documents the default match criteria per object type:
MATCH Criteria
Type
Default CRITERIA= value
DOMAINS
(AS.DOMAINS.NAME_N=META.DOMAINS.NAME_N) and (META.DOMAINS.AS_ID is NULL)
USERS
(X.AS_LOGINS_N.USER_ID=AS.USERS.ID) and (X.MS_LOGINS_N.FQLN_N=X.AS_LOGINS_N.FQLN_N) and (META.USERS.ID=X.MS_LOGINS_N.OWNER_ID) and (META.USERS.AS_ID is NULL)
GROUPS
(AS.GROUPS.NAME_N=META.GROUPS.NAME_N) and (META.GROUPS.AS_ID is NULL)

LOG

specifies to print match results in the SAS log.

Last updated: June 7, 2017