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.

Discussion
AbeK 37 comments Joined 08/09
23 Dec 2010

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 !!

fgrimmer 660 comments Joined 04/09
23 Dec 2010

Yes, this is something we will look in to.

Thanks for bringing it to our attention.

svilenss 3 comments Joined 01/11
08 Feb 2011

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?

strattok 5 comments Joined 10/09
08 Feb 2011

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.

fgrimmer 660 comments Joined 04/09
08 Feb 2011

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

fgrimmer 660 comments Joined 04/09
08 Feb 2011

@strattok,
Thank you for clearing this up.

nryberg 4 comments Joined 08/10
24 Feb 2011

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

fgrimmer 660 comments Joined 04/09
24 Feb 2011

Can you verify you have installed 64-bit JVM?

nryberg 4 comments Joined 08/10
24 Feb 2011

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

fgrimmer 660 comments Joined 04/09
25 Feb 2011

Can you send me the error log (.log). It is located in the install .metadata directory.

gnosi612 3 comments Joined 06/10
30 Jul 2014

Hi all,  I've a similar problem.
I create this macro:

replace  macro syslib.mymacro(anno integer, mese integer) as 

(

 

call syslib.LastWorkDay(:anno, :mese,UGM);

 

);

 

If I run this macro on sql assistant with ODBC it works.

If I run this macro on eclipse using jdbc driver I receive this error:

 

Executed as Single statement.  Failed [3706 : 42000] Syntax error: expected something between the beginning of the request and the end of the request. 

Elapsed time = 00:00:00.007 

 

Thanks in advance.

Giovanni

 

 

 

 

fgrimmer 660 comments Joined 04/09
30 Jul 2014

Giovanni, How are you running the macro, from the SQL Editor 'execute macro' statement or from the Data Source Explorer (right click on a macro and choose Run... menu option)? The error message indicates that nothing was passed in the request to the database. Can you try to run the call statement that is inside the macro in the SQL Editor. Copy the call statement and paste into the SQL Editor and see if it runs successfully.

You must sign in to leave a comment.