xdbcutil utility

xdbcutil {[-?|-h]|-c}
   [ -a xfd[ xfd[...]]| -f xfd-filename-file| -u xfd[ xfd[...]]]
   [ -g {1|2}]
   [ -l log-file-name]
   [ -d mfsyscat-path]
   [ -x xfd-path]
   [ -o owner-name]
   [ -v]
   [ {-p|-pa}]
   [ -n]
   [ -s {switch[switch[...]]} 

-?

Writes usage to the screen. When specified, no additional parameters are taken.

-h

Writes usage to the screen. When specified, no additional parameters are taken.

-c

Creates a new GENESIS system catalog.

-a

Add an individual table definition from each specified XFD file.

xfd

An XFD specification of the following format:

x-file-name[#[table-name] [#c-file-name]]

Where:

x-file-name	The XFD file name
table-name	The SQL table name
c-file-name	The COBOL data file name

-f

Adds table definitions from a file containing a list of XFD file names.

xfd-filename-file

The name of a file that contains a list of XFD file names.

-u

Update an individual table from each specified XFD file.

Note: Use this option to update a table that was loaded previously using the -a or -f option, and has been modified since it was initially loaded.

-g

Enables you to update your existing catalog to support GENESIS_VIRTUAL table support.

Attention: Before using this option, back up your existing system catalog(s)!

1

Add the GENESIS_VIRTUAL record, which includes the TABLENAME and LASTROWNUMBER virtual columns, to the existing GENESIS catalog.

Note: This enables you to update your existing catalog to support GENESIS_VIRTUAL table support without having to reload all XFDs. For details on GENESIS_VIRTUAL, see GENESIS_VIRTUAL in your Product Help.

2

Creates a new GENESIS_COLUMNS entry of the system catalog.

Important: After upgrading to AcuXDBC version 10.5.1 Patch Update 1 from any previous version and before using AcuXDBC 10.5.1 Patch Update 1 use this option to enable certain enhancements unless you have already successfully reloaded all of your XFDs into the system catalog.

-l

Use to specify an alternative log directory and log file name. If omitted, this defaults to the current directory and logfile.log.

log-file-name

Specify the full path to and filename of the output log file.

-d

Specify an alternative directory for the system catalog. If omitted, the system catalog is stored in the current directory. Specifies the location of your system catalog. Required if you are not in the system catalog directory when you issue the xdbcutil command

mfsyscat-path

The full path to the system catalog directory.

-x

Specifiy an alternative directory for XFB files. If omitted, looks for XFD files in the current directory. Specifies an XFD file directory — required if your XFD files are not in the current directory

-o

Specify an alternative owner. The default table owner for all AcuXDBC databases is PUBLIC.

owner-name

This must be a valid authorization ID for database privileges that was created with the GRANT SQL statement. See GRANT (Database Privileges) command for details.

Note: If you don't want a table owner to be listed publicly in applications like Microsoft Access, specify -o, and set the IGNORE_OWNER variable to 1 (on, true, yes) in your configuration file. See IGNORE_OWNER configuration variable for more information.

-v

Initiates a verbose reporting mode.

xfd-path

The full path to the directory containing XFD files.

-p

Creates a user/group catalog for granting database privileges

-pa

Creates both a user/group catalog and an object permissions catalog. An object permissions catalog is for setting permissions on your tables. Use the GRANT statement to set permissions in these tables. See GRANT (Database Privileges) command for details.

-n

If a user/group catalog exists, do not overwrite it.

-s

Use one or more a data storage method conversion switches. This is required only when you are using XFDs created using a compiler version earlier than 8.0, and you have compiled using a -D storage option as specified in the switch section of this topic.

switch

One or more values that match the -D option(s) used to compile as follows:

Compiler option	Switch
-Dca	a
-Dci	i
-Dcm	m
-Dcn	n
-Dcv	v
-Dcb	b
-Dcr	r

See Data Storage Options for details.