SAS/Warehouse Administrator Metadata Types

WHTBLREC

Metadata type for intermediate output tables produced by record selector processes

Category:

Object Types--Intermediate Output Tables

Parent
Overview
Properties
Using WHTBLREC

Parent

WHTBLPRC

Overview

WHTBLREC models the metadata for intermediate output tables that are produced by record selector processes in SAS/Warehouse Administrator. In the Process Editor, these tables are represented as text boxes that are labeled Record Selection. For details about how intermediate output tables are displayed in the Process Editor, see Reading Process Flow Metadata.

Properties

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

In the table, you can specify properties with a Yes in the Indirect Add column when you indirectly add one object through another, as described in the documentation for the _UPDATE_METADATA_ method. Use this approach to add a new dependent object. For details, see Using _UPDATE_METADATA_.

You can pass properties with a Yes in the Update column to the _UPDATE_METADATA_ method, as described in the documentation for this method. Use this method to update properties of an existing object. For details, see Using _UPDATE_METADATA_.

* 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. * Auto supplied means that the property is automatically supplied; any value that you specify for such a property is ignored.

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	Indirect Add	Update Method	Read Method Expand Parm.
Access Same As Physical	N	* Auto supplied	* Auto supplied	No
Administrator	L	No	No	No
Columns	L	No	No	Yes
Creating Job	L	No	No	No
Creates Data	N	No	No	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	No	No	Yes
NValue	N	Yes	Yes	No
Output Objects	L	No	No	No
Output Targets	L	* Auto supplied	No	No
Owner	L	No	No	No
Physical Storage	L	Yes	Yes	Yes
Process	L	* Default	No	Yes
Table Name	C	Yes	Yes	No
Using Jobs	L	No	No	No

Using WHTBLREC

Add	Update	Delete
No	Yes	Yes

For a discussion of how you can use intermediate output tables, see Reading Process Flow Metadata.

WHTBLREC is a dependent type. To understand how all subtypes of WHTABLE relate to other types, see the models in Relationships Among Metadata Types.

Top of Page