SAS/Warehouse Administrator Metadata Types

WHPRCMAN

Base metadata type for main processes

Category:

Process Types

Parent
Overview
Properties
Using WHPRCMAN

Parent

WHPROCES

Overview

WHPRCMAN is one of the base types for main processes in the SAS/Warehouse Administrator Process Editor. It is the parent of WHPRCLDR, the base type for all load process metadata.

Properties

The following table lists all of the properties for WHPRCMAN 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.
Administrator	L	No	No	No
Cvalue	C	No	No	No
Desc	C	No	No	No
Extended Attributes	L	No	No	Yes
Host	L	No	No	No
Id	C	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 Tables	L	No	No	No
Owner	L	No	No	No
Responsibility	C	No	No	No
Source Code	L	No	No	Yes
Source File	L	No	No	Yes
Step Source Code	L	No	No	Yes
Subprocesses	L	No	No	Yes

New properties for WHPRCMAN are as follows:

OUTPUT TABLES: specifies an SCL list of general identifying information about the output tables of this process. All WHPRCMAN processes will have at least one output table that is associated with them (a WHTABLE subtype).

SOURCE CODE

specifies an SCL list of general identifying information about the source code for this process. This source code is the same as is seen when you select View Code All in the SAS/Warehouse Administrator Process Editor.

The source code information that is returned here will be that of a temporary, working location of a copy of the source code and might be different for each request for this information.

SOURCE FILE

specifies an SCL list of general identifying information about any user-registered code for a process. This list must be of type WHSRCCAT or a subtype of WHSRCCAT. WHJOBCAT or any subtype of WHJOBCAT will be rejected, however. For process steps that consist of user-written code, this property returns the registered source code location. For process steps that consist of code that is generated by SAS/Warehouse Administrator, this property will return an empty list.

SUBPROCESSES

specifies an SCL list of general identifying information about any subprocesses that might be registered for this process. This list must be of type WHPRCSPR or a subtype of WHPRCSPR.

Using WHPRCMAN

Add	Update	Delete
No	No	No

WHPRCMAN is a dependent type. WHPRCMAN has the same usage information as WHPROCES.

Top of Page