Useful OMBPlus commands

26 03 2008

More to follow, no time to make a real post, but I need to put this in a place I can easily reach.

A method to find out which properties are available instead of the more intuitive

OMBRETRIEVE MAPPING '<name>' TABLE_OPERATOR '<tbl>' GET ALL PROPERTIES

This is the ‘real’ syntax:

OMBDESRIBE CLASS_DEFINITION

eg.

OMBDESCRIBE CLASS_DEFINITION 'TABLE_OPERATOR' GET PROPERTY_DEFINITIONS

I found it here

Another one I need now and again:

The type of activities that can be present in a Process FLow

Finding out activity types that are supported I made a list (OWB 10.2.0.3):

OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET AND ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET ASSIGN ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET DATA_AUDITOR ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET EMAIL ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET END_ERROR ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET END_LOOP ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET END_SUCCESS ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET END_WARNING ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET FILE_EXISTS ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET FOR_LOOP ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET FORK ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET FTP ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET MANUAL ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET MAPPING ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET NOTIFICATION ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET OR ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET ROUTE ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET SET_STATUS ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET SQLPLUS ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET SUBPROCESS ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET TRANSFORMATION ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET USER_DEFINED ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET WAIT ACTIVITIES
OMBRETRIEVE PROCESS_FLOW 'EERSTE' GET WHILE_LOOP ACTIVITIES

The above being an extract from this

And if you are really interested in what properties can be used

set model OWB
set classes [OMBDESCRIBE MODEL '$model' GET CLASS_DEFINITIONS]
foreach class $classes {
puts "############### Class: $class ###############"
puts "--- Properties:"
set props [OMBDESCRIBE CLASS_DEFINITION '$class' GET PROPERTY_DEFINITIONS]
foreach prop $props {
puts "------ $prop"
}
}

Advertisements

Actions

Information

2 responses

19 04 2013
Saschia

You’re great! the last script is VERY!!! helpful, this piece of documentation is really missing everywhere

22 04 2013
Buddel

Thanks Saschia.
Nice to see something as old as this (about 5 years!) can still be useful :). Who is saying IT is evolving fast……

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: