CONVERT

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

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. 

CONVERT 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.

CONVERT 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.
[ Previous Page | Next Page | Contents | Index ]