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…

GENESIS_HOME

Specifies the location of the connect file. (The xfODBC driver also uses this environment variable.)

Specifying the connect file location (GENESIS_HOME)

GENESIS_MSG_FILE

Sets the name and location of the error message file. (The xfODBC driver also uses this environment variable.)

Specifying the error message file (GENESIS_MSG_FILE)

RPSDAT

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.

Specifying repository file locations

RPSMFIL

Specifies the path and filename of the repository main file.

Specifying repository file locations

RPSTFIL

Specifies the path and filename of the repository text file.

Specifying repository file locations

SODBC_CNVFIL

Specifies both that a conversion setup file is to be used and the path and filename of the conversion setup file.

Specifying a conversion setup file (SODBC_CNVFIL)

SODBC_CNVOPT

Instructs dbcreate (or DBA) to convert all fields in a structure, regardless of the report view flag setting in the repository.

Including and omitting fields

SODBC_COLLAPSE

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.

Generating one column for an arrayed field (SODBC_COLLAPSE)

SODBC_DBA

Specifies the location of the DBA program.

N/A

SODBC_NOGROUPNAME

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)

SODBC_NONULL

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

SODBC_NOUNSIGNED

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)

SODBC_ODBCNAME

Instructs dbcreate (or DBA) to use Repository Alternate name field attribute as the column name.

Renaming columns for clarity (SODBC_ODBCNAME)

SODBC_TMPOPT

Instructs dbcreate (or DBA) to convert only those tables not attached to temporary files in the repository.

Excluding tables attached to temporary files (SODBC_TMPOPT)

SODBC_TOKEN

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)

SODBC_USEFORMAT

Instructs dbcreate (or DBA) to use decimal information in the repository format string.

Using decimal information in the repository format string (SODBC_USEFORMAT)