SAS/Warehouse Administrator Metadata Types

WHDWENV

Metadata type for warehouse environments

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHDWENV

Parent

WHOBJECT

Overview

WHDWENV models the metadata for warehouse environments in SAS/Warehouse Administrator. An environment is a grouping element for warehouses and ODD groups. It is a directory that stores metadata, such as host definitions, that is shared among one or more warehouses and ODD groups.

In the SAS/Warehouse Administrator desktop folder, environments are displayed as icons. In the SAS/Warehouse Administrator Explorer, the environment that you selected from the desktop folder is the top-most object. To add an environment to the SAS/Warehouse Administrator desktop interface:

Click in a clear area with the right mouse button.
Select Add Item Data Warehouse Environment
Enter the environment information.

Properties

The following table lists all of the properties for WHDWENV and indicates how you can use each property with metadata API methods.

In the table, you can pass properties with a Yes in the Add column to the _ADD_METADATA_ method. Use this method to add a new object.

You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method. Use this method to update properties of an existing object.

* Req indicates that the property is required; you must provide a value for this property when you use a given method. * Default indicates that the system will provide a default value for that property if you do not provide one.

Properties with a Yes in the Read Method Expand Parm column are valid with the expand parameter of the _GET_METADATA_ method. This method enables you to get detailed metadata about a property and its associated objects through a single method call.

Properties	Type	Add Method	Update Method	Read Method Expand Parm.
Active Repositories	L	No	No	No
Administrator	L	No	No	No
Cvalue	C	No	Yes	No
Desc	C	No	Yes	No
Extended Attributes	L	No	Yes	Yes
Group	L	No	Yes	No
Icon	C	No	Yes	No
Id	C	No	* Req	No
Job Info Library	L	No	No	No
Library	L	No	No	No
Members	L	No	No	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	No	No	No
Note	L	No	Yes	Yes
NValue	N	No	Yes	No
Owner	L	No	No	No
Process Groups	L	No	No	No
Process Members	L	No	Yes	No
Repositories	L	No	No	No

New properties for WHDWENV are as follows:

ACTIVE REPOSITORIES: specifies an SCL list of general identifying information about the currently active secondary metadata repositories in this environment.
JOB INFO LIBRARY: specifies an SCL list of general identifying information about the job information library that is associated with this repository. The job information library is the location where job status information is stored for scheduled jobs.
LIBRARY: specifies an SCL list of general identifying information about the SAS library that contains the metadata for this environment.
PROCESS GROUPS: specifies an SCL list of general identifying information about the process groups to which this object belongs.
PROCESS MEMBERS: specifies an SCL list of general identifying information about the process members that belong to this object. The list must be of type WHDW, WHGRPJOB, WHJOB, or WHEVENT. A WHDW object will be rejected if it is not in the current data warehouse. Any attempt to remove the current data warehouse from this property will be ignored.
REPOSITORIES: specifies an SCL list of general identifying information about the metadata repositories in this environment.

Using WHDWENV

Add	Update	Delete
No	Yes	No

WHDWENV is an independent type, like all subtypes of WHOBJECT. To understand how all subtypes of WHOBJECT relate to other types, see the general information model in Relationships Among Metadata Types.

WHDWENV is used with the _SET_PRIMARY_REPOSITORY_ method to access the metadata for a warehouse environment. For details, see _SET_PRIMARY_REPOSITORY_.

Top of Page