dit:owb:omb

About

OMB is :

the scripting language from Oracle Warehouse Builder.
a set of java function embedded in the scripting langage tcl (with the help of tcljava). Thus, you must know Tcl a little bit before managing OMB but you can use an TCL Integrated development environment (ide) to develop your script as for instance Eclipse
use OMBPlus as shell, in the same way, than plsql use SqlPlus as shell
use a OWB - OMB Data Dictionary / Properties which define the objects and their properties that you can manipulate

Useful Commande	Goal	Example
[lindex argv 0]	To pass parameter to a OMBPlus Script	See expert article for an example
set OMBCONTINUE_ON_ERROR true;	To continue on error
set systemTime [clock seconds];
OMBCOMMIT/OMBROLLBACK	To Commit or Rollback

To modularize the OMB code, you can use:

use the source command to launch an external tcl script (source MyTclScript.tcl)
define the procedures in the Procedure Declaration panel of a common expert, and then add the expert into another (nest it), then call the procedure (for example if the expert define procedure PX is defined EX1, and the top level is called EX2, add EX1 into EX2, then in some OMB of EX2, call EX1_ns::PX)

To get a filtered list for instance of all table with KWI in their name:

OMBLIST TABLES '.*KWI.*'