Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

DBC Syntax

The overall syntax for the DBC program is:

 dbc [databank_filename [result_filename [sysdb_filename]]]

DBC Command-line Arguments

File name for the databank to check.
Sequential file created by DBC that contains the result of the verification.
Filename for SYSDB used by the databank to check. This filename is required if any tables are using collations. If not specified the correct sort order for such tables is unknown.

If the filenames are not specified on the command-line, the program prompts for the name of the databank file, a name for the result file and the name of the system databank (SYSDB) file.

If an error occurs when opening the databank file (e.g. file not found or file locked by another user), or while creating the result file, an appropriate error message is displayed.

If the SYSDB filename is not specified and it is found that tables in the databank use collations, these tables are not verified and a warning message is displayed.

If no errors are detected in the databank file, the following message is shown:

 No errors found

The result file then contains statistics describing the physical databank organization. Otherwise, error descriptions (see below) are written to the result file, and the following message is displayed:

 * Errors logged in result file

The result file should be examined to investigate the nature of the errors, see "Database Consistency" on page 59.

It should be noted that the DBC program returns an error status (or warning) to the operating system when an error (or warning) is encountered. This may be useful when running it from scripts or in batch mode.

Exit Codes

DBC returns a status code to the environment executing the command. The status code can be examined by scripts.

VMS: On OpenVMS, the status codes correspond to the OpenVMS condition code severity levels.
Use the $SEVERITY symbol in DCL command procedures.

The following return codes are used:

0 (success)
1 (success)
This code is used when the DBC command has executed all options with no problems.
1 (warning)
0 (warning)
Other Error.
2 (error)
Databank error.

Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
Mimer SQL Documentation TOC PREV NEXT INDEX