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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-32
INFO DEFINE Command
INFO DEFINE Command
INFO DEFINE displays the logical and physical names of DEFINEs in the current
MXCI session. (INFO DEFINE is similar to the TACL command INFO DEFINE and the
OSS shell command info_define.)
ALL
displays information about all the DEFINEs. If you do not specify ALL, the INFO
DEFINE command displays information about the current class MAP DEFINEs,
which are associated with the names of tables, views, or partitions.
Examples of INFO DEFINE
•
Display information about the current class MAP DEFINEs:
>> INFO DEFINE;
=ORDERS
$SAMDB.SALES.ORDERS
=CUSTOMER
$SAMDB.SALES.CUSTOMER
=ODETAIL
$SAMDB.SALES.ODETAIL
=PARTS
$SAMDB.SALES.PARTS
•
Display information about all the DEFINES:
>> INFO DEFINE ALL;
=ORDERS, class MAP, FILE \MYSYS\$SAMDB.SALES.ORDERS
=CUSTOMER, class MAP, FILE \MYSYS\$SAMDB.SALES.CUSTOMER
=ODETAIL, class MAP, FILE \MYSYS\$SAMDB.SALES.ODETAIL
=PARTS, class MAP, FILE \MYSYS\$SAMDB.SALES.PARTS
=_DEFAULTS, class DEFAULTS, VOLUME $SYSTEM.NOSUBVOL
INFO DEFINE [ALL]