Gives a name to an executed query.
Quote-delimited string of up to 80 characters.
'' (the empty string)
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
You can assign the QUERY_NAME option any quote-delimited string value, up to 80 characters; for example:
set temporary option Query_Name = 'my third query'
When this option is set, query plans that are sent to the .iqmsg file or .html file include a line near the top of the plan that looks like:
Query_Name: 'my third query'
If you set the option to a different value before each query in a script, it is much easier to identify the correct query plan for a particular query. Doing this also prevents previous query plans from being overwritten. This option has no other effect on the query.
