Sample Micro Focus XDBC File

# This is a sample mfdbc.cfg configuration file. 
# You should edit it to match your needs.

# The following lines are commented out to show you the default values. 
# If you want to use a different value, then uncomment the line and change 
# the value.

#-----------------------------------------------------------
#---------------GENERAL SETUP OPTIONS-----------------------
#-----------------------------------------------------------
 
#  The path to your system catalog directory. This is a required variable 
 
dictsource "C:\Program Files\Micro Focus\XDBC 2.0\mfsyscat" 
 
 
#  The path to your data files.  You must prepend the line with a semi-colon, 
#  use either double backslashes ("\\") or forward slashes ("/"), 
#  and separate your paths by semi-colons. This is a required variable 
 
file_prefix ";C:/Program Files/Micro Focus/XDBC 2.0/mf_data;C:/Program Files/Micro Focus/XDBC 2.0/sample/mfdbc/mf_data" 
			  


#  Specify your data file extensions; leave blank if no 
#  extensions exist.

# file_suffix  
 
#----------------------------------------------------------- 
#-------------------ADVANCED OPTION SETUP------------------- 
#-----------------------------------------------------------

#  Values for File_Case are Default (case ignored),  
#  Lower (filename converted to lower case), and  
#  Upper (filename converted to upper case).
 
# file_case      default
 
#  To specify how MFDBC will treat non-numeric values in numeric fields,  
#  set this variable to Error (assignment error returned),  
#  Truncate (value truncated from first non-numeric value to the end),
#  or Zero (value returned will be zero).
 
invalid_numeric_data    error
# invalid_numeric_data  truncate
# invalid_numeric_data  zero 

#  Set this value to true if the user should have read-only  
#  permissions to this database. The default is read and write permissions.
 
# read_only       no
 
#  These two variables provide a representational mapping between COBOL's  
#  SPACES and LOW-VALUES and the corresponding SQL column values. 
#  Valid values are null and empty. 

# null_alpha_read null
 
#  Valid values are spaces and low-values.

# null_alpha_write      spaces
 
#  Valid values are null and 0 (zero).
# null_numeric_read     0
 
#  Valid values are spaces, low-values, and 0 (zero). 
# null_numeric_write     0
 
#  Enter a start date for Julian dates using the YYYYMMDD  
#  format. The default date is January 1, 1900. 
# julian_base_date 19000101

# This variable when turned off will cause Micro Focus XDBC to ignore the transaction
# options on operations such as an update. The default is on.
#
# transactions          on

# Tables in Micro Focus XDBC have an owner specified. The owner is either public
# or an authorization id. The ignore_owner variable can be used to have
# files show as no owner. This must be used in conjunction with loading
# through xdbcutil with the -o " " option to have a blank owner in the
# database. The default is FALSE.
#
# ignore_owner          off

#----------------------------------------------------------- 
#-------------------FILE OPTION SETUP-----------------------
#-----------------------------------------------------------


#-----------------------------------------------------------
#----------TRANSACTION PROCESSING SETUP OPTIONS-------------
#-----------------------------------------------------------
 

#-----------------------------------------------------------
#---------------------Multi-Company OPTIONS-----------------
#-----------------------------------------------------------

#  For multi-company handling, you can specify the value of any  
#  wildcards that you used when creating the table in your 
#  system catalog by noting the values here.
  
# filename_wildcards 

#-----------------------------------------------------------
#---------------LOGGING SETUP OPTIONS-----------------------
#-----------------------------------------------------------
 
# debug_logfile  
# debug_loglevel

#-----------------------------------------------------------
#-------------------END CONFIGURATION-----------------------
#-----------------------------------------------------------