OWB - OMB (Oracle Meta Base) Language

Card Puncher Data Processing

About

OMB is :

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)

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

Reference





Discover More
Card Puncher Data Processing
Language - Scripting (also called Dynamic)

Some useful characteristics of scripting languages are: Convenience: Most scripting languages are dynamically typed. The type is not on the variable but on the value. You can usually create new variables...
Card Puncher Data Processing
OMBPlus

is the shell from the language OMB Note that directory paths are like Java - so ‘/’ or ‘\\’ in Windows You may need to unblock Windows firewall when prompted
Card Puncher Data Processing
OWB - OMB - Data Rules

Some examples for creating data rules from OMB. In the example below we create a single column rule that check that the column which can be supplied is > 300 - by default the custom rule has an...
Card Puncher Data Processing
OWB - OMB Class Properties Definition

This is the data dictionary/definition of the class properties for the OWB script language OMB. It was generated with OWB version 10.2. BATCH_MAPPINGMAPPING Properties: BUSINESS_NAME DESCRIPTION...
Card Puncher Data Processing
OWB - OMB Data Dictionary / Properties

When you need to create OMB script, you need to know the properties that you can modify. The documentation is really difficult to read and sometimes miss some properties. The script below gives you a way...
Card Puncher Data Processing
OWB - OMB snippet for Process Flow

Snippet of the OMB language to alter and create a process flow. Create the functions # Create the flow Add the IN parameter to the flow # Define the local variables used in the flow #...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...
Card Puncher Data Processing
TCL - Regexp - Regular Expression

The regular expression in TCL: - Match a regular expression against a string - Perform substitutions based on regular expression pattern matching The regexp command has as syntax: ...
Card Puncher Data Processing
Tool Command Language (TCL)

Tcl (from “Tool Command Language”) is a scripting language created by John Ousterhout. intended to be embedded into applications ( Oracle Warehouse Builder use it as scripting language : Mixed with...



Share this page:
Follow us:
Task Runner