SAS/Warehouse Administrator Metadata Types

WHROOT

Root type for all SAS/Warehouse Administrator metadata types

Category:

Root Metadata Type--SAS/Warehouse Administrator

Parent
Overview
Properties
Using WHROOT

Parent

SASHELP.FSP.OBJECT

Overview

WHROOT is the root for all metadata types in SAS/Warehouse Administrator.

Properties

New properties for WHROOT are as follows:

CVALUE

indicates the 40-character string that a site can use to extend the metadata that is maintained by SAS/Warehouse Administrator. Use it for site-specific character metadata.

DESC

indicates the optional text that describes the purpose of an object or other information that is useful to a site.

EXTENDED ATTRIBUTES

specifies an SCL list that a site can use to extend the metadata that is maintained by SAS/Warehouse Administrator. Items in the list are

OBJECT specifies the general identifying information about the owning object for this extended attribute.

TYPE indicates the data type of the attribute, C for character data is the only valid type for this release.

VALUE indicates the 200-character string that contains the extended attribute text, such as a URL or a file path to a document that describes the owning object.

For usage details, see Using WHEXTATR. The EXTENDED ATTRIBUTES property is implemented with the object WHEXTATR.

ID

indicates the metadata identifier for a specific metadata object in a repository. The identifier is 26 characters in length and is in the format: REPOSID.TYPEID.INSTANCEID.

REPOSID specifies the ID of the repository in which the metadata resides. It is eight characters in length.

TYPEID specifies the type of metadata object, such as WHDETAIL. It is eight characters in length.

INSTANCEID distinguishes one metadata object from all others of that type in a given repository. It is eight characters in length.

METADATA CREATED

specifies the SAS datetime value for when the metadata for this object was initially created. (A character value that is formatted with a SAS DATETIME. FORMAT.)

METADATA UPDATED

specifies the SAS datetime value for when the metadata for this object was updated. (A character value that is formatted with a SAS DATETIME. FORMAT.)

NAME

indicates the name of the metadata object. The name that is returned is in the context of the component that it comes from. For example, SAS/Warehouse Administrator names are those that appear in the Explorer, the Setup window, the Process Editor, and so on.

The length of the name depends on the individual type. All names can be at most 40 characters in length. Some types, such as WHPERSON, allow the name to be longer than 40 characters. The maximum length of the name is 40 characters unless otherwise noted in a particular type.

NOTE

indicates the user-entered descriptions of objects, columns, or processes. NOTE metadata is modeled by the WHNOTE type. For details, see WHNOTE.

NVALUE

indicates the numeric value that a site can use to extend the metadata that is maintained by SAS/Warehouse Administrator. Use it for site-specific numeric metadata.

Note: The documentation for many metadata types refers to general identifying information. This phrase refers to the ID, NAME, and DESC properties. For more details, see Identifying Metadata. [cautionend]

Using WHROOT

Add	Update	Delete
No	No	No

WHROOT is an independent type. WHROOT is not used to read or write metadata in a repository. It is a template for all metadata types in SAS/Warehouse Administrator.

Top of Page