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.
CONVERT a query in temporary storage (1) .-panelname------. >>-CONVert--+----------------+----------------------------------> '-QUERY----------' >--+-------------------------------------------------+--------->< | .-+---+------------------------------. | | | '-,-' | | | V | | '- (---+--------------------------------+-+-+---+-' | .-=-. .-Query-. | '-)-' +-Target-+---+-+-Vars--+---------+ | (2) | | .-=-. .-profile------. | +-CONfirm-+---+-+-Yes----------+-+ | '-No-----------' | | .-=-. .-Yes-. | +-Substitute-+---+-+-No--+-------+ | .-=-. | '-&variable-+---+-value----------'
CONVERT a query from the database .-QUERY-. >>-CONVert--+-------+--queryname--------------------------------> >--+-------------------------------------------------+--------->< | .-+---+------------------------------. | | | '-,-' | | | V | | '- (---+--------------------------------+-+-+---+-' | .-=-. .-Query-. | '-)-' +-Target-+---+-+-Vars--+---------+ | (1) | | .-=-. .-profile------. | +-CONfirm-+---+-+-Yes----------+-+ | '-No-----------' | | .-=-. .-Yes-. | +-Substitute-+---+-+-No--+-------+ | .-=-. | '-&variable-+---+-value----------'