ASEXPORT Procedure

REMOVE Statement

Removes objects matching the specified criteria from the working set of export mappings. The REMOVE statement name is followed by the type of objects being removed from the working set of export mappings. The object type can be DOMAIN, USER, or GROUP. The REMOVE statement has two options, CRITERIA and LOG.

Syntax

Optional Arguments

Syntax

REMOVE <type> / <remove-options>;

<CRITERIA="match-criteria">

<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:

remove domains / criteria="x.domain_map.as_name_n='EURNET'" log;

The following table lists those entities per object type:

REMOVE Criteria
Type	SQL Entities Available in Match Criteria WHERE Clause
DOMAINS	All columns in X.DOMAIN_MAP
USERS	All columns in X.USER_MAP
GROUPS	All columns in X.GROUP_MAP

The MATCH statement always selects objects mapped for export (those accumulated via the prior MATCH, MATCH SINGLETON, and ADD statements) using the specified criteria. The default CRITERIA= value is always “1=1” such that all export mappings are cleared.

LOG

specifies to print REMOVE statement results in the SAS log.

Last updated: June 7, 2017