Gateway Catalog Parameters
The gateway catalog build utility has the following optional parameters:
alias
Specifies the gateway alias previously defined that provides connection information to the host DBMS.
-d
Deletes all gateway catalogs, that is, standard catalogs and extended catalogs.
-m money_mapping
Indicates the data type mapping to use for the money data type.
Note: If you select the Float mapping, all data declared as OpenSQL Money is returned as Float.
Microsoft SQL
If you select the MONEY mapping for Microsoft SQL Server, all data declared as decimal(19,4), decimal(10,4), MONEY and SMALLMONEY is returned as OpenSQL Money data type.
FLOAT-default mapping
MONEY-map to money
Oracle
If you select the money mapping NUMBER(19,4) for Oracle, all data returned as NUMBER(19,4) is returned as money.
FLOAT-default mapping
NUMBER(19,4)-map to number(19,4)
-n num_mapping
Oracle only
Indicates the number (float) mapping scheme to use with Oracle where num_mapping is one of the following:
OPENSQL-Default mapping
INTEGER-Map to integer
FLOAT-Map to float
DECIMAL-Map to decimal
Note: For more information about number mapping, see the Oracle Number Mapping section in Developing Portable Applications.
-o dba
Specifies the gateway DBA name, which is the schema name that is checked if an object is referenced in an SQL statement that is not in the user's schema.
-p password
Specifies the password for the Gateway Catalog Owner-currently the Ingres user's host DBMS password.
-r
Unconditionally destroys and re-creates the extended catalogs. Any application metadata stored in these catalogs will be lost.
-s
This parameter is to be used only by the GUI iigwcat program when upgrading Microsoft SQL OpenROAD system catalogs. Use of this flag will corrupt the extended system catalogs. The -s flag instructs the catalog program to destroy and re-create the extended system catalogs (that is, the OpenROAD catalogs) without initializing them. This action deletes existing OpenROAD applications and also renders the catalogs unusable because they do not contain default empty catalog data; iigwcat is capable of initializing the catalogs (and also retaining existing applications). Do not use this parameter unless directed by Technical Support!
-w
(MSSQL gateway only) Indicates that Unicode extended system catalogs should be created for OpenROAD.
If system catalogs are already present, this flag will have no effect unless the -r flag is also issued.
If required information is omitted from the command line, the gateway catalog build utility prompts for it.