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...]>
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.
| 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 |
| 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.) |
| -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 |