Useful OMBPlus commands
26 03 2008More 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"
}
}
Comments : Leave a Comment »
Categories : OWB
Recent Comments