Teradata’s latest and greatest Eclipse offering has been released and is available in the Teradata Developer Exchange download section (Teradata Eclipse_13.10.00). The 13.10.00 release builds on the 13.02.00 offering by boasting increased functionality.
The Domain Object Wizard feature generates a Java Domain Object class from a database table or view. A Domain Object is a class that represents a row of data from a database table or view. It contains class getter and setter methods for the column values. Domain Objects can be used with Java applications to display or persist data.
The Domain Object Wizard can be launched from the Data Source Explorer when selecting a table or view node. The generated Domain Object can be used with the Teradata iBatis SQL Map Wizard or the Teradata Spring DAO Wizard.
The iBatis DAO with Web Service Wizard generates a Web Service from an iBatis SQL Map. The wizard derives all of the information needed from the iBatis SQL Map to generate a DAO (Data Access Object), WSDL (Web Service Definition Language), XSD (XML Schema Definition), and Spring configuration file. These components are used to create a Web Service. The wizard then uses the Eclipse Web Tools Platform (WTP) and Apache Axis to generate the server and client classes for the Web Service. The generated classes include code that supports Query Bands via the Teradata Access Session Manager.
The Java User Defined Function wizard has been enhanced to include an option to select the type of Phase code template used when creating a Table User Defined Function. The Phase code templates are “fill-in-the-blank” Java code fragments. The code fragments contain a“switch” statement that manages the life cylce of the calls from the database to the Table function.
The following Phase Code Templates are provided:
Default Phase Template: This template supports the table modes “Constant” and “Vary.”
Extended Phase Template: This template gives the developer more control of the table function, enabling a reduction in phase transitions and a performance improvement over the default template.
Extended Phase Template with a Summary Row: This template allows the developer to add a summary row after all of the input rows have been processed.
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.
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.
If you are new to the Eclipse world, there is an article to help you get up and running. Please refer to Getting Started with Teradata Plug-in for Eclipse.
Online Help can be accessed within the plug-in in two ways:
Reference Documentation can be found on the download page or at: www.info.teradata.com