SAS/Warehouse Administrator Metadata Types

WHREPLIB

Metadata type for metadata repositories

Category:

SAS Library Types

Parent
Overview
Properties
Using WHREPLIB

Parent

WHLIBRY

Overview

WHREPLIB models metadata repositories in SAS/Warehouse Administrator. SAS/Warehouse Administrator has a partitioned metadata repository scheme. Each warehouse environment has a repository that is named _MASTER. Each data warehouse within an environment has a repository that is named _DWMD. In SAS/Warehouse Administrator, these repositories are created when the environment or warehouse is created.

Properties

The following table lists all of the properties for WHREPLIB 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.
Cvalue	C	No	Yes	No
Database	L	Yes	No	No
DBMS Libname	N	* Default	No	No
Desc	C	No	Yes	No
Engine	C	No	Yes	No
Extended Attributes	L	No	Yes	Yes
Icon	C	No	Yes	No
Id	C	No	* Req	No
Libref	C	No	Yes	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	No	* Default	No
Note	L	No	Yes	Yes
NValue	N	No	Yes	No
Options	L	No	Yes	No
Path	L	No	Yes	No
Preassigned	N	No	Yes	No
Tables	L	No	No	No

Using WHREPLIB

Add	Update	Delete
No	Yes	No

WHREPLIB is an independent type, like its parent, WHLIBRY. To understand how all subtypes of WHLIBRY relate to other types, see the physical storage models in Relationships Among Metadata Types.

For a general discussion of metadata repositories, see Metadata Repositories.

Top of Page