Examples

1. To convert a query in QMF temporary storage into an SQL query and substitute a value of 38 for the variable DEPT in the converted query:

     CONVERT QUERY ( &DEPT=38

2. To improve the organization of an existing SQL query. For example, suppose the SQL query in temporary storage was:

   SELECT 'JOB',JOB,'SERIAL',ID FROM Q.STAFF 
       WHERE ID<99 ORDER BY 2

   The converted query after running the CONVERT command would be:

     SELECT 'JOB', JOB, 'SERIAL', ID
     FROM Q.STAFF
     WHERE ID < 99
     ORDER BY 2

3. To convert a query from the database named QBEQUERY into a SQL query in QMF temporary storage:

     CONVERT QUERY QBEQUERY

4. To convert a query from the database named MYQUERY into a SQL query, and put it into the ISPF dialog manager pool and the global variable pool:

     CONVERT QUERY MYQUERY ( TARGET=VARS