DB2 graphic  QMF Version 8

CONVERT

TSO With ISPF TSO Without ISPF CMS With ISPF CMS Without ISPF CICS
X X X X X

In DB2 QMF Version 8.1, the CONVERT command now supports long owner and table names. See Long names support in Version 8.1.

The CONVERT command converts a Prompted, SQL, or QBE query into a query with standard SQL syntax. Substitution variables can be replaced with values you specify or with values defined by global variables. CONVERT assigns values to variables and removes all original comments from the query.

Read syntax diagramSkip visual syntax diagramCONVERT a query in temporary storage

                        (1)
            .-panelname------.
>>-CONVert--+----------------+---------------------------------->
            '-QUERY----------'

>--+-------------------------------------------------+---------><
   |    .-+---+------------------------------.       |
   |    | '-,-'                              |       |
   |    V                                    |       |
   '- (---+--------------------------------+-+-+---+-'
          |        .-=-. .-Query-.         |   '-)-'
          +-Target-+---+-+-Vars--+---------+
          |                         (2)    |
          |         .-=-. .-profile------. |
          +-CONfirm-+---+-+-Yes----------+-+
          |               '-No-----------' |
          |            .-=-. .-Yes-.       |
          +-Substitute-+---+-+-No--+-------+
          |           .-=-.                |
          '-&variable-+---+-value----------'

Notes:
  1. The name of the QMF object panel currently displayed, if appropriate, is used.
  2. The value set in your profile is used.

Read syntax diagramSkip visual syntax diagramCONVERT a query from the database

            .-QUERY-.
>>-CONVert--+-------+--queryname-------------------------------->

>--+-------------------------------------------------+---------><
   |    .-+---+------------------------------.       |
   |    | '-,-'                              |       |
   |    V                                    |       |
   '- (---+--------------------------------+-+-+---+-'
          |        .-=-. .-Query-.         |   '-)-'
          +-Target-+---+-+-Vars--+---------+
          |                         (1)    |
          |         .-=-. .-profile------. |
          +-CONfirm-+---+-+-Yes----------+-+
          |               '-No-----------' |
          |            .-=-. .-Yes-.       |
          +-Substitute-+---+-+-No--+-------+
          |           .-=-.                |
          '-&variable-+---+-value----------'

Notes:
  1. The value set in your profile is used.


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