OMBLIST

Purpose

This command lists the specified Warehouse Builder objects under the current folder. You can also provide a regular expression to list objects in a different folder and/or to list objects with names matching a pattern. Some global objects (e.g. LOCATIONS, CONTROL_CENTERS, USERS, ROLES, CONFIGURATION_TEMPLATES, ICONSETS) can be listed from any context. Before displaying the objects, this command first refreshes the object list from the repository. This means that the list of objects returned also reflects any additions or deletions by other users.

Prerequisites

Must be connected to a OWB workspace of the repository.

Syntax

parseListCommand =  "listActionPlans" | "listGeneral" 
     listActionPlans =  OMBLIST DEPLOYMENT_ACTION_PLANS [ "QUOTED_STRING" ]
     listGeneral =  OMBLIST "UNQUOTED_STRING" [ "QUOTED_STRING" ]

Parameters

parseListCommand

Specify the list command.

listActionPlans

Deployment action plans are listed.

listGeneral

OWB objects of the specified type are listed.

UNQUOTED_STRING

The type (plural) of the objects to be listed. Valid object types are: ACTIVITY_TEMPLATES, ACTIVITY_TEMPLATE_FOLDERS, ADVANCED_QUEUES, ALTERNATIVE_SORT_ORDERS, BUSINESS_AREAS, BUSINESS_DEFINITION_MODULES, OBIEE_BUSINESS_DEFINITION_MODULES, BUSINESS_PRESENTATION_MODULES, CALENDARS, CALENDAR_MODULES, CMI_DEFINITIONS, CMI_MODULES, COLLECTIONS, CONFIGURATIONS, CONNECTORS, CONTROL_CENTERS, CUBES, DATA_AUDITORS, DATA_PROFILES, DATA_RULES, DATA_RULE_MODULES, DEPLOYMENTS, DEPLOYMENT_ACTION_PLANS, DIMENSIONS, DRILL_PATHS, DRILLS_TO_DETAIL, EXPERTS, EXPERT_MODULES, EXTERNAL_TABLES, FLAT_FILES, FLAT_FILE_MODULES, FOLDERS, FUNCTIONS, GATEWAY_MODULES, ICONSETS, ITEM_FOLDERS, CTS, CT_FOLDERS, LISTS_OF_VALUES, LOCATIONS, MAPPINGS, MATERIALIZED_VIEWS, NESTED_TABLES, OBJECT_TYPES, ORACLE_MODULES, PACKAGES, PLSQL_RECORD_TYPES, PLSQL_REF_CURSOR_TYPES, PLSQL_TABLE_TYPES, PLUGGABLE_MAPPINGS, PLUGGABLE_MAPPING_LIBRARIES, PRESENTATION_TEMPLATES, PROCEDURES, PROCESS_FLOWS, PROCESS_FLOW_MODULES, PROCESS_FLOW_PACKAGES, PROJECTS, QUEUE_PROPAGATIONS, QUEUE_TABLES, REAL_TIME_MAPPINGS, REGISTERED_FUNCTIONS, ROLES, SAP_MODULES, SEQUENCES, SNAPSHOTS, STREAMS_CAPTURE_PROCESSES, STREAMS_QUEUES, TABLES, TABLE_FUNCTIONS, TIME_DIMENSIONS, TRANSFORMATION_MODULES, TRANSPORTABLE_MODULES, USERS, VARYING_ARRAYS, VIEWS.

QUOTED_STRING

Mandatory for CONNECTORS, specify a location name; optionally for all other objects, specify a regular expression, which is used to filter the results.

The syntax of the regular expressions follow the syntax from TCL.

Here are some of the quantifiers:

* -- represents a sequence of 0 or more matches of the atom.

+ -- represents a sequence of 1 or more matches of the atom.

? -- represents a sequence of 0 or 1 matches of the atom.

Here are some of the atoms:

. -- matches any single character

k -- (where k is a non-alphanumeric character) matches that character taken as an ordinary character,

e.g. \\ matches a backslash character.

c -- where c is alphanumeric(possibly followed by other characters), an escape.

(re) -- (where re is any regular expression) matches a match for re, with the match noted for possible reporting.

[char] -- a bracket expression, matching any one of the chars.

Further documentation on the syntax can be found at the TCL manual page under the command 'regexp'.