SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-32
INFO DEFINE Command
INFO DEFINE Command
INFO DEFINE is an MXCI command that 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]