OWB - OMB (Oracle Meta Base) Language
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 a OWB - OMB Data Dictionary / Properties which define the objects and their properties that you can manipulate
Article Related
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).
Snippet
Useful Command
| 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 |
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
- Using OMB*Plus to Navigate Repositories - Sample with OMBCC and OMBDCC