User Import Macros |
Used in: | User Import |
Depicted in: | Initial Import |
Requirement: | Connection to the metadata server |
Syntax | |
Columns in the FAILEDOBJS Table |
Syntax |
%MDUIMPLB (<LIBREF=libref>, <TEMP=libref>, <FAILEDOBJS=table_name>, <EXTIDTAG=context_value>, <BLKSIZE=#_of_records>); |
This macro uses PROC METADATA to submit load requests. All parameters for this macro are optional.
specifies the location of the input data. The default is Work .
specifies the location for temporary data sets during processing. The default is Work .
is a table that contains the entire contents of all blocks that contain any problematic data. The default is mduimplb_failedobjs. See Columns in the FAILEDOBJS Table.
This table is populated if integrity and completeness requirements aren't met or if a metadata server request failure occurs during processing. See What Information Is Imported?.
indicates the origin of identity information. The default for this string is IdentityImport.
specifies the number of identities in a block. Each block of XML is generated and submitted to the metadata server independently. The default is 100.
Note: The corresponding macro from previous releases, %MDUIMPL, is still supported. See the 9.1 version of this document.
Columns in the FAILEDOBJS Table |
Column | Contents |
---|---|
tablename | Name of an intermediate input table |
chgtype | A (add), U (update), or D (delete) |
objtype | Internal metadata object type |
Name | Name of a user, group or role |
Objid | Internal object ID |
KeyId | Key ID for an item |
UserId | User ID value in a login |
AuthDomKeyId | Key ID of an authentication domain |
MemObjType* | Internal metadata object type for a member |
MemName* | Person indicates a user, IdentityGroup indicates a group |
MemObjID* | Internal metadata object ID |
MemKeyId* | Key ID of a member |
* This column is populated only if there is an error in membership information. |
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.