QUESTION:
What is the SQL History List?
ANSWER:
The SQL History List is an often over-looked feature of DB Query Tool. Located in the top right corner of the DB Query Tool interface, it shows the last 20 SQL queries executed by the user, as shown below:
By selecting a query from the drop-down list, it is automatically inserted into the current window.
QUESTION:
Where is the SQL History List stored?
ANSWER:
These recent SQL queries are stored in a file named 'TestODBCHistory.sql'. This file is located in the following default directory:
C:\Program Files\Common Files\MicroStrategy\TestODBCHistory.sql
QUESTION:
How can the SQL History List be cleared?
ANSWER:
The queries in the SQL History list may be cleared through one of the following two methods:
KB16609
