SAS/Warehouse Administrator Metadata Types

WHPRCLDR

Base metadata type for table load processes

Category:

Process Types--Load

Parent
Overview
Properties
	Property Dependencies
Using WHPRCLDR

Parent

WHPRCMAN

Overview

WHPRCLDR is the base metadata type for table load processes in the SAS/Warehouse Administrator Process Editor.

Properties

The following table lists all of the properties for WHPRCLDR 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
Load Options	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 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

WHPRCLDR has the following new property:

LOAD OPTIONS

specifies an SCL list of options for the specified load process. The options are as follows:

GENERATION LEVEL (1.1 or 2.0) selects the release level of the code that SAS/Warehouse Administrator will generate for the specified load process. Each level has specific options that it can support, as well as other characteristics.
LOAD TIME COLUMN (YES or NO) indicates whether a Load Time column will be added to the table that is being loaded by the specified process.

Note: See Property Dependencies.
DROP INDEXES (YES or NO) specifies that you should drop (remove) any existing indexes on the table to be loaded before you load the data into the table. Based on the metadata definitions, the appropriate indexes will be recreated after loading the data. This option is useful when updating the indexes during loading is too slow.
TRUNCATE TABLE (YES or NO) specifies that when you refresh the data in a table, the table should be truncated (all data rows are removed but the table is not) instead of completely dropping the table and recreating it from scratch. This option is useful when the table has many options, privileges, and other characteristics that are defined in the database.
UNION MULTIPLE INPUTS (YES or NO) specifies that any multiple inputs to the current load process will be unioned together before you load the table. A union is identical to a SET statement in a SAS data step that contains multiple input table designations.

In the SAS/Warehouse Administrator interface, LOAD OPTIONS are specified on the Load Options tab of the Load process attributes window for a given data store. Here are some example return values for a data store whose Load process attributes window includes a Load Options tab:

LOAD OPTIONS=(     GENERATION LEVEL='2.0'
                   LOAD TIME COLUMN='NO'
                   UNION MULTIPLE INPUTS='YES'
                   DROP INDEXES='NO'
                   TRUNCATE TABLE='NO'
              )

Property Dependencies

Subtypes of WHPRCLDR enable you to add or update the LOAD OPTIONS property. When you add or update the LOAD OPTIONS property, if the value of the LOAD TIME COLUMN item is YES, then a valid load time column must exist for the table that is associated with this load process to avoid errors when processing the SOURCE CODE and STEP SOURCE CODE properties. You can add a load time column to a table as described in the documentation for the WHCOLTIM type.

Using WHPRCLDR

Add	Update	Delete
No	No	No

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

For details about reading process information, see Reading Process Flow Metadata.

Top of Page