Integrated Query Analyzer with code completion (Intellisense) PDF Print E-mail

The Query Analyzer is fully integrated in Caché Monitor.

The Query Analyzer (SQL Editor) support developers with Code completion and an graphically execution plan with information about column selectivity and used/existing indexes.






Some Features:


  • You see the server side process ID (PID) of your connection at windows titlebar.
  • Code completion allows you to type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense).
    sql query  editor
  • Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as '.' or ',' in an SELECT list.
  • Caché-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL").
  • Undo/Redo
  • Search and Replace
  • Hyperlink navigation
    Hyperlink navigation is a mean for simple navigation from the editor to Tables metadata. When user presses the CTRL key and hovers the mouse cursor over a certain code element, the element is changed to a hyperlink. When user holds the CTRL key and clicks on the hyperlink, the go to Tables metadata action is performed.

    editor with hyperlink navigation


The following keystrokes control the code completion:

  • CTRL+SPACE - popup the code completion box. Code completion is automatically invoked after typing special characters as period ("."), comma (",") inside method argument and keywords as FROM or WHERE
  • ESCAPE - abandon code completion box.
  • TAB - selects the longest common substring matching the text you have typed (Bash-style context-sensitive completion) and keep the list box open.
  • ENTER - enter the selected item into editor and close the code completion box.
  • keeping typing if code completion is visible narrows down the selection of items in the list.
  • use the navigation keys (UP arrow, DOWN arrow, PAGE-UP, PAGE-DOWN, HOME, and END) or the mouse to scroll through the list and select an expression


More useful keystrokes:

  • CTRL+D
    duplicates current line
  • CTRL+N
    open further Query Analyzer on same Server and Namespace
    (with his own connection to the database)
  • CTRL+O
    open further Query Analyzer but you must select Server and Namespace
  • CTRL+F4
    close current Query Analyzer
  • F5
    execute (selected) SQL-Query
  • SHIFT+LeftMouseClick on Query Analyzer Tab
    close this Analyzer
  • RightClick on Query Analyzer Tab shows context menu


The following abbreviations exists:


SE = "SELECT * FROM "
IJ = "INNER JOIN "
LJ = "LEFT OUTER JOIN "
RJ = "RIGHT OUTER JOIN "
FR = "FROM "
WH = "WHERE "
OD = "ORDER BY "
cr = "CREATE INDEX IX_ "

editors database metabrowser


Since version 0.24 Caché Monitor shows foreign key join suggestions in SQL Editor

join-suggestion
The details for V 0.24 are:

Query Analyzer:
- Foreign Key JOIN suggestion. After typing the keyword ON Caché Monitor displays JOIN suggestion

join-suggestion

- The keyword CALL shows Stored Procedures in autocomplete box
- More autocomplete for sql keywors, functions, etc.
- Result to grid is now working
result-to-grid

- Result to grid fetch only blocks with blocksize of 100, after scrolling at the end next block is fetched
- Selecting a piece of text in the Script Editor will execute only that piece
- PK Columns are marked with red icon in autocomplete dialog

SQL Scanner
- DROP INDEX can be executed on selected index from SQL Scanner(Redundant Index finder)
- CREATE INDEX can be executed on selected index from SQL Scanner(Cached Queries Scanner)
- SQL Scanner / Cached Queries Scanner is no more case sensitive

General
- Login dialog box pops up if User or Password is missing in server konfiguration

login-dialog

- Caché Monitor is running on Java 6.0
- x button on the "select server/namespace" dialog has same behavior like the cancel button
- namespaces are now cached for each server, the connect to database with query analyzer is now faster

Image

- schemas are now cached for each server/namespace, the connect to database with query analyzer is now faster
- An Error dialog box displays the error message if something is happend

0.23 of Caché Monitor find redundant indexes with the buildin SQL Scanner.
sql-scanner-find-redundant-indexes

New Features and Bugfixes V 0.23:
Server Navigator
- Server Groups and Servers can now be rearrange with drag and drop
Query Analyzer:
- more autocomplete (SQL-Schemas are now listed)
- You can toggle with F8 between MetaBrowser and QueryWindow
- current line with cursor position is highlighted
- the autocomplete popup can be enabled/disabled with double click on statusbar
- Some general infos about editor: You can also highlight a block of code and press TAB to indent it all. SHIFT-TAB moves it all back. Bookmarks Insert or remove a bookmark CTRL+F2 Bookmarks Move to next bookmark F2 Bookmarks Move to previous bookmark SHIFT+F2 Editing Find CTRL+F Editing Go to a line number CTRL+G Editing Increase indent TAB
MetaBrowser:
- You can toggle with F8 between MetaBrowser and QueryWindow

Caché Monitor is an SQL development tool for InterSystems database Caché.

sql-scanner-main-view2-tuning.jpg


Features are:
# Advanced SQL Query Editor with:
* SQL Syntax highlighting
* Code completion
* Parallel (multi-threaded) queries
* Execution plan as Tree with index and selectivity information
# SQL DDL Code generation
# Namespace lookup
# Cachedquery list
# Processlist to view and terminate processes
# TuneTable for selected Tables or whole Namespaces
# Show Routine source code
# Select2Table Function

new Hyperlink navigation was added:

Image

Hyperlink navigation is a mean for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hovers the mouse cursor over a certain code element, the element is changed to a hyperlink. When you holds the CTRL key and clicks on the hyperlink, the go to Tables metadata action is performed.

In 0.19 the SQL History are redesigned, now it is more simple to find the right SQL Statement:

Image