Archives of the TeradataForum

Message Posted: Thu, 31 May 2012 @ 20:11:53 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: SQL Assistant history file questions

From:		Dempsey, Mike

SQL Assistant questions with respect to the history file:

1. Is there only one "history" file? If so, what is the file name? On my PC, I have a file named "SQLHistory.mdb" that seems to be the correct one, but I also have a file named "queryman.mdb". I'm guessing that is the history file from the previous version; can it be deleted?

<Ans>

Starting with version 13.0 there is now only one history file - SQLHistory.mdb (More accurately there is only 1 'active' history file. You can have other files in different directories but SQL Assistant will only work with one at a time). The old file(s) can be safely deleted (queryman.mdb and/or .mdb)

2. When SQLA starts up, a message is displayed that says something about "converting" a database. Some of our users report that this process takes a long time. Assuming the above is correct and this is "converting" the old "queryman.mdb" file into the new "SQLHistory.mdb" file, will deleting the old file eliminate this conversion step?

<Ans>

It probably isn't really converting the old file at this point - sometimes Windows fails to refresh the dialog message so the last one displayed still shows. (It is probably loading a large History file) I would recommend that everyone apply a history filter so that it only loads a limited set of rows.

For example, set the filter to load only the rows for the last 30 days. (Older versions defaulted to a limit of 200 rows to avoid this long load time. Since 13.x has much more flexible filter options however we do not set any filter initially.)

3. Although the SQLA documentation says the default history file location is "\Documents and Settings\Application Data\Teradata\SQL Assistant", on my PC it is "\Documents and Settings\\My Documents\NCR\Queryman". Again, I'm guessing this is an artifact of my previous SQLA install. Would it be prudent to move the history file to the "default" location (changing the path in the "options" window of course).

<Ans>

If you upgrade to 13.x from an earlier version most of your options will be kept.

This includes the location of the History file.

You can move it if you want consistency but it is really up to you where it is stored.

Some users who work on different 'projects' may create a new history file for each project and simply point to the appropriate one when they need to refer back to an old project.


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference