CONFIG_OBJECTS

The CONFIG_OBJECTS view contains the configuration statement for the specified object. Stored information varies by object. The configuration statement text is broken up into pieces by type based on how FedSQL parses the statement. Sub-text for each type is broken up to fit into the DATA column ordered by CFG_TYPE_SEQUENCE.

Concatenating the DATA entries for a given OBJECT_NAME in SEQUENCE order will produce the original configuration statement syntax with the following exceptions:

It will be normalized and broken up into pieces based on what options are specified.
It can be reordered, although positional clauses like EXEC will always remain in sequence
It will contain any comments that were in the original create cache statement that was submitted
It might be modified to contain information specified by later statements, such as ALTER.

Note: A view cache will return a single entry containing the most recent CREATE CACHE statement, an OBJECT_TYPE of 2 (SAS View) or 3 (CACHE), and the catalog/schema/name of the view being cached.

The following table lists the available columns for this view. Data is visible only if the user has CREATE CACHE or ALTER CACHE privilege on the referenced view.

Name	Type	Description
CATALOG_NAME	WVARCHAR(256) Not Null	Specifies the catalog containing the object.
SCHEMA_NAME	WVARCHAR(256) Not Null	Specifies the schema containing the object.
OBJECT_NAME	WVARCHAR(256) Not Null	Specifies the object name.
OBJECT_TYPE	INTEGER Not Null	Specifies the object type: 1 – Table, 2 – SAS View, 3 – Cache, 4 – SAS Package
DATA	WVARCHAR(128) Not Null	A piece of text from the configuration statement.
SEQUENCE	INTEGER Not Null	Orders the entries for the entire configuration statement for a single object.
CFG_TYPE	INTEGER Not Null	Indicates the type for this piece of the configuration statement as parsed by FedSQL.
CFG_TYPE_SEQUENCE	INTEGER	Orders the entries within each type.

Last updated: March 6, 2018