mfdbcutil Syntax

The mfdbcutil command has this syntax:

mfdbcutil [-l LOGFILE] [-d MFSYSCAT_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.

For use when creating the system catalog (for information on creating the system catalog, see the section Creating a System Catalog and Views.)
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 (for information on loading the system catalog, see the section Loading the System Catalog with Your XFDs.)
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 mfdbcutil 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 (for information on the GRANT SQL command, see the section GRANT (Database privileges.)

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
Note: All tables in a Micro Focus XDBC 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 mfdbcutil. 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.