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)