ASEXPORT Procedure

ADD Statement

Adds DataFlux Authentication Server objects that are unmatched in the working set of SAS Metadata Server objects to the working set of export mappings. The ADD statement name is followed by the type of object being added for export. The object type can be DOMAIN, USER, or GROUP. The ADD statement has two options, CRITERIA and LOG.

Syntax

ADD <type> / <add-options>;
<LOG>

Optional Arguments

CRITERIA="match-criteria"

specifies criteria used to select DataFlux Authentication Server objects 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:
ADD Entities
Type
SQL Entities Available in Match Criteria WHERE Clause
DOMAINS
All columns in AS.DOMAINS
USERS
All columns in AS.USERS, X.AS_LOGINS_N
GROUPS
All columns in AS.GROUPS
The ADD statement always selects AS objects using the default criteria per object type and then subsets based on the CRITERIA= WHERE clause specified. If omitted, a CRITERIA= value of “1=1” is implied such that no further subsetting occurs.
The following table documents the default add criteria per object type:
ADD 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 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 ADD statement results in the SAS log.

Last updated: June 7, 2017