xdbcutil Syntax

The xdbcutil command has this syntax:

xddbcutil [-l LOGFILE] [-d SYSCAT_PATH] [-x XFD_PATH] [-v] [-p] [-pa] [-n] [-s] <-c | -a xfd1 [xfd2...] | -f FILE> | -u xfd1 [xfd2...]>
Note: Use quotes or the short name if specifying a path that contains spaces. XFD filenames, when given, must be of the format:
xfilename[#[tablename] [#filename]]

where xfilename is the XFD filename, tablename is the SQL tablename to use, and filename is the COBOL data filename.

As shown in the tables below, some of the command options are used when creating the system catalog; others are used when loading the system catalog with XFDs.

See Creating a System Catalog and Views for information on using command options when creating the system catalog.

Option Description
-c Required — Creates a new system catalog
-d Specifies a directory for your system catalog. If none is specified, the system catalog is stored in the current directory
-n Specifies "do not overwrite" the user/group catalog if it exists
-p Creates a user/group catalog for granting database privileges
-pa Creates a user/group catalog and an object permissions catalog. A user/group catalog is for granting database privileges. An object permissions catalog is for setting permissions on your tables. Use the GRANT statement to set permissions in these tables

For use when loading the system catalog with XFDs. See Loading the System Catalog with Your XFDs for information on loading the system catalog.

Option Description
-a Adds an individual table definition from the specified XFD file. You can use either -a or -f to populate the system catalog with XFDs, but do not use both in the same operation
-d Specifies the location of your system catalog. Required if you are not in the system catalog directory when you issue the xdbcutil command
-f Adds table definitions from the specified file, which contains a list of XFD filenames. You can use either -a or -f to populate the system catalog with XFDs, but do not use both in the same operation
-l Defines the log output file name
-o Specifies table ownership. This must be a valid authorization ID that was created with the GRANT SQL statement for database privileges. See GRANT (Database Privileges) command for information on the GRANT SQL command.
-s

Says to include data storage method switch. Required if you are using XFDs created with a pre-8.0 version compiler, and used one of the data storage compiler options (-Dci, -Dcm, -Dcn...) when creating your XFDs.

If you compiled with any of the folllowing -D commands, then use the corresponding -s command:

-Dca / -s a

-Dci / -s i

-Dcm / -s m

-Dcn / -s n

-Dcv / -s v

-Dcb / -s b

-Dcr / -s r

-u Updates table definitions from the specified XFD files. Use this option if you have already loaded an XFD file into the system catalog but have modified it for some reason. Reloading a file with -a results in an error
-v Initiates a verbose reporting mode
-x Specifies an XFD file directory — required if your XFD files are not in the current directory

Minimum options

XFD filenames are of the format:

xfilename[#[tablename][#filename]] 
where
  • xfilename - is the XFD filename
  • tablename - is the SQL tablename to use
  • filename - is the Vision data filename
Note: All tables in a AcuXDBC database have an owner. By default, the owner of the table is PUBLIC, or you can specify a different authorization ID using the -o option to xdbcutil. 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.