OAHELPER is used to generate an initial prototype of an Omnidex Environment Catalog Source file against a target database. A text editor is then used to manually manipulate the generated source code to add desired characteristics.
OAHELPER works against any supported database that contains an internal schema such as Oracle, Informix or an ODBC accessible data base.
OAHELPER does not work against file structures such as POSIX flat files that do not support an internal data schema.
Use a text editor to manually create a source file when OAHELPER is not an option.
OAHELPER can be operated in one of two modes: prompt driven or through command line directives. Specific prompts and directives are discussed in each section and general command line syntax is shown below..
NUMBER is a proprietary data type invented and used by Oracle to store all numeric data types. It encompasses numbers of all sizes and precisions. Oracle will never return data in this data type, and they don’t publish its format. When using Oracle (even in non-OA Oracle apps that only use Oracle API), a valid numeric data type, INTEGER, FLOAT, etc..., must be specified. Knowledge of the data is required to pick the correct type.
OAHELPER will always use a FLOAT 8 (DOUBLE) because that data type is capable of handling the largest precision and largest numbers. It is recommended, though, that someone with knowledge of the data edit the environment file and alter those values to FLOAT 4, INTEGER, SMALLINT or TINYINT in order to preserve space and improve OA performance.
-help | ?
Environment Source From Database
DBINSTAL Script From Existing Installation
Environment Source From Existing Installation
Migration Script From Existing Installation