SAS/Warehouse Administrator Metadata Types

WHCOLUMN

Base metadata type for table columns

Category:

Column Types

Parent
Overview
Properties
Using WHCOLUMN

Parent

WHROOT

Overview

WHCOLUMN is the base metadata type for table columns in SAS/WarehouseAdministrator.

Properties

The following table lists all of the properties for WHCOLUMN 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.
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Format	C	No	No	No
Id	C	No	* Req	No
Indexes	L	No	No	No
Informat	C	No	No	No
Input Objects	L	No	No	No
Input Sources	L	No	No	No
Length	N	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
Table	L	No	No	No
Type	C	No	No	No

New properties for WHCOLUMN are as follows:

FORMAT: specifies a SAS format that is assigned to this column.
INDEXES: specifies an SCL list of general identifying information about the indexes that contain this column.
INFORMAT: specifies a SAS informat that is assigned to this column.
INPUT OBJECTS: represents an SCL list of general identifying information about the objects input to this column. For more details about input objects, see INPUT and OUTPUT Properties.
INPUT SOURCES: represents an SCL list of general identifying information about the sources input to this column. This list must be of type WHCTRNFM, WHCOLUMN, or subtypes of these. The input sources to this column must be appropriately related through a common process. For more details about input sources, see INPUT and OUTPUT Properties.
LENGTH: specifies the value length of this column.
OUTPUT OBJECTS: specifies an SCL list of general identifying information about the objects output from this column. For more details about output objects, see INPUT and OUTPUT Properties.
OUTPUT TARGETS: represents an SCL list of general identifying information about the targets output from this column. The output targets to this column must be appropriately related through a common process. For more details about output targets, see INPUT and OUTPUT Properties.
TABLE: represents an SCL list of general identifying information about the table object to which this column belongs.
TYPE: specifies the type of data that is contained in this column. Valid types are C (character) or N (numeric).

Using WHCOLUMN

Add	Update	Delete
No	No	No

WHCOLUMN and its subtypes are dependent types. To understand how all subtypes of WHCOLUMN relate to other types, see the column mapping models in Relationships Among Metadata Types.

Top of Page