DB2 graphic  QMF Version 8

Examples

  1. To get a list of all the forms that you own, enter:
      LIST FORMS
  2. To get a list of all the queries that begin with the name APP1, regardless of owner, enter:
      LIST QUERIES (OWNER=ALL NAME=APP1%
  3. To get a list of all the tables at the Dallas database server, regardless of owner, with the characters CUST in the name, enter:
      LIST TABLES (LOCATION=DALLASDB OWNER=ALL NAME=%CUST%
  4. When using the LIST command in a QMF procedure, you must use single quotes to continue an authorization ID across more than one line within a QMF linear procedure. All continuation lines must have a plus sign (+) in column one:
    Figure 8. Continuing an authorization ID across more than one line within a QMF linear procedure
    PROC                                          MODIFIED  LINE     1
     LIST ALL (
     + OWNER= 'LONGOWNERID9999999999999999999999999999999999999999999999999999999999
     +99999999999999999999999999999999999999999999999999999999%'
     + NAME = 'LONGNAME9999999999999999999999999999999999999999999999999999999999999
     +999999999999999999999999999999999999999999999999999999999'

    Note: Single quotes are allowed with the LIST command from the command line and the Proc panel. Single quotes are not allowed on the LIST Command Prompt panel.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004