QMF provides several ways for you to view the name of the database to which you are currently connected. Viewing the current database name can help you orient yourself if you are accessing data in more than one location.
When you connect to a new database, that location name is displayed below the Connected to heading on the QMF Home panel:
Licensed Materials - Property of IBM 5675-DB2 5697-F42 (C) Copyright IBM Corp. 1982, 2000 All Rights Reserved. IBM is a registered trademark of International Business Machines _________________________________________________________________________________ QMF HOME PANEL Query Management Facility Version 7 ****** ** ** ********* ____ Authorization ID ** ** *** *** ** ____ CACLARK ** ** **** **** ******* ____ ** ** ** ** ** ** ** ____ Connected to ** * ** ** **** ** ** ____ DETROIT ****** ** ** ** ** _______ ** _______________________________________ Enter a command on the command line or press a function key. For help, press the Help function key or enter the command HELP. _________________________________________________________________________________ 1=Help 2=List 3=End 4=Show 5=Chart 6=Query 7=Retrieve 8=Edit Table 9=Form 10=Proc 11=Profile 12=Report
If the location name does not appear on the QMF Home panel (for example, if you lose your connection to the database, or if you are connected to a DB2 subsystem without a location name), you can view the database location name by displaying the global variable DSQAO_CONNECT_LOC. Enter:
SHOW GLOBAL
The GLOBALS panel displays with a list of all your QMF global variables. The value of the DSQAO_CONNECT_LOC variable is the location name.
For a list of all QMF global variables, see the QMF Reference.
You can view the location name by displaying the XCBCLOC field in the QMF control block DXEXCBA.
[ Previous Page | Next Page | Contents | Index ]