OAHELPER

Overview

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..

Oracle Numeric Data types

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.

Syntax

oahelper [options]

-help | ?
Get OAHELPER help.

-version
Get the OAHELPER version number.

-nobanner
Prevents OAHELPER from printing the banner.

Environment Source From Database

-env
Operation

-env_dbtype=type
Database type. Valid types are:
ORA - Oracle
INF - Informix
ODB - ODBC
DB2 - DB2
SSV - SQL Server

-env_dbname=name
Database logical name

-env_dbtablelist=list
Table list. * for all tables

-env_envname=name
Environment logical name

-env_oracle_sqlnet=name
Oracle SQL*Net service name

-env_odbc_ds_type=type
ODBC data source type. Valid entries are:
S - System
U - User
F - File

-env_odbc_ds_name=name
ODBC data source name if ODBC data source type is System or User.
Fully qualified file name of the ODBC file data source, if ODBC data source type if File.

-env_dbphysical=name
Database physical name

-env_indexprefix=prefix
Index prefix

-env_dbusername=name
Database user name

-env_dbpassword=password
Database password

-env_dbversion=version
Database version

-env_out=filename
Output file name

DBINSTAL Script From Existing Installation

-dbinstal
Operation

-dbinstal_env=envname
Existing environment file.

-dbinstal_out=filename
Output file name

Environment Source From Existing Installation

-decomp
Operation

-decomp_env=envname
Existing environment file.

-decomp_out=filename
Output file name

Migration Script From Existing Installation

-migrate
Operation

-mig_env=envname
Existing environment file.

-mig_dbtablelist=tablelist
Table list. * for all tables

-mig_target_dbtype
Target database type. Valid types are:
FFL - Flat files
ORA - Oracle
INF - Informix
DB2 - DB2
SSV - SQL Server

-mig_target_os=osname
Target operating system. Valid os values are:
WIN - Windows
HPUX - HP Unix
SUN - Sun Solaris
AIX - IBM AIX
OSF - Compaq Tru64, OSF
LNX - Linux

-mig_redefrowids
Add REDEF_ROWID columns

-mig_indexprefix=indexprefix
Index prefix

-mig_migratedir=directory
Migration directory on local host.

-mig_targetdir=directory
Migration directory on target host.

Top