System catalog generation variables
The following environment variables enable you to change the way system catalogs are generated and modified. Unless otherwise noted, only dbcreate and DBA use these variables. These variables do not affect the way the xfODBC driver handles data. For information on environment variables that affect the way data is read from and written to the database, see Data access variables.
System Catalog Generation Variables |
||
---|---|---|
Environment variable |
Purpose |
See also… |
Specifies the location of the connect file. (The xfODBC driver also uses this environment variable.) |
||
Sets the name and location of the error message file. (The xfODBC driver also uses this environment variable.) |
||
Specifies the location of the repository files. The repository files must be named rpsmain.ism and rpstext.ism for this environment variable to locate them. |
||
Specifies the path and filename of the repository main file. |
||
Specifies the path and filename of the repository text file. |
||
Specifies both that a conversion setup file is to be used and the path and filename of the conversion setup file. |
||
Instructs dbcreate (or DBA) to convert all fields in a structure, regardless of the report view flag setting in the repository. |
||
Specifies when array elements should be compressed into a single column. Elements will be compressed into a single column when the number of elements is greater than or equal to the setting for this variable. |
||
Specifies the location of the DBA program. |
N/A |
|
Instructs dbcreate (or DBA) to omit group names, group prefixes, and struct field names from column names in the system catalog. |
Removing group and struct names from column names (SODBC_NOGROUPNAME) |
|
Deprecated. Determines how the “Null allowed” property for a system catalog column is set if the Repository “Null allowed” option for the repository field is set to Default. |
N/A |
|
Instructs dbcreate (or DBA) to ignore the Repository field “Negative allowed” and set all fields to signed unless they had validation ranges that were limited to positive values. |
Instructing dbcreate to ignore Repository’s “Negative allowed” field (SODBC_NOUNSIGNED) |
|
Instructs dbcreate (or DBA) to use Repository Alternate name field attribute as the column name. |
||
Instructs dbcreate (or DBA) to convert only those tables not attached to temporary files in the repository. |
||
Specifies a character for dbcreate (or DBA) to use to delineate position values in column names generated for elements in arrayed fields and groups. |
Changing the position delimiter used for arrays (SODBC_TOKEN) |
|
Instructs dbcreate (or DBA) to use decimal information in the repository format string. |
Using decimal information in the repository format string (SODBC_USEFORMAT) |