Notes

• The CONVERT command may also be used to improve the organization of an existing SQL query in temporary storage.
• If you specify more than 10 variables in the CONVERT command, the command is rejected with an error message.
• Variable names that don't match parameters in your query are ignored.

  If you defined your variables with the SET GLOBAL command, you do not have to specify them on the CONVERT command. A value specified on the CONVERT command overrides a value set with SET GLOBAL.

  If you have variables in your query and do not specify substitution values for all of them on your CONVERT command, a prompt panel is displayed. All supplied parameter values appear on the prompt panel. Any variable names included in your query that aren't assigned values are listed and a message is displayed.

• Queries cannot have three-part names.
• If you provide variables for substitution variables and also specify SUBSTITUTE=NO, an error message is issued.
• Do not enter a query comment as a variable value. Query comments are preceded by two dashes (--), which the database interprets as minus signs.
• When you convert a query and TARGET is specified as:
  • QUERY, the converted query is displayed in QMF temporary storage. If the query you want to convert is in QMF temporary storage, the converted query replaces it. If the query you want to convert is saved in the database, the converted query is placed in QMF temporary storage and displayed.
  • VARS, the converted query is placed into the ISPF dialog manager pool and the global variable pool; it does not replace the query in QMF temporary storage.
• A single QBE insert or delete query can result in multiple SQL queries. These queries are placed into a single SQL query object. However, all of the queries after the first query are turned into comments (each line is preceded by two hyphens).