SAS/Warehouse Administrator Metadata Types

WHLDETL

Metadata type for detail logical tables

Category:

Object Types--Explorer

Parent
Overview
Properties
	Property Dependencies
Using WHLDETL
	Adding and Linking Detail Tables
	Deleting and Unlinking Detail Tables

Parent

WHTABLE

Overview

WHLDETL models the metadata for detail logical tables in SAS/Warehouse Administrator. A detail logical table is a multipurpose table that you can use as a detail table, a grouping element for detail tables, or a view on multiple that is related detail tables. If you use it as a grouping element, a detail logical table defines columns that are shared by all of its detail tables.

To add a detail logical table with the SAS/Warehouse Administrator Explorer:

Find a subject that does not already have a detail logical table (each subject can only have one).
Select the subject with the right mouse button.
Select Add Item Detail Logical Table
Select the detail logical table with the right mouse button.
Select Properties.
Enter the detail logical table information.

Properties

The following table lists all of the properties for WHLDETL 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.

Note: A CREATING JOB property is required if the INPUT SOURCES property is also specified. [cautionend]

Properties	Type	Add Method	Update Method	Read Method Expand Parm.
Access Same As Physical	N	Yes	Yes	No
Administrator	L	Yes	Yes	No
Columns	L	Yes	Yes	Yes
Creating Job	L	Yes (see Property Dependencies)	Yes (see Property Dependencies)	No
Cvalue	C	Yes	Yes	No
Desc	C	Yes	Yes	No
Extended Attributes	L	Yes	Yes	Yes
Group	L	* Req	Yes	No
Host	L	Yes	Yes	No
Icon	C	Yes	Yes	No
Id	C	* Req	* Req	No
Input Objects	L	No	No	No
Input Sources	L	Yes (see Property Dependencies)	Yes (see Property Dependencies)	No
Library	L	Yes	Yes	No
Members	L	No	No	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	* Default	Yes	No
Note	L	Yes	Yes	Yes
NValue	N	Yes	Yes	No
Output Objects	L	No	No	No
Output Targets	L	Yes	Yes	No
Owner	L	Yes	Yes	No
Physical Storage	L	Yes	Yes	Yes
Process	L	Yes	Yes	Yes
Table Name	C	Yes	Yes	No
Using Jobs	L	No	No	No

Property Dependencies

You must define a CREATING JOB property in order to add INPUT SOURCES to a table. If a table does not have a CREATING JOB property, then you must specify one when you add an input source to the table.

Using WHLDETL

Add	Update	Delete
Yes	Yes	Yes

WHLDETL is an independent type, like all subtypes of WHTABLE. To understand how all subtypes of WHTABLE relate to other types, see the models in Relationships Among Metadata Types.

The table that is created as part of the _ADD_METADATA_ method is added as a member to only the first group listed in the GROUP property list. Once you add a table, the GROUP property cannot be changed using the metadata API.

Adding and Linking Detail Tables

SAS/Warehouse Administrator supports the linking of detail tables (tables of type WHDETAIL) between multiple subjects in a warehouse. Currently, however, the metadata API does not support the concept of linking detail tables to multiple subjects.

Deleting and Unlinking Detail Tables

You can use the _DELETE_METADATA_ method to unlink a table from a list of subjects or delete the table entirely. The determination of the type of delete to perform is based on the presence and value of the GROUP property in the l_meta list that is passed to the _DELETE_METADATA_ method.

If the GROUP property is not passed in the l_meta list or an empty list is passed as the value of the GROUP property, then the table will be deleted entirely. If the GROUP property is passed as a nonempty list in the l_meta list, the table will be unlinked from all groups that are referenced in the GROUP property list. If an invalid GROUP identifier is passed in this list, an error is returned to the application and the table is not unlinked from any of the referenced groups.

Top of Page