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

Article Related

• OMB - Special Characters

IDE

As OMB use Tool Command Language (TCL) as support language, you can in theory use any Integrated development environment (ide) that manage Tool Command Language (TCL).

• OWB - How to configure the IDE Eclipse to develop with the OMB language ?

Snippet

• OWB - OMB - Data Rules
• OWB - OMB snippet for Process Flow
• A beginner example to start with package on TCL : HelloWorld
• OMBENV - environment variables
• OMB Debug

Useful Command

Code Modularity

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)

Navigate Repositories

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

OMBLIST TABLES '.*KWI.*'

More: Using OMB*Plus to Navigate Repositories - Sample with :

• OMBCC
• and OMBDCC

Documentation, Example, Model

• OWB - OMB Data Dictionary / Properties
• Using OMB*Plus to Navigate Repositories - Sample with OMBCC and OMBDCC
• OTN- OWB Scripting Language - Home Page 10g
• Warehouse Builder API and Scripting Reference

Reference

• Common code within experts