SQL Assistant Java Edition 13.10 available

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

SQL Assistant Java Edition 13.10 available

Teradata SQL Assistant Java Edition release 13.10 is now available for download. SQLA JE is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built on top of the Eclipse Rich Client Platform (RCP) which allows SQL Assistant Java Edition to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

New features in this release include:

  • Updated for Eclipse 3.5.2 and DTP 1.8
  • Enhanced Result Set Viewer

    The Result Set Viewer provides an enhanced display of the Result Set data. It displays the result sets as tabs within the Teradata View, allowing the user to select rows or cells from the Result Set data table grid. The Result Set Viewer provides menu options to hide or show all columns, move and sort columns, find a value within the result set data, perform aggregate functions on selected numeric columns, filter column data, format cells, and copy cells. A toolbar with options to show the SQL associated with the result set, switch the display between text and grid display, switch the display between tabs and side-by-side sash display, and save, export, and print result set data is also provided.

  • Extensive SQL History View

    The SQL History View provides an enhanced display of the SQL History information. As SQL statements are executed from the SQL Editor or functions are run from the Data Source Explorer, an entry is placed in the SQL History. The SQL History view displays the data in a grid format, allowing the user to select rows and cells. The SQL History provides extensive information about the SQL execution, such as execution elapsed time, DBMS time, and fetch time, database server, row count, parameter display for macros and stored procedures, SQL statement, and SQL statement type. It provides options to copy cells or rows, sort columns, delete rows, edit the ‘Note’ or SQL for a SQL History entry, filter columns, search for result history data, format cells, and re-execute SQL statements. The SQL History uses an embedded Derby Database to manage the SQL History entries.

    For more information on using Teradata SQL Assistant Java Edition, refer to the article, SQL Assistant Java Edition.

12 REPLIES
Enthusiast

Re: SQL Assistant Java Edition 13.10 available

With a temporary password, the tool fails to prompt with a challenge window to change the password in contrast to the traditional SQLA tool. Is this a setting in the new tool that needs attention ?
BTW.. SQLA-JE Rocks !!
Teradata Employee

Re: SQL Assistant Java Edition 13.10 available

Yes, this is something we will look in to.

Thanks for bringing it to our attention.

Re: SQL Assistant Java Edition 13.10 available

I have the following statement:
select substring(usage_file_name,17,8) as us ,count(*)
from pa_db_stage.usage_appended_files_nstage
where dwh_entry_dt>'2011-01-01 00:00:00'
group by us
order by us;

It finishes successfully in SQLA, but on java platforms returns an error

SQL JE error - Executed as Single statement. Failed [3706 : 42000] Syntax error: expected something between the word 'USAGE_FILE_NAME' and ','.
Elapsed time = 00:00:00.101

STATEMENT 1: Select Statement failed.

What is the reason? JDBC driver does not support some SQL functionality?
Enthusiast

Re: SQL Assistant Java Edition 13.10 available

Someone with much more JDBC knowledge can answer why SUBSTRING is working using ODBC and not JDBC, with the format substring(usage_file_name,17,8), because I would think this should also fail outside of JDBC and the java environment.

Anyway, it looks like you are using the SUBSTR() syntax with SUBSTRING() function. The full syntax would probably be in the Teradata documentation 'Functions and Operators' or something like that.

Anyway, Teradata I believe recommends using SUBSTRING(), so the syntax would be substring(usage_file_name FROM 17 FOR 8).

In other words, starting at position 17 in usage_file_name, extract 8 characters.
Teradata Employee

Re: SQL Assistant Java Edition 13.10 available

@kerpal,
Can you be more specific? Are you in the SQL Editor view?
Teradata Employee

Re: SQL Assistant Java Edition 13.10 available

@strattok,
Thank you for clearing this up.
Enthusiast

Re: SQL Assistant Java Edition 13.10 available

I'm getting a null pointer error and a cryptic jface error when trying to do anything in 13.10 on 64 bit.
Teradata Employee

Re: SQL Assistant Java Edition 13.10 available

Can you verify you have installed 64-bit JVM?
Enthusiast

Re: SQL Assistant Java Edition 13.10 available

Yep - we had the first version of 13 up and running before this.