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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-41
Examples of INFO
•
The object schema version
Examples of INFO
•
These are examples of INFO queries:
mxtool INFO \\figaro.\$data*.*svol*.*
mxtool INFO \\figaro.\$*.*.*
mxtool INFO \\figaro.\$vol.subvol.file*
mxtool INFO \\figaro.\$vol.subvol*.file*00
•
This is an example of an INFO query on SQL/MX catalogs using a wild card:
mxtool INFO \$DATA09.ZSD0.CATSYS0*
File Name: \FIGARO.$DATA09.ZSD0.CATSYS00
Object Schema Version: 1200
Ansi Name: NONSTOP_SQLMX_FIGARO.SYSTEM_SCHEMA.CATSYS
Ansi NameSpace: TA
File Name: \FIGARO.$DATA09.ZSD0.CATSYS01
•
This is an example of an INFO query on a volume that does not exist:
mxtool INFO \$VOL.SUBVOL.FILE
*** ERROR[20362] Error 14 was returned while validating the
file set list specified by "$VOL.SUBVOL.FILE".
•
This is an example of an INFO query on a node that does not exist:
mxtool INFO \\SQUAW.\$DATA09.ZSDT6TG2.HSNZ4500
*** ERROR[20373] The specified system does not exist in the
network.
•
This is an example of an INFO query on a file that is not an SQL/MX object:
mxtool INFO \$DATA09.XYZ.MXCMP
*** ERROR[20357] File \FIGARO.$DATA09.XYZ.MXCMP is not an
SQL/MX object.
•
This is an example of an INFO query on a file that does not exist:
mxtool INFO \$DATA09.ZSDT6TG2.HSNZ4500
*** ERROR[20355] File $DATA09.ZSDT6TG2.HSNZ4500 was not
found.