SAS/Warehouse Administrator Metadata Types

WHTABLE

Base metadata type for tables

Category:

Object Types--Explorer

Parent
Overview
Properties
Using WHTABLE

Parent

WHOBJECT

Overview

WHTABLE is the base metadata type for SAS/Warehouse Administrator tables.

Properties

The following table lists all of the properties for WHTABLE 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	No	No	No
Columns	L	No	No	Yes
Creating Job	L	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

New properties for WHTABLE are as follows:

ACCESS SAME AS PHYSICAL

specifies a numeric value that indicates whether the access location view information for this table is the same as the physical storage information.

0--No, the access location view information for this table is not the same as the physical storage information.

1--Yes, the access location view information for this table is the same as the physical storage information. (For SAS data sets only).

See SAS/Warehouse Administrator documentation for more details about the ACCESS SAME AS PHYSICAL option for tables that are stored as SAS data sets.

COLUMNS

specifies an SCL list of general identifying information about the columns in this table.

CREATING JOB

specifies a list of general identifying information about the job that creates this table. This property returns a WHJOB object. A valid CREATING JOB property is required before you can add any INPUT SOURCES. If the CREATING JOB property is removed, then any work tables in the chain of INPUT SOURCES will be deleted as well.

You cannot change the CREATING JOB property for a single table that is output from a mapping with more than one output table. You can use the OUTPUT TABLES property of the WHJOB object to which the tables are to be moved to change the value of the CREATING JOB property for all output tables of a mapping simultaneously.

HOST

specifies an SCL list of general identifying information about the host on which this data is accessed.

INPUT OBJECTS

specifies an SCL list of general identifying information about the objects that are input to this table. For more information about input objects, see INPUT and OUTPUT Properties.

INPUT SOURCES

specifies an SCL list of general identifying information about the sources that are input to this table. For more information about input sources, see INPUT and OUTPUT Properties.

LIBRARY

specifies an SCL list of general identifying information about the SAS Library that contains this table.

OUTPUT OBJECTS

an SCL list of general identifying information about the objects that are output from this table. For more information about output objects, see INPUT and OUTPUT Properties.

OUTPUT TARGETS

an SCL list of general identifying information about the targets that are output from this table. For more information about output targets, see INPUT and OUTPUT Properties.

PHYSICAL STORAGE

specifies an SCL list of general identifying information about where this table is physically stored.

PROCESS

specifies an SCL list of general identifying information about the process that created this table. This list must be of type WHPRCMAN. Adding a process beneath itself is prevented.

TABLE NAME

indicates the character string--the name of the table.

USING JOBS

specifies a list of general identifying information about all the jobs that use this table as input to output tables of the job.

Using WHTABLE

Add	Update	Delete
No	No	No

WHTABLE and its children are independent types. To understand how all subtypes of WHTABLE relate to other types, see the models in Relationships Among Metadata Types.

Top of Page