Notes

• QMF objects you do not own are listed only if they were saved with the option SHARE=YES.
• The pattern string used with the OWNER and NAME parameters can be specified as follows:
  • The % symbol represents a string of zero or more characters.
  • The _ symbol represents any single character.
  • Any other character represents itself.
  For example, to list all QMF objects with owners that contain the character D in the second position, enter:

    LIST QMF (OWNER=_D%

• When you request a list of objects, QMF displays them in the default order: owner first, then name. To change the default list order, you change the DSQDC_LIST_ORDER global variable.

  The DSQDC_LIST_ORDER global variable is a two-character value. The first character specifies the sort characteristic and the second specifies whether the sort is ascending or descending. Changing the value of DSQDC_LIST_ORDER applies only to the current session. The default value is 1A.

  The values are:

  First character:
  
   value     characteristic   sort sequence
             (primary key)
   -----     --------------   ----------------------
     1       Default          owner(current owner first)|name
     2       Owner            owner|name
     3       Name             name|owner
     4       Type             type|name|owner
     5       Modified         modified|last used|owner|name|type
     6       Last used        last used|modified|owner|name|type
  
  Second character:
  
   value   sort order
   -----   ----------
    A      Ascending
    D      Descending

  For example, to create a new list with the most recently modified objects at the top of the list, enter this SET GLOBAL command:

    SET GLOBAL (DSQDC_LIST_ORDER=5D

  To create a new list with the current owner's objects at the top of the list, enter this SET GLOBAL command:

    SET GLOBAL (DSQDC_LIST_ORDER=1A

  These examples do not change the order of an existing list.

• If you connected to a new location since you created the object list being displayed, your list is now obsolete. You must refresh the list, or cancel it and create a new one. Commands issued in the Action column of an obsolete list are not executed.
• You cannot list queries, procedures, or forms at a remote location using the Location parameter. To list these objects at a remote location, first connect to that location, then use the LIST command.
• When you request a list of tables, QMF uses views to retrieve the information:
  • If your current location is DB2 and you request a list from that location (if LOCATION is not specified or is specified to be the current location), QMF uses the view named in the global variables DSQEC_ALIASES and DSQEC_TABS_LDB2.
  • If your current location is DB2 and you request a list from a different DB2 location, QMF uses the view named in the global variables DSQEC_ALIASES and DSQEC_TABS_RDB2.
  • If your current location is DB2 for VM or DB2 for VSE, QMF uses the view named in the global variable DSQEC_TABS_SQL.
  • Issuing the LIST command when operating in QMF batch mode results in an error. Also, to issue LIST through the QMF command interface, LIST must be preceded by INTERACT (unless it is used from a Prompted Query dialog panel).

  For more information, see the discussion on customizing a user's database object list in the Installing and Managing QMF for your operating system.