SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—540440-003

5-82

VERIFY Operation

Considerations for VERIFY

Examples of VERIFY

VERIFY is an OSS command-line utility run from mxtool that reports whether

SQL/MX objects and programs are consistently described in file labels, resource forks,

and metadata.

object-option

specifies that VERIFY should be performed against all partitions and dependent

indexes of a table.

catalog.schema.object

is the fully qualified ANSI name of a table. If any of the three parts of the name is

an SQL/MX reserved word, you must delimit it by enclosing it in double quotes.

Such delimited parts are case-sensitive. For example: cat.sch."join".

VERIFY displays inconsistencies to the standard output file.

file-option

specifies that VERIFY should be performed against a file. Only a table object can

be specified.

[\node.]$volume.subvol.filename

is the Guardian qualified file name that describes the partition that is being queried.

In this four-part name, \node is the name of a node of a NonStop server, $volume

is the name of a disk volume, subvol is the name of a subvolume, and filename

is the name of an SQL/MX table or view.

If the name contains special characters such as “\” or “$”, you must precede these

characters with a backslash (\), or you can enclose the entire four-part name in

single quotes. For example:

\\node2.\$data3.sales.mytable or '\node2.$data3.sales.mytable'.

mxtool utility-operation

utility-operation is:

VERIFY { object-option | file-option }

object-option is: catalog.schema.object

name is catalog.schema.object

file option is: PART [\node.]$volume.subvol.filename