The Query Analyzer (query editor) is used to edit SQL scripts. Caché Monitor can work with multiple editors open at the same time, execute scripts and process the results.
Some features in short:
- Handles multiple open connections
- Asynchronous database communication
- Support for parameterized SQL scripts
- Code completion (Intelli Sense)
- SQL Code folding
- Execute Scripts with single or multiple SQL statement
- Execute SQL statement at cursor position
- Execute selected SQL statement(s)
- Support for procedures producing multiple result sets
- View results as grid or text
- Execute Stored Procedures
- Execution plan visualizer
- SQL History
- Data Inspector shows results as text, html, xml binary and image
- Scripts Manager
- Use sql queries across namespaces
Here is a video that shows some features in action. Please see “Using the editor”
Open File Dialog with preview Feature
The File-Open-Dialog shows now a preview of the selected file with Syntax highlighting. This feature allows a much easier navigation to the right file:
Query Analyzer – Search\Replace and Goto Line Dialog CTRL-F; CTRL+H and CTRL+L opens the expected dialogs