Caché Monitor 1.64
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. 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). Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as `.` or `,` in an SELECT list. After typing the keyword ON in a JOIN clause, Cache Monitor displays foreign key join suggestion
Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read ("Format SQL"). The also supports of course: Undo/Redo and Search and Replace.
With Hyperlink navigation you can simple navigate 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.
* Workaround for Nullpointer on apple maschine
* The default user and password is set for the default connection from Caché Monitor to Caché at localhost
* If execution plan parsing fails, the html version is displayed --> see forum message for more details
* For backward compatibility is this version compiled with Java 5
What that means? You can run Caché Monitor with Java 5 but also using Java 6. Please use the right (jdk5) driver!
* Better support for big sql script files
* Changed separator from "GO" to ";"
* New SQL Formatter and SQL Parser
* Runtime/Execution information is displayed on the message panel
* Some minor bug fixes
Query Analyzer
- Executing stored procedures with CALL no longe raise exception if the resultset is bigger than 99 rows and the option "block fetch" is used.
- Better code complition in some situations
Server Navigator / Table Browser
- Max Rows and Max Chars can now be configured. Max Rows limit the rows fetched from server. Max Chars limit the size of charfields fetched from server
V 0.39:
This Version is a minor release for better support for Caché 2008.1
and his JDBC Driver. Use Java Runtime Environment 6!! AND Caché JDBC Driver for Java 6 !!
Query Analyzer
- The selected commit mode is now stored in query analyzer.
...Priodata Query Plan is a front-end...views to investigate SQL execution performance in...SQL view) and the...complete SQL statement and its...execution plan (taken from V$SQL_PLAN)....together with the execution plan, improving analysis....queries and joins. Query Plan really improves...the process of tuning Oracle applications. This...
...Query Master is a...fast multi-threaded SQL and PL/SQL tool...for developers and database administrators. Features: script...library; SQL and PL/SQL editor;...objects; powerful grid; SQL statement execution plan;...popup window with database objects; script import;...
...Export Query to SQL for Microsoft SQL...results of a query execution as a...set of INSERT SQL statements. Predefined or...options make this tool flexible. The program...handy utility helps database developers and database...to create query-based SQL script within seconds....
...Fast! is a tool to automate the...associated with the SQL tuning process on...of all alternative query versions you create...during the tuning process, run them...EXPLAIN PLAN, capture plan from V$SQL_PLAN, set...statistics results and execution plans) in a...interface to Oracle10g`s Tuning Advisor functionality. Select...
...Universal SQL Editor is a lightweight...Intellisense-enabled database query tool. It allows...connect Oracle, DB2, SQL Server, Sybase and...and edit complex SQL with Intellisense-like autocompletion,...hinting, syntax highlighting, SQL formatting, plus other...efficiently. In additional, query results returned by...

