This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 13.11. The focus of this release is on usability and Section 508 conformance.
This article assumes that you are already familiar with the features in SQL Assistant 13.10 Edition 2. If not, you may wish to read the following articles first:
Code Completion has been added to support the basic Select, Insert, Update, Delete statements.
While this option is switched on, a drop down list of suggested object and built-in function names will appear after the appropriate keywords or punctuation marks are typed.
As you continue to type the name you require the first matching name in the list will be highlighted. When the name you want is highlighted you can press Enter to select it. Typing other characters such as open paren or comma may also be used to both select the item and also enter the character you typed.
The following picture shows a sample drop down list that appears while typing a FROM clause:
The following picture shows a sample drop down list that appears after typing a period following a name:
The following picture shows the help information displayed when a built-in function is selected:
When using Code Completion to enter a Select statement you should type your From clause before typing the remainder of the statement. This will allow the application to add the columns contained within the tables and views in your From clause to the lists that will be displayed for other clauses.
Note that SQL Assistant works differently than other code completion implementations in that it remembers the tables and views that you have used in previous From clauses. This allows you to ignore the requirement to type the From clause first if subsequent statements access the same tables and views.
Please refer to the User Guide for more information on this topic.
If you wish to display a list of Database, Table and View names while entering another statement (such as Show Table) you can press Ctrl+Space to display the list.
The list of built-in functions is loaded from a pair of files called Teradata.mbr and TeradataA.mbr. These files can be edited to add your own User Defined Functions, or to remove built-in functions that you never use. If you are connected to another database, such as Oracle, the files Base.mbr and BaseA.mbr will be used instead. These files contain a small number of functions that are common to most database vendors. If you regularly connect to another vendor's database you may create your own mbr files specifically for that database. Please refer to the User Guide for more information on this topic.
Note - If you use the Teradata form of the From clause (a simple comma separated list) you must press Ctrl+Shift+Enter after entering the last table, view or alias name in your From clause. Alternatively, you can type the start of the Where clause. Both of these will cause SQLA to load the list of columns in that final table or view. (This is not required if you use the ANSI 'JOIN ... ON' syntax)
After you have used SQL Assistant for some time you may find that your History table has become cluttered with many duplicate entries and with queries that you no longer require. In the past the only way to clean up the History was to manually select those rows that you wished to delete.
In version 13.11 we have added a Cleanup History dialog to make this process simpler.
This dialog contains 2 sections.
Note: if you have a large History database this function may take several minutes to complete.
Teradata SQL Assistant 13.11 has been audited and found to be Compliant with Section 508: Subpart B—Technical Standards: § 1194.21 (Software).
Many new keyboard shortcuts have been added, and others that were previously undocumented have now been added to the documentation. Please refer to Appendix B of the user guide for a full list.
Some of the more frequently requested additions are:
|Ctrl + PageDown||Move to the next Query / Answerset tab|
|Ctrl + PageUp||Move to the previous Query / Answerset tab|
|Ctrl + F5||Restore the current child window to its previous size|
|Ctrl + F6||Move focus to the next child window|
|Ctrl + F7||Allows the arrow keys to be used to Move the current child window|
|Ctrl + F8||Allows the arrow keys to be used to Resize the current child window|
|Ctrl + F9||Minimize the current child window|
|Ctrl + F10||Maximize the current child window|
|Shift + F4||Tiles the child windows Horizontally|
|Shift + F5||Cascades the child windows|
|Shift + F6||Tiles the child windows Vertically|
Note that the shortcuts that move to the next/previous tabs will place the focus on the Tab itself - not the data area above that tab. You must press the Tab key to move focus to the data area. This is intended to allow a user who does not have a mouse to access the context menus for a tab.
In addition to the new Keyboard Shortcuts we have also improved support for the visually impaired.
The following items were already supported:
The following items have been added:
ODBC has the concept of User and System level data sources.
When using the Teradata.Net data provider however all data sources are created in the User branch.
This means that if the application is installed using a different User than the one who will be using the application then no data sources can be installed along with the application. In addition, there is no way to force a user to set the properties of a data source in a particular way.
In SQL Assistant 13.11 we have added the concept of System level data sources that can be used by all users of the client system. As with regular data sources the definitions are stored in a file called DataSources.config. The file for System data sources however is stored under the 'All Users' branch rather than under the user specific branch of 'Documents and Settings'. (or 'Users' on Windows 7)
An administrative user may modify any property of a system level data source (in reality they create a User level copy that masks the original System level data source) while a standard user may only modify a few properties such as the password and the identifying color.
When selecting a System level data source in the connection dialog a padlock icon will appear to the right of the data source name, and for standard users, many of the fields on the dialog will become disabled.
A new tool button has been added to allow you to delete any keyboard macros you have previously created. This tool also removes the keyboard shortcuts that were associated with those macros.
An option has been added to the Data Format tab to allow you to specify whether dashes should be displayed between each byte of a Binary string.
For example: 48656C6C6F or 48-65-6C-6C-6F
SQL Assistant will now remember whether you used the Current Column Only option when issuing a Find command for the History or an Answerset spreadsheet.
The application will remember this setting separately for History and Answersets since you may wish to search all columns of an Answerset, but would probably search within a single column in History.
Here we have described the main enhancements that should make the application easier to use by all users, including those with vision impairment. I hope this article has made you eager to try the new version which is now available from the Teradata patch server (SQL Assistant 13.11).