After a query has been saved to the Catalog, whenever you make changes to it, you will need to re-save the query to retain your changes.
Saving a query is similar to saving any other item to the Catalog, but consider the following query-specific considerations:
- When you save a query while viewing the Design or the SQL workspace, any saved personal or Super User grid layout will be discarded. The default layout will be saved and used the next time any user runs the query.
- If you save a query with invalid SQL syntax, an error will appear, pointing to the location of the problem within the SQL code.
- Links to queries whose names contain special characters may not function correctly. For example, the following issues result from using double quotation marks ("), the pound symbol (#), or angle brackets (<>):
- If a query name contains double quotation marks (") and you send a link to the query to an email recipient or the desktop, selecting the email link or the desktop shortcut will open the New Query window instead of the saved query.
- If a query name contains the pound symbol (#) and you send a link to the query to an email recipient or the desktop, selecting the email link or the desktop shortcut will cause Meridium Enterprise APMto display a message that the query cannot be loaded.
- If a query name contains angle brackets (<>) and you send a link to the query to an email recipient, selecting the email link will cause Meridium Enterprise APMto display a message that the query cannot be loaded. If a query name contains angle brackets and you send a link to the query to the desktop, the shortcut will function correctly.
- Depending on your query privilege settings, you may need to run the query before you can save it.
- To save a Super User grid layout for a query, you must use the Save for All Users option on the shortcut menu in the results. The save options on the Common Tasks menu will not save the current layout for all users, even if you are logged in as a Super User at the time you save the query.