OMBENV - environment variables

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - OMBENV

This command lists the values for all Warehouse Builder-specific environment variables.

  • To set an environmental variable, use the Tcl set command.
  • Use unset to unset an environmental variable.

2 - Environment Variable

Environment Variable Meaning Possible Values
OMBTIMER Enables timing on each Warehouse Builder scripting command. The time is logged to a log file and to the console or shell.
OMBLOG Stores the filename for Warehouse Builder log file. A valid filename including its path.
OMBPROMPT Indicates whether OMB*Plus will update the command prompt each time you call OMBCC. A Tcl boolean value
OMBCONTINUE_ON_ERROR Ignores errors that occur in any command that is part of a script and moves to the next command in the script. A Tcl boolean value
Advertising

3 - Possible values

Normally in the documentation, the possible value of the environment variable are a Tcl boolean value (true or false) but it's not true. Once an environment variable is set, its value is considered as true. You have to unset it if you want that its behaviour ends up.

The proof:

/> OMBDCC
/
/> set OMBTIMER youpio
youpio
/> OMBDCC
/
Time elapsed: 0 milliseconds.
/> set OMBTIMER 0
0
/> string is boolean $OMBTIMER
1
/> OMBDCC
/
Time elapsed: 0 milliseconds.
/> unset OMBTIMER
/> OMBDCC
/

4 - Snippet

/> set OMBTIMER true;
true
/> set OMBPROMPT true;
true
/> set OMBLOG "C:/temp/mylog.log";
C:/temp/mylog.log
/> set OMBCONTINUE_ON_ERROR false;
false
/>
/> OMBENV
OMBTIMER = true
OMBLOG = C:/temp/mylog.log
OMBPROMPT = true
OMBCONTINUE_ON_ERROR = false
Time elapsed: 63 milliseconds.

The content of the log file :

OMBENV
OMBTIMER = true
OMBLOG = C:/temp/mylog.log
OMBPROMPT = true
OMBCONTINUE_ON_ERROR = false
Time elapsed: 63 milliseconds.

5 - Documentation/Reference