SAS/Warehouse Administrator Metadata Types

WHODTTBL

Metadata type for ODTs (Data Files)

Category:

Object Types--Process Editor

Parent
Overview
Properties
Using WHODTTBL

Parent

WHTABLE

Overview

WHODTTBL models the metadata for operational data tables (ODT) in SAS/Warehouse Administrator. An ODT is a SAS table that is an input to an operational data definition (ODD) in the Process Editor. In the Process Editor, the ODT is called a data file. Here is one way to add an ODT in SAS/Warehouse Administrator:

In the Explorer, select an ODD with the right mouse button.
Select Process from the pop-up menu.
In the Process Editor, select the ODD with the right mouse button.
Select Add Data File
Select the data file with the right mouse button.
Select Properties.
Enter the ODT information.

Properties

The following table lists all of the properties for WHODTTBL 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.
Access Same As Physical	N	No	No	No
Administrator	L	Yes	Yes	No
Columns	L	No	No	Yes
Creating Job	L	Yes	Yes	No
Cvalue	C	Yes	Yes	No
Desc	C	Yes	Yes	No
Extended Attributes	L	Yes	Yes	Yes
Group	L	No	No	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	Yes	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

Using WHODTTBL

Add	Update	Delete
Yes	Yes	Yes

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

Top of Page