This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10 Edition 2. The focus of this release is on usability and performance.
Please see What’s new in Teradata SQL Assistant 13.10 for details of the new features that were added to the original 13.10 release.
An Open Recent Query menu has been added to the File menu. Whenever you open or save a Query file the file name will be added at the top of this menu. To re-open the file at a later time simply click on the file name in the displayed list.
A new tool button has been added to the Query toolbar. Clicking this button while the start/end delimiters of a logical block are highlighted will select the entire block. For example:
New options have been added to the Code Editor tab to allow you to specify the Font Style (Bold and or Italic), in addition to the color, for each type of syntax element.
When saving an Answerset window that contains multiple tabs you will now be asked whether you wish to save all tabs to a single Excel workbook.
The Current Data Source filter can now be used even if you are connected to multiple data sources. This filter will cause it to display the History rows for all data sources that you are currently connected to. If you are not connected to any data source it will display the rows for the data source that you were most recently connected to.
A Re-Connect item has been added to the Tools menu. This allows you to reconnect to a data source after the session was dropped for any reason. (Such as your computer having gone into hibernation) By using this menu you will not need to Disconnect or re-enter your connection information in order to reconnect.
Note that the Re-Connect menu applies to the current Query window only. If you were connected to multiple data sources you will need to reconnect each one individually.
You may now specify a color to be associated with each data source. This color will be displayed as a narrow stripe across the top of the Query window when you are connected to that data source. In addition, the Data Source node in the Database Explorer Tree will be underlined using this color. This feature is intended for those who connect to multiple data sources at one time. Using the feature should help to ensure that you do not accidentally submit a query to the wrong data source.
The color can be set using the Advanced tab of the Teradata.Net or Oracle.Net connection dialogs. If you normally use ODBC you will need to create a Teradata.Net data source with the same name as your ODBC DSN and set the color for this data source. SQL Assistant will assume that they are the same data source if the names match, and will use that same color when you connect via ODBC.
Support has been added for the Oracle .Net Data Provider (ODP). If you use SQL Assistant to connect to Oracle it is strongly advised that you install this provider (from Oracle.com) and use this option whenever you connect to an Oracle system.
Performance has been improved when returning large numbers of rows. In general it will be much faster if you use Teradata.Net rather than ODBC. (This applies to the data return time only).
For Example. Retrieve 40,000 rows from dbc.columns
|13.10 Edition 2||7||48|
Here we have described many small enhancements that should make the application easier to use, and more responsive. I hope this article has made you eager to try the new version which is now available from the patch server (SQL Assistant 220.127.116.11) or on the Teradata Tools and Utilities (TTU) 13.10 Edition 2 Teradata Utility Pak CD.