SAS/Warehouse Administrator Metadata Types

WHTBLPRC

Base metadata type for intermediate output tables produced by processes

Category:

Object Types--Intermediate Output Tables

Parent
Overview
Properties
Using WHTBLPRC

Parent

WHTABLE

Overview

WHTBLPRC is the base metadata type for intermediate output tables that are produced by processes in SAS/Warehouse Administrator. In the Process Editor, these tables are represented as text boxes with appropriate labels such as Mapping, User Exit, and so on. 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 WHTBLPRC and indicates how each you can use 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	No	No	No
Columns	L	No	No	Yes
Creating Job	L	No	No	No
Creates Data	N	No	No	No
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Group	L	No	No	No
Host	L	No	No	No
Icon	C	No	No	No
Id	C	No	No	No
Input Objects	L	No	No	No
Input Sources	L	No	No	No
Library	L	No	No	No
Members	L	No	No	No
Metadata Created	C	No	No	No
Metadata Updated	C	No	No	No
Name	C	No	No	No
Note	L	No	No	Yes
NValue	N	No	No	No
Output Objects	L	No	No	No
Output Targets	L	No	No	No
Owner	L	No	No	No
Physical Storage	L	No	No	Yes
Process	L	No	No	Yes
Table Name	C	No	No	No
Using Jobs	L	No	No	No

WHTBLPRC has the following new property:

CREATES DATA

specifies the numeric value that indicates whether the table has output data or is just a placeholder only.

0--No, this table has no output data. It is a placeholder only. (The This process has no output data selection has been made on the process properties Output Data tab.) An analogy would be a DATA step that performs processing but is coded with DATA _NULL_.

1--Yes, this table has output data.

Using WHTBLPRC

Add	Update	Delete
No	No	No

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

WHTBLPRC 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