Teradata Studio Express is an information discovery tool that retrieves data from Teradata and Aster Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP). This allows the product to take advantage of the RCP framework for building and deploying native GUI applications to a variety of desktop operating systems. Teradata Studio Express can be run on Windows, Linux, and Mac OSX operating systems. The Eclipse platform is designed as an open tools platform but architected so that its components (or a subset of its components) can be used to build RCP applications. This allows Teradata Studio Express to benefit from the many high quality Eclipse features available while focusing on value-add for Teradata and Aster Database.

Teradata Studio Express includes the following key features:

  • Modular display that allows you to move panels around, creating a custom look and feel.
  • Connection Profile Wizard to create connection profiles using the Teradata or Aster JDBC Driver.
  • Data Source Explorer to view database objects, such as databases, users, tables, macros, stored procedures, user-defined functions, user-defined types, views, and triggers.
  • Data Source Explorer menu options to run Stored Procedures, Macros, and User-defined Functions.
  • SQL Editor to create, modify, and execute individual or multiple SQL Statements. This includes parsing the SQL statement for syntax errors and formatting the SQL according to selected formatting options (Teradata only).
  • AutoCommit options allows user to manually control autocommit of SQL Statements.
  • Support for Parameterized Queries including Named Parameters
  • SQL Editor Templates (INSERT, SELECT, DELETE, UPDATE, and more)
  • Result Set Viewer that displays result set data, allowing the user to select rows and cells, copy and format data, sort, hide, and move columns, and search for result set data values.
  • SQL History view that stores historical data for executed SQL statements with time values and status information.
  • Ability to export result set data as plain text, XML, HTML, CSV, as well as Excel format.
  • SQL Query Builder to visually build and edit SQL queries (Teradata only).
  • Data wizard to extract data from the Teradata or Aster Database to a file on the desktop.
  • Data wizard to load data from the desktop file system to the Teradata or Aster Database.
  • Table Data Editor to easily Update, Insert, or Delete data for a table.
  • Smart Loader to easily load delimited text or Excel files into Teradata or Aster.

Usage Videos

For detailed step-by-step demonstration of the Studio Express features, refer to the Studio Usage Videos article.

Modular Display

The Teradata Studio Express display includes the Teradata Studio Express Toolbar along with five view panels: the Data Source Explorer View, the Project Explorer View, the SQL Editor, the Teradata SQL History View, and the Teradata Result Set Viewer.

Teradata Studio Express contains a toolbar that provides buttons to allow quick access to functions that are used while creating and modifying SQL files.

A view can also contain its own toolbar and drop down menu. These toolbar buttons and menu items provide actions on the data managed by the view. Included in the view toolbar are buttons to minimize, maximize, and restore the view. Maximizing the view will cause the view to take over the entire Teradata Studio Express window display. Click the Restore button to return the view back to its previous display.

You can customize the look and feel of Teradata Studio Express by moving view panels within the main display window. A view can be moved by selecting the view and dragging it to a new location. As you move the view over the display, the mouse pointer will change depending on where you want to drop or dock the view. You can also drag the view outside the display area. The view will then become a "detached" view. You can also remove a view panel by clicking the "X" on the view tab. A view can be re-displayed by selecting the view from the Window>Show View option in the main menu. Or to return the views to their original display, click Window>Reset Perspective...

Data Source Explorer View

The Data Source Explorer View panel contains the database object tree display. It is here that you can create connection profiles to your Teradata or Aster Database systems and interact with the database objects. The Data Source Explorer view provides a hierarchical view of Teradata Database objects, nesting child databases and users within the parent database or user. Preferences are provided that allow you to choose which objects to load and display in the Data Source Explorer.

                  

Creating Connections

You can create connections to your database using the Connection Profile Wizard. The wizard is invoked from the Data Source Explorer by right clicking on the Database Connections folder or selecting the 'New Connection Profile' button, , from the Data Source Explorer toolbar.

          

Teradata Studio Express provides an option to create connection profiles for additional database servers other than Teradata.  You must provide the specific database server JDBC drivers for databases other than Teradata or Aster Database.

           

Select Teradata Database from the Connection Profile Types, enter a Name and click Next.

            

The Connection Profile Wizard is based on a driver template that references an embedded Teradata JDBC driver. Enter the database server name, user name, password, and default database name into the wizard dialog screen. The Authentication Mechanism allows you to choose an advanced logon mechanism, such as LDAP or Kerberos, or select the default mechanism, PASSWORD_PROTECTED. If you wish to save your password to disk, check the Save Password box. Otherwise, the password is stored in the profile and only active throughout the Teradata Studio Express session. When Teradata Studio Express is closed, the unsaved password is removed before the profile is written to disk. You will be prompted for the password the next time you connect to that profile.

Optionally, you can choose a different Teradata JDBC driver than the embedded Teradata JDBC driver. You can also add or remove the JDBC properties, as well as save the properties to an external file. The external file is called jdbcConnectionProperties.properties and located in the workspace .metadata/Teradata directory. The jdbcConnectionProperties.properties file allows you to share a set of JDBC properties with other Teradata Studio Express users. If the file exists when creating a new Teradata connection profile, it will load those property values into the list of JDBC connection properties. If the file exists but it is empty, the connection wizard will assume that no JDBC properties are specified and the Teradata JDBC driver will use the default settings.

You can also cache schema metadata, saving time when loading the database objects in the Data Source Explorer. Click the Cache Properties button to select schemas (or databases) to cache.

              

Aster Connection Profiles are created using a similar connection wizard with the embedded Aster JDBC Driver. Database server name, user name, password, port number, and database name fields are provided for user input. You can also cache Aster Database schema metadata to save time loading the Aster database objects in the Data Source Explorer.

SQL Editor

When Teradata Studio Express is launched, a SQL Editor area is provided for you to enter your SQL statements. Once you have a connection to your Teradata or Aster database, you can begin to enter SQL statements in the SQL Editor window.  Click the Save button to save the SQL Editor to a file in the workspace or Export to export the file to the desktop file system.

Another option to create a SQL file is through the Data Source Explorer. Within the Data Source Explorer, select your database connection and click the SQL Editor icon, , from the Data Source Explorer toolbar. This will create a SQL file in the SQL Editor with the name 'SQL Editor [n]' and the connection profile set to your database connection. You are now ready to enter your SQL statement. 

You can also open an existing SQL file, located in the Project Explorer, into the SQL Editor and associate it with a connection profile. SQL files can be imported into the Project Explorer from your local desktop file system. Right click on the SQL project and choose the Import menu option.

               

The SQL Editor provides a scratchpad for you to enter your SQL statements. As an option, you can enable the auto activation of code assist by clicking the  toolbar button. If this option is enabled, as you type your SQL statement, code assist will pop up annotations showing a list of expected keywords. If a database name is entered followed by a dot, the content assist will display the list of tables from your database for you to select from. (Note: By default, auto activation of code assist is disabled. Also, you must select a Teradata or Aster Database connection profile type in order for SQL code assist to work.)

Code assist will also provide a list of SQL Templates. At the start of the SQL statement, hit the Cntrl+SPACE keys and a pop up list of templates is displayed. Scroll down until you find the template you want and double click on it to insert the template into your SQL Editor file. Anchor fields are provided that you can navigate by tabbing. You can also edit or add your own SQL Templates via the SQL Editor Preferences page.

Parameterized queries can also be created in the SQL Editor. The query contains parameters indicated by question marks. When the query is executed, the user is prompted for the parameter value(s) in the Configure Parameters dialog. Named parameters (appending backslash ,'\',<parameter name>) allows the user to specify a name for the parameter. When the Configure Parameters dialog is presented, the parameters names will be used to reference the paramters.

           

 

           

The SQL Editor also provides syntax coloring for your SQL statements. You can change the colors of comments, keywords, identifiers, types, or other syntax items via the SQL Editor Preferences page.

When right clicking in the SQL Editor window, a SQL Editor Context menu appears with options to execute the SQL statement(s) in your SQL file.

                 

The following options are presented:

  • Execute all of the SQL statements
  • Execute the selected SQL statement
  • Execute the SQL statements as individual statements (with a commit occurring between statements)
  • Execute the selected statement as one statement
  • Execute the current statement where the cursor is located
  • Execute the SQL statements as a single transaction (Aster only)
  • Visual Query Builder (Teradata only)

You can also choose the Execute options from the SQL Editor or top level toolbar, , , .

Manual commit and rollback of the SQL Execution is also provided via SQL Editor toolbar options.

An Autocommit checkbox is provided in the SQL Editor to allow the user to toggle Autocommit on or off. By default, Autocommit is ON. If the option is turned off, then the Commit and Rollback options are enabled for the user to manually control the commit of their SQL statements to the database or rollback if an error occurs.

SQL Query Builder

Teradata Studio Express provides a graphical interface for creating SQL statements for Teradata, referred to as the SQL Query Builder. You can edit an existing statement using the SQL Query Builder by selecting the statement within the SQL Editor and choosing the ‘Edit in SQL Query Builder…’ menu option. (Refer to figure above).

    

In addition, you can open a SQL file in the SQL Query Builder via the Project Explorer menu item, Open With...>Teradata SQL Query Builder.

This option will open the SQL Query Builder inside the SQL Editor view. This allows you to drag and drop the table objects from the Data Source Explorer into the diagram area of the SQL Query Builder.

You can also add additional tables and table joins by right clicking in the SQL diagram area and select Add Table or Create Join options. When adding a table, a list of tables and views is presented for you to choose from. Click OK to save your SQL statement back to the SQL Editor.

Extract and Load Data

The Data Source Explorer provides an option to extract and load data using Teradata Load and Teradata Export. Large tables and files will use the JDBC FastLoad or FastExport option depending on the number of rows and column data types supported. Otherwise the JDBC load batch interface is used. Right click on the table and select the option from the Data drop down context menu.

Selecting the Load Data option invokes the Load Data Wizard. The wizard will prompt the user for the file to load and define the necessary file format needed to identify columns when loading data into the table. File format options include the column delimiter (comma, semicolon, space, tab, or vertical bar “|”) along with the character string delimiter (double quote, single quote, or none) and File Encoding. If data already exists in the table, the load data will append or replace the existing data. You can also indicate whether column labels are in the first row, as well as whether to lock the table during the load process.

            

Selecting the Export Data option invokes the Export Data Wizard. The user provides similar information as the Load Data Wizard.

           

The status of the data load or export job is displayed in the Transfer Progress View. When the job has completed, an entry is placed in the Transfer History View. To open the Transfer History View in Studio Express, go to Window>Show View>Transfer History View. Refer to the section below regarding the Transfer History View.

Sample Contents is another option on the Data menu. The Sample Contents option will perform a “SELECT * FROM <table> SAMPLE 100" SQL operation on the table and display the results in the Teradata Result Set Viewer. If a Sample Contents invoked on an Aster table, a "SELECT * FROM <table> LIMIT 100" SQL operation is performed. The Sample (or Limit) size can be changed in the SQL Handling Pereference page.

Smart Loader

The Smart Loader feature allows the user to load a text delimited or Excel file into a Teradata or Aster table. The Smart Loader is invoked from the Tables folder within the destination database.

Like the other load data utilities, the Smart Loader will prompt the user for the input file.

Next, the Smart Loader will scan the file to determine the "best" column types and present these to the user.

Clicking the ellipses button (...) provides an option to modify the column definition.

Next, the table DDL is presented. The user can choose the 'Show in Editor' option to save the table DDL to the SQL Editor and manually change the table definition. Otherwise, clicking Finish will execute the DDL statement and begin loading the data into the newly created table.

The status of the data load job is displayed in the Transfer Progress View. When the job has completed, an entry is placed in the Transfer History View. To open the Transfer History View in Studio Express, go to Window>Show View>Transfer History View.

The information in the Transfer History View is stored in an embedded Derby database. The data transfer job can be re-executed by selecting the entry and pressing the Re-execute toolbar button. The output of the transfer data job is displayed by pressing the Job Output button.

Table Data Editor

The Table Data Editor provides an enhanced feature to edit tables within the Data Source Explorer for Teradata or Aster tables. The data in the editor is broken up into pages, which allows for efficiency in updating large tables. Along with the standard insert, update, and  delete, data filtering, sorting, and in-memory filtering are also supported. The user also has the option of exporting the data to Excel or Text files.  It may be advantageous to export the data before it is modified.

The Table Data Editor is accessed via the table Data>Edit Data menu option. Select the table in the Data Source Explorer and right click and choose the Data>Edit Data... option.

The Table Data Editor will present the current rows of data from the table in a table grid display within the SQL Editor. You can click on a cell in the table grid to modify the cell contents or add a new row by clicking on the <new row> entry. A toolbar contains navigation aids and action buttons to control the row displayed, number of rows per page, page controls, as well as Filter, Sort, and Refresh actions.

Column operations are provided to hide or resize columns, find, replace or show values.    

           

Row operations are provided to copy and paste row data, insert and delete rows, or mark rows for export.

            

Row background colors are used to indicate whether a row has been updated (rose), inserted (yellow), or deleted (grey strike-through). These colors can be changed, along with other Table Editor options in the Table Data Editor Preference Page.

           

Depending on the edit option, a SQL UPDATE, INSERT, or DELETE statement is created. SQL Preview toolbar button, , is provided to show the SQL commands that will be run. Click the 'Commit Changes to the Database' toolbar button, , to run the SQL and commit the changes. A status message is displayed to indicate the actions committed to the database.

Project Explorer View

The Project Explorer View panel provides a hierarchical view of the Projects and their resource files. It is here that you can select SQL files for editing or create new SQL files. SQL files can also be imported from or linked to your file system. When Teradata Studio Express is first installed, an initial project called 'SQL' is created for you. You can create additional projects using the New>Project... menu option.

               

Within the Project Explorer, you can also choose an option to compare two files. The Compare Option displays the two files side by side with buttons that allow you to jump from one difference to another or move changes from one file to another. This is very handy when comparing SQL files or result set data.

The Project Explorer also provides an option to execute one or more SQL files from list of files.

          

Explain, SELECT Statement, and Row Count Menu Options

An Explain shortcut key,   ,in the toolbar or Tools drop down menu, will perform an EXPLAIN on a given SQL statement. You can also quickly invoke an EXPLAIN using the shortcut key sequence F6.

The SELECT statement option for tables in the Data Source Explorer generates a quick SELECT statement for the table in a SQL Editor window.

The Row Count option will perform a "SELECT Count(*)" SQL statement on a table or view in the Data Source Explorer.

                  

Result Set Viewer

The Result Set Viewer displays the result set or parameter data from executing SQL statements and running database routines, such as stored procedures, macros, user-defined functions, and triggers. The Result Set Viewer provides an enhanced display of the Result Set data. It displays the result sets as tabs within the Teradata Result Set Viewer, 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. Select a row or cell and right click to display the menu options.

       

Multiple result sets can be displayed as tabs or in a side-by-side sash display.

Large Objects (LOBS) can also be displayed in the Result Set Viewer. When a query result is being processed that contains an LOB result column, a dialog appears for the user to specify where and how to store the LOB values on the file system.

A toolbar is also provided with options to rename the Result Set tab, 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. SQL result data can also be saved to a file within your Project or exported to an external file in the file system.

If the Export or Export All option is chosen, the Export Result dialog is displayed. Select a file name, format, and export options. Then click the finish button to create the exported file. The Save option presents a similar dialog.

    

The following screen capture shows the result data with totals on integer columns as exported to an Excel file.

SQL History

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, edit the 'Note' or SQL for the SQL History entry, search for result history data, and re-execute SQL statements. Choosing the 'Edit SQL' option will open a SQL Editor file with the selected history entry's SQL statement. This allows users to further fine tune their SQL statements.

The SQL History view also provides a toolbar menu with options to delete rows or all of the history entries, filter columns, format cells, and sort columns, The SQL History uses an embedded Derby Database to manage the SQL History entries.

               

Object Viewer

The Object Viewer contains more detailed information about the database objects. When an object is selected in the Data Source Explorer, it is automatically displayed in the Object Viewer. You can click on the tabs to display additional information on the database object.

         

Help

Help is provided by clicking on the Help>Help Contents option in the main toolbar.

Conclusion

While Teradata Studio Express is not necessarily intended to replace the current Teradata SQL Assistant product, it provides an alternative for customers whose client platform includes systems other than Windows. Supporting multiple platforms (Windows 32/64, Linux 32/64, and Mac OS X) in this way allows customers to be more flexible when choosing a client operating system to connect to their Teradata or Aster Database system.

To download Teradata Studio Express, go to the Developer Exchange Downloads area and select Teradata Studio Express from the table.

To ask questions or discuss issues, refer to the Teradata Studio Forum and post your question.

Discussion
Bertax 2 comments Joined 12/11
19 Dec 2011

Thank you very much for this tool and related articles : they're very useful ! I'm trying to use this tool as Stored Procedures editor but i find some difficulties. When editing an existing SP and make error a dialog error appears "Save could not be completed".

Detail says "Failed to save to database: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.18] [Error 5526] [SQLState HY000] Stored Procedure is not created/replaced due to error(s).
[Teradata Database] [TeraJDBC 13.10.00.18] [Error 5526] [SQLState HY000] Stored Procedure is not created/replaced due to error(s)."

There's a way to catch and see from SQLA JE same error detail that comes out in SQLA ? I mean with detail of error (and line) ?

Thank You

fgrimmer 660 comments Joined 04/09
19 Dec 2011

The error message is nested in the SQL Exception. We will look to fix this so that it is exposed. As a workaround, execute the CREATE or REPLACE PROCEDURE statement from the SQL Editor (select the statement text and right click and choose Execute Selected Text). The Result column of the SQL History will have the complete SQL error.

bobduell 1 comment Joined 10/07
20 Dec 2011

Interesting tool. Question: are the JDBC "FASTLOAD" and "FASTEXPORT" options described in this article really running the corresponding server utilities? If not (as I suspect), should they be renamed to avoid confusion? Just curious!

fgrimmer 660 comments Joined 04/09
20 Dec 2011

The FastLoad and FastExport options are using the Teradata JDBC Driver FASTLOAD and FASTEXPORT options. The JDBC Driver uses the Teradata Database FastLoad/FastExport protocol to load or export data. Of course, the table must meet the criteria, such as supported data types, for FastLoad or FastExport to be used.

21 Dec 2011

Can I use this version of Teradata Studio Express in order to develop Java UDF, Java Table Functions, etc.?
If yes, where can I find actualized info and samples about it?

regards,

Carlos G. Varela
Freelance - BI Project Manager / Solutions Architect
+34 616307704
carlos@varela.com

fgrimmer 660 comments Joined 04/09
21 Dec 2011

It you are developing Java objects, such as UDFs or Stored Procedures, you should be using the Teradata Plug-in for Eclipse. It provides Wizards and Dialogs to step you through the process. Here is the link to download: http://downloads.teradata.com/download/tools/teradata-plug-in-for-eclipse. Also there is an article to help you get started: http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse. At the bottom of the article are links to other articles to help with Jave UDFs.
Teradata Studio Express is based off the same plug-ins used in Teradata Plug-in for Eclipse.

22 Dec 2011

Thanks!

regards,

Carlos G. Varela
Freelance - BI Project Manager / Solutions Architect
+34 616307704
carlos@varela.com

rob.heise 2 comments Joined 04/11
29 Dec 2011

Does studio express support TDPID connection semantics similar to SQL Assistant, CLI or BTEQ?
Thanks
Rob

fgrimmer 660 comments Joined 04/09
29 Dec 2011

Studio Express uses the Teradata JDBC Driver to connect to Teradata. Let me respond with a section from the JDBC Driver User Guide:
"When the Teradata JDBC Driver establishes a connection to the Teradata Database, the
Teradata JDBC Driver composes a string value that is stored in the Data Dictionary System
Views LogonSource column, which is included in system views such as DBC.SessionInfo and
DBC.LogOnOff.
Note: All LogonSource values provided by Teradata JDBC Driver and other clients are
entered into the database in uppercase.
The Teradata JDBC Driver follows the format documented in the Teradata Data Dictionary,
section “System Views Columns Reference”, for network-attached LogonSource values.
Network-attached LogonSource values have eight fields, separated by whitespace. Teradata
Database composes fields 1 through 3; the Teradata JDBC Driver composes fields 4 through 8.
1 The literal “(TCP/IP)”, to indicate the connection type
2 TCP port number on the client system, in hexadecimal
3 IP address of the client system
4 Teradata Database hostname, known as the Teradata Directory Program Identifier
“TDPID”
5 Client process/thread identifier
6 Client system user ID
7 Program used on the client system
8 The literal “01 LSS”, to indicate LogonSource string version 01"
...more...
"Field 4 - TDPID (target Teradata Database hostname) Field
The TDPID field is composed of:
• Original Teradata Database hostname specified by application (without a COPnnn suffix).
For example, cs4300sl.
• followed by a semicolon: “;”
• and the Hostname or IP address of Teradata Database node that was connected. For
example, CS4300S1COP1/153.64.116.95.
• followed by a colon: “:”
• and the Port of the Teradata Database node that was connected. For example, 1025.
This TPID field is truncated to the space remaining in the 97 chars, after all the other fields are
composed.
An example value for this field when an application specifies the Teradata Database hostname
“cs4300s1” is: CS4300S1;CS4300S1COP1/153.64.116.95:1025
An example truncated value for this field when an application specifies a Teradata Database
hostname of “cs4300s1.sandiegoca.teradata.com” is:
CS4300S1.SANDIEGOCA.TERADATA.COM;CS4300S1COP1.SAN"

hhoeck 1 comment Joined 12/10
06 Jan 2012

Can I use TD Studio Express to connect to mySQL too? Do have a hint how to create such a connection?

fgrimmer 660 comments Joined 04/09
06 Jan 2012

We currently do not support MySQL.

craigf 2 comments Joined 01/12
22 Feb 2012

Queries on non-case sensitive varchar cols only return a match if the text string matches the case of the column data. A query executed in 'SQL Assistant' correctly returns rows regardless of case, yet that same query returns nothing in this tool. Is there a setting that will correct this problem?

fgrimmer 660 comments Joined 04/09
22 Feb 2012

This may be do to the Transaction Mode or TMODE setting on the connection profile. With Teradata Studio Express, the default setting for TMODE is ANSI (as recommended). You can change the TMODE of your connection profile to TERA mode in the JDBC Properties. (Select your connection profile in the Data Source Explorer and right click. Choose Properties then Teradata JDBC Connection. In the JDBC Connection Properties, click Add to add the TMODE=TERA property and replace TMODE=ANSI.) You can also save the JDBC Properties (click Save Properties) if you wish this to be the default when creating new connection profiles. Otherwise it will use the default, TMODE=ANSI.

craigf 2 comments Joined 01/12
23 Feb 2012

That was it, problem solved, thanks!

gabe.schenz 1 comment Joined 02/12
24 Feb 2012

I like Teradata Studio Express from what I have seen so far, but I have a couple items that would be good to address.

1) The default workspace is within the installation directory. It would be nice to have this installed on a server, so that we are working remotely we could log in to a server, rather than have data traveling back and forth over a network. Having user configurable workspace directories would be ideal in this situation. Could we have the workspace as a changeable thing, like in the regular version of eclipse?

2) It would also be nice to have the option of using plugins with TSE. Specifically, it would be great to be able to connect to version control repositories (e.g. subversion, git, etc). Is that on the roadmap? If not, could you add it?

Thanks for the great tool. I see a lot of potential, and look forward to further development!

fgrimmer 660 comments Joined 04/09
24 Feb 2012

@gabe.schenz, We are glad you like the tool. To address your comments:
1) Yes, you can configure the location of your workspace. When you install Teradata Studio Express, for example on Windows, the product is installed into the Program Files>Teradata>Client>14.00>Teradata Studio Express directory. The workspace is created, when you first bring Studio Express up, in your user directory designated by %HOMEDRIVE%%HOMEPATH%. You can also force Studio Express to use a different location for your workspace by changing the Target: in the desktop property or launching the product with the -data option. For example: sqlaje -data c:/myworkspace

I do know there are issues when there are roaming profiles and you try to use a local area network drive for your home drive.

2) We have considered including support for adding plug-ins to Teradata Studio Express. We will revisit this issue. In the meantime, Teradata does have a product called Teradata Plugin for Eclipse that supports the full Eclipse IDE plug-in environment. Teradata Studio Express is based on the same code set, as the Teradata Plugin for Eclipse product

bjteradata 11 comments Joined 11/11
12 Mar 2012

Is there a way to create a new SQL file without having to create it in a project. Also, is there a way to open up an existing SQL file that was created outside of the Teradata SQL Express and File->Save As, but not save it to a project and just have the file be created say on a user's desktop?

hmo8020 1 comment Joined 10/09
13 Mar 2012

Is there a way to integrate or at least share the workspace with an existing eclipse workspace?

PS: Not to mention that it would be nice if Studio Express would be just a plugin.

neckers 8 comments Joined 01/12
13 Mar 2012

Ms. Grimmer,

Thanks for your efforts with this tool. I'll be changing to a Mac soon, and I look forward to being able to connect to our TD instances without having to run parallels.

One slight problem I've found in my gap analysis is the lack of a "Show Definition" feature. I found a reference to this in a post on the SA Java Edition forum but never saw what became of it. Is this in TD Studio Express somewhere and I'm missing it, or is that still on the enhancement list?

Thanks.

bjteradata 11 comments Joined 11/11
14 Mar 2012

I still have the question about the saving of files, but today I ran into another bug. I was having problems with a "not responding" with the program so I had to Task Manger->End Task the Studio Express. When I went back in when I tried to connect to my database it said "the currently displayed page contains invalid values."

So I decided I would reboot. Nothing. I decided to try a repair install. Nothing. Luckily, I created that second workspace to get around the "you cannot share a workspace" problem when you open a second instance, so I copied it and overwrote what was in my "corrupted" workspace. Everything was fine then.

Any ideas there?

fgrimmer 660 comments Joined 04/09
14 Mar 2012

@bjteradata, You can only save to a file in the Project. But you can then export the SQL file to your desktop or local file system. You can also import a SQL file from your local file system into your Project.

As for your other problem, what were you doing when it stopped responding? Were you running a SQL statement? Is there an error message in the error log that you can send?

fgrimmer 660 comments Joined 04/09
14 Mar 2012

@hmo8020, Teradata Studio Express does not support all of the feature areas that a full Eclipse download may support. So it is not recommended that you share its workspace with an Eclipse installation. But we do provide a Teradata Plugin for Eclipse that includes all of the Teradata Studio Express functionality plus much more. You can install the Teradata Plugin for Eclipse from our Update site. Refer to the article Getting Started with Teradata Plugin for Eclipse for the link to our Update site (http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse).

fgrimmer 660 comments Joined 04/09
14 Mar 2012

@neckers, If you open the table, macro, stored procedure, view, etc. within the Teradata View, there is a SQL tab that will display the SQL definition for the database object. If the Teradata View is not already opened, then right click on the database object and click Show in Teradata View. If the Teradata View is opened, click on the tab so it is in focus and select the database object from the Data Source Explorer.

bjteradata 11 comments Joined 11/11
15 Mar 2012

@bjteradata,
I was running a query that had caused a spool space issue due to the inefficiency of the query (SELECT *). I thought it would be ok since I have Studio Express set to warn me about going over 2,000 lines and it usually asks. This time it just froze and I had to End Task. I can maybe send an error log. Is there a place where I can find that?

A new question. Is there a good way to get Studio Express to report on errors? Right now I am running dynamic SQL in some stored procedures and I am creating an error handler like this:
DECLARE EXIT HANDLER FOR SQLEXCEPTION
INSERT INTO MSG_LOG
and inserting my statements in there to know where the problem is. However, is there a standard way to get a line number in Studio Express or in Teradata in general?

bjteradata 11 comments Joined 11/11
15 Mar 2012

@fgrimmer,
I was running a query that had caused a spool space issue due to the inefficiency of the query (SELECT *). I thought it would be ok since I have Studio Express set to warn me about going over 2,000 lines and it usually asks. This time it just froze and I had to End Task. I can maybe send an error log. Is there a place where I can find that?

A new question. Is there a good way to get Studio Express to report on errors? Right now I am running dynamic SQL in some stored procedures and I am creating an error handler like this:
DECLARE EXIT HANDLER FOR SQLEXCEPTION
INSERT INTO MSG_LOG
and inserting my statements in there to know where the problem is. However, is there a standard way to get a line number in Studio Express or in Teradata in general?

fgrimmer 660 comments Joined 04/09
15 Mar 2012

@bjteradata, Even though the warning about hitting the result set row limit is displayed, the query is still run until it has completed and the result set is returned, unless you limit the query itself. The error log is located in your workspace .metadata\Teradata directory and called teradata.log.

Any SQL execution errors are reported in the SQL History. Studio Express exceptions are reported in the error log. Debugging a SQL stored procedure is talked about in Marcio's blog,
Let's talk about Stored Procedures (http://developer.teradata.com/blog/mtmoura/2010/04/lets-talk-about-stored-procedures). I hope that is helpful.

samsterling 5 comments Joined 06/09
16 Mar 2012

Hi. How do I export all result sets (from a multi statement query) to a single text file? I could do this in SQL Assistant, but I love the new tool (TSE), so I want to use it as much as possible.

Sam

fgrimmer 660 comments Joined 04/09
16 Mar 2012

The result sets are displayed within the Teradata Result Set Viewer as a single entry called Result Sets. Select the Result Sets tab and choose the toolbar option 'Export All'. 'Export All' will pop up a dialog for you to choose the file format and location. Then click Finish. All result sets will be exported to a single file.

neckers 8 comments Joined 01/12
19 Mar 2012

@fgrimmer Thanks very much. That's exactly what I needed. Thanks for your time.

heybret 1 comment Joined 03/12
03 Apr 2012

Thanks!

sellerjd 1 comment Joined 05/12
15 May 2012

Is there any way to use the Teradata TD2 authentication mechanism in Studio Express?

samsterling 5 comments Joined 06/09
16 May 2012

Use PASSWORD_PROTECTED in the Authentication Mechanism of the Connect dialog.

Sam

fgrimmer 660 comments Joined 04/09
16 May 2012

TD2 is the default authentication for Teradata V2R6.0 and later. As mentioned by @samsterling, this can be specified by the PASSWORD_PROTECTED option.

whbrownnc 2 comments Joined 02/12
21 May 2012

Hello... I am using Studio Express (Version: 14.0.0.201112070827 for 32-bit Windows XP). My server DB is running Version 13.0.1.19.
I have three basic questions:
1. EXPORT RESULT SET: I have several independent select statements that I would like to run, exporting each result set to its own fixed length text file. I understand how to do this interactively.
a. Can you tell me how to script this to run without intervention?
b. Can you tell me how to specify Excel as the target file type rather than fixed length?

2. I run these queries monthly. I currently manually update the WHERE clauses to read as follows:
where LOGGEDDATE > '2012-03-01 00:00:00.000' and LOGGEDDATE < '2012-04-01 00:00:00.000' and ...
Can I parameterize the Start and End timestamps? If so, could you point me to a code snippet that will show me how?

Thank you.

fgrimmer 660 comments Joined 04/09
21 May 2012

1.a. We don't currently have a scripting option but are looking at adding this capability in an upcoming release.

b. Excel is one of the file format options when exporting a result set.

2. Yes, You can parameterize the date values, such as:
where LOGGEDDATE > ? and LOGGEDDATE < ? and...
When you execute the statement, it will prompt you for the substitution values.

hardep 1 comment Joined 08/10
23 May 2012

When I attempt a FastLoad in the tool, get this error;

Starting FastLoad...
FastLoad Error Occurred: Message = Unexpected number of parameters
FastLoad processed row count: 0
FastLoad Failed

I know that all the column are accounted for. What can I look into to help load the data?

Secondly how can I ensure that the first row is ignored?

fgrimmer 660 comments Joined 04/09
23 May 2012

Make sure the column and string delimiters are set correctly. There currently is not an option to tell it to ignore the first row.

gboundy 2 comments Joined 05/10
26 May 2012

Re Jan 25 2012 entry WRT ctrl-C:

I unbound the ctrl-Insert and restarted as instructed but the ctrl-C did not work. I went back into the General / Keys and copied COPY, bound it to ctrl-C and set the WHEN to Editing SQL. That worked for me. It may have something to do with using a MacBookPro and VMware running XP where TD Studio Express is installed.

I could install TD Studio on the Mac, but I have to use VPN from XP to get into the Teradata environment -- longer story omitted...

graham boundy
consultant
Project X ltd
gboundy@pxltd.ca

lucasfilm 7 comments Joined 05/09
06 Jun 2012

Hi,
Just dicovered this product, and it looks promising. As a DBA I use SQL Assistant daily. So i wanted to test out this product. But I'm having difficulties trusting it. Plain SQL's returns zero rows. F.ex the one below returns 9449 rows in SQL Assistant, but 0 in the TD Studio Express! I have gone through all the settings but can't find anything that eplains this. Any ideá?
The SQL:
SELECT s1.DatabaseName,s1.TableName, columnname,
( ( ( HASHBUCKET ( SUBSTR ( FIELDSTATISTICS , 2 , 1 ) || SUBSTR ( FIELDSTATISTICS , 1 , 1 ) ( BYTES ( 4 ) ) ) / ( ( HASHBUCKET ( ) + 1 ) / 65536 ) - 1900 ) * 10000 + ( HASHBUCKET ( '00'XB || SUBSTR ( FIELDSTATISTICS , 3 , 1 ) ( BYTES ( 4 ) ) ) ) /
( ( HASHBUCKET ( ) + 1 ) / 65536 ) * 100 + ( HASHBUCKET ( '00'XB || SUBSTR ( FIELDSTATISTICS , 4 , 1 ) ( BYTES ( 4 ) ) ) ) / ( ( HASHBUCKET ( ) + 1 ) / 65536 ) ) ) ( DATE , FORMAT 'YYYY-MM-DD' ) AS LastSampled

FROM
(SELECT DatabaseName,TableName , columnname, FieldStatistics
FROM DBC.COLUMNSTATS
WHERE FIELDSTATISTICS IS NOT NULL
AND DATABASENAME = 'kvh_stage'

UNION
SELECT DatabaseName,TableName , columnname, INDEXSTATISTICS
FROM DBC.INDEXSTATS
WHERE INDEXSTATISTICS IS NOT NULL
AND DATABASENAME = 'kvh_stage'

UNION
SELECT DatabaseName,TableName , columnname,COLUMNSSTATISTICS
FROM DBC.MULTICOLUMNSTATS
WHERE COLUMNSSTATISTICS IS NOT NULL
AND DATABASENAME = 'kvh_stage') S1;
GROUP BY 1,2,3
ORDER BY 1,2,3;

fgrimmer 660 comments Joined 04/09
06 Jun 2012

One possibility is the connection session mode. The default session mode on the connection profile for Teradata Studio Express is ANSI, where SQL Assistant is TERA. You can change the 'TMODE' property in the connection profile by right clicking on the connection profile and selecting Properties, then Teradata JDBC Connection Properties.

lucasfilm 7 comments Joined 05/09
07 Jun 2012

Thanks for a quick reply. That little change (setting TMODE=TERA) helped. Then i got my 9449 rows back from this tool also. Great :-)

lucasfilm 7 comments Joined 05/09
07 Jun 2012

Another question. In SQL Assistant i like to back up the History file. I've read the documentation but can't find out where and how this (executed SQL's) are stored in Teradata Studio Express. Is it in "%Homepath%\workspace\.metadata\.plugins\com.teradata.datatools.sqldev.history\History\..." ?

fgrimmer 660 comments Joined 04/09
07 Jun 2012

The Teradata SQL History is stored in a Derby database, in the location you mentioned. You can back up the history file using the Export History toolbar option on the Teradata SQL History view. You can export the entire history or just a section of the history by selecting the rows you want to back up.

itlnstln 2 comments Joined 04/11
12 Jun 2012

One shortcut I LOVED in SQL Assistant was the ability to drag and drop fully-qualified object names from the DB Tree. Is there an option to do the same in Studio Express? I really like some of the additional features in Studio Express, but I miss this one (huge) time-saver. Thanks!

fgrimmer 660 comments Joined 04/09
12 Jun 2012

Yes, you can do the same drag and drop object names from the DSE tree to the SQL Editor. The names aren't fully qualified, but we can look into adding that as a preference.

itlnstln 2 comments Joined 04/11
12 Jun 2012

Thanks for your response! I apologize for not being clear; I was speaking specifically about the fully-qualified part. If it could be added later that would be tremendous. Thanks again!

lucasfilm 7 comments Joined 05/09
21 Jun 2012

I just cant figure out how to format Numerics in the Result set.
This SQL is shown formatted in SQL Assistant. But unformatted in Studio Express. We use "." as 1000 separator and "," as Decimal separator in Windows.

SELECT DATABASENAME (CHAR(25)) (TITLE 'DATABASE')
, (SUM(CURRENTPERM)/1024/1024) (NAMED CPERM) (FORMAT 'Z,ZZZ,ZZ9.99') (TITLE 'Space used MB')
, (SUM(MAXPERM)/1024/1024) (NAMED MPERM) (FORMAT 'Z,ZZZ,ZZ9.99') (TITLE 'Space Allocated MB')

F.ex the $NETVAULT_CATALOG database is shown like this:
"10426,205078125.","24173,738273620605.","13747,533195495605.","56,86970314598586."
While it ought to show:
"10.426,21","24.173,74","13.747,54","56,87"

fgrimmer 660 comments Joined 04/09
21 Jun 2012

The FORMAT clause on the SQL is not recognized by the JDBC driver. It is more of a BTEQ command and special consideration is made by the ODBC driver and thus SQL Assistant can take advantage of it as well. You can try the Result Set Viewer preference to Display 1000 separator.

lucasfilm 7 comments Joined 05/09
24 Jun 2012

I have tried it. It doesn't work. And there's no setup for how to show decimals in the Result Set Viewer either. So showing decimal numbers is not "pretty".

mhackerott 2 comments Joined 11/11
29 Jun 2012

I have been using Teradata Studio Express successfully until yesterday when upgraded Java. Now i get the following error when i start Teradata Studio Express "Failed to load the JNI shared library "C:\Program Files\java\jdk1.7.0_04\bin\..\jre\bin\server\jvm.dll". How do i point to the new jvm.dll file location?

fgrimmer 660 comments Joined 04/09
03 Jul 2012

Are you running Teradata Studio Express or Teradata Studio? Teradata Studio Express is geared for running SQL and managing the results where Teradata Studio includes administration features such as dialogs for creating database objects. Teradata Studio Express does not include the administration features. The download link for Teradata Studio is: http://downloads.teradata.com/download/tools/teradata-studio

What is the JDBC error you are getting when trying to connect?

WOJO 5 comments Joined 07/11
04 Jul 2012

Trying to use The Fastload option.... I run it however it loads no rows... I realize there is a data problem... I can load a few rows and its fine... My question is why no error msg's and
why do you drop the error tables if there are error's ???

WOJO 5 comments Joined 07/11
05 Jul 2012

Yes thats what Error Tables do.

Francine,
It looks as thou the Tool drops the error tables... I know there is a problem with 3 rows
by reviewing the Tool logs and DBQL however without error tables how do I identify them ?

WOJO 5 comments Joined 07/11
05 Jul 2012

I found where the error messages go..... hidden in the Teradata SQL History tab...

fgrimmer 660 comments Joined 04/09
05 Jul 2012

@WOJO, FastLoad uses the JDBC FastLoad option. It is JDBC that is managing the Error tables. As you mention, the results of executing FastLoad are displayed in the Teradata SQL History view. Any exception or error messages from JDBC are provided in the Note column of the SQL History.

Chuckbert 37 comments Joined 07/09
05 Jul 2012

@maheshteradata Since you've specified "/opt/teradata/teradatastudio" as the installation location, the executable is in the directory "/opt/teradata/teradatastudio/TeradataStudio". The executable's name is "TeradataStudio". Thus, to run the application you can do one of the following:

* Set your path to include "/opt/teradata/teradatastudio/TeradataStudio" and then run the program "TeradataStudio"
* Specify the full path name "/opt/teradata/teradatastudio/TeradataStudio/TeradataStudio" as the program to run
* Create a launcher on your desktop that specifies the program and double-click on that icon.

To create a launcher on your desktop you can:
* Right click on the desktop and select "Create Launcher..."
* In the Create Launcher dialog give it a name like "Teradata Studio"
* Click on the "Browse..." button and browse to the directory "/opt/teradata/teradatastudio/TeradataStudio" (starting with the "File System" under the Places
* Select the "TeradataStudio" in the Name list and press the "Open" button.
* Press the "OK" button in the Create Launcher dialog

There should now be a launcher on your desktop. Double clicking on it should run the application.

You can change the launcher's icon by right clicking on the launcher and selecting "Properties". In the properties dialog, press the "Select Custom Icon..." button and browse to the application's installation directory and select the "icon.xpm" file.

The steps I've given were done with Teradata Express 13.10. I assume they are the same with Teradata Express 14.0. I wanted to get you a reply and haven't had the time to install 14.0 in my VMWare.

Chuckbert 37 comments Joined 07/09
06 Jul 2012

@maheshteradata Teradata Studio requres Java 1.6 to run. That is the version of Java that is included in the Linux Teradata Express 14.0 I installed. It appears to be the same version that you are using. I installed Teradata Studio into the location that you have specified on that installation of Teradata Express and it works as expected.

Have you installed a different version of Java? Could you run the command "java -version" and post the results of that command?

As I said, Teradata Studio requires Java 1.6 but it does not include it in its package (if that is what you were asking whether it was built with the JRE).

fgrimmer 660 comments Joined 04/09
06 Jul 2012

Teradata Studio does not support Java 1.7 at this time. To install Teradata Studio on Linux, please refer to the Readme notes on the download page at http://downloads.teradata.com/download/tools/teradata-studio

sumedhpatil 5 comments Joined 06/12
10 Jul 2012

Hi,
I'm getting error while creating a connection profile. machine configuration, windows 7, Java 1.7, I suspect some error with the driver but not able to resolve it. could you please help?
following is the error :-
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.00.00.20] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Wed Jul 11 08:52:13 IST 2012 socket orig=testServer cid=11415e6 sess=0 java.net.UnknownHostException: testServer at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.(TDNetworkIOIF.java:149) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:233) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:87) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:582) at com.teradata.jdbc.jdbc.GenericStateController.(GenericStateController.java:41) at com.teradata.jdbc.jdbc.GenericLogonController.(GenericLogonController.java:40) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:200) at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.(TeraLocalConnection.java:99) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:54) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:218) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:151) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(Unknown Source) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(Unknown Source) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

fgrimmer 660 comments Joined 04/09
11 Jul 2012

I can recreate the problem if I set the JDBC property DBS_PORT to the wrong port number. Is it possible that you need to set the port number to something other than the default of 1025? If so, right click on the connection profile and select Properties. Select Teradata JDBC Connection Properties. Under the JDBC Connection Properties, select Add button and choose the DBS_PORT property and enter your port number. Click OK. Click the Test Connection to see if that worked.

sumedhpatil 5 comments Joined 06/12
11 Jul 2012

Thanks. but it didnot work. I'm getting unknow host error or login failure error. In JDBC driver settings I have set following properties
unknown host error or lgin failure:-Connect URL= jdbc:teradata://host:testServer other properties by default. do I need to make any entries in hosts file.
Kindly help. Thanks!

fgrimmer 660 comments Joined 04/09
11 Jul 2012

It is not clear from you message what properties you have added? Based on the previous error message, it is possible that your Teradata server may be listening on a different port number. But that should be the only property you should add. There are default properties, CHARSET=UTF8 and TMODE=ANSI, which should be left as is and just add the DBS_PORT (if indeed that is needed?).

sumedhpatil 5 comments Joined 06/12
11 Jul 2012

yes, I have kept the default settings for CHARSET and TMODE. about URL settings when I click on Edit Driver settings I have appended testServer to existing jdbc:teradata://host:
Other settings are as per snapshots given above. I may be making some obvious mistake but not able to pinpoint.

fgrimmer 660 comments Joined 04/09
12 Jul 2012

You do not need to edit the driver unless you are using a different version of the JDBC driver than the Teradata Embedded JDBC Driver. And in that case, you would only edit the Jar List. You do not need to edit the properties or URL. In the field 'Select a driver from the drop down list', choose the Teradata Embedded JDBC Driver.

sowmya.narayan 2 comments Joined 04/12
30 Jul 2012

Hi ,

Is there anyway i can get column headers when i use fast export. At present if i use fastexport , i am getting the text file without headers. Any help on this would be great..

fgrimmer 660 comments Joined 04/09
30 Jul 2012

No. FastExport is intended to just export the data.

sowmya.narayan 2 comments Joined 04/12
30 Jul 2012

Is there any solution to export the data with the headers. i cannot retrieve the data into result set as i have 1 million+ rows.

fgrimmer 660 comments Joined 04/09
30 Jul 2012

Not at this time. We are looking at adding this option for FastExport.

sumedhpatil 5 comments Joined 06/12
08 Aug 2012

Hi,
Thanks!! Issue is resolved now and I'm able to connect. I reinstalled it.

MK183200 3 comments Joined 03/11
16 Aug 2012

Hello!

I would like to use the "Create DDL" feature (on the Database level) to copy Table and View definitions to another database. Unfortunately, this feature doesn't seem to be very matured. I am running into the following problems:

.) Format specifications are missing,
.) "no check option" statements in soft references are missing,
.) the definitions are not in the order of dependencies ("create database" is the LAST statement created!)

The portation of DDLs is a topic that arises regularly in almost every project I attend, and we have no tool to easily do that without manual fiddling. Unfortunately, neither is Teradata Studio in its current state, although I think it would be the right place to look for this functionality.

Regards µX

fgrimmer 660 comments Joined 04/09
16 Aug 2012

We are looking at improvements to the Generate DDL for the next release of Teradata Studio to address these issues.

z1reticuli 1 comment Joined 09/12
25 Sep 2012

Is there a data set I could use at home to test several functions? I could get use of something like dummy airline data, or similar. I know I could find some on various data blogs, my questions is if TD provides a similar database to say AdventureWorks in MS SQL

::m

fgrimmer 660 comments Joined 04/09
25 Sep 2012

Not that I am aware of, unless the Teradata Express downloads come with sample data. You could post your question to the Database Forum.

muthuviswanath 1 comment Joined 09/12
30 Sep 2012

I could not create new database connection, please tell me what is the value that i have to give in the boxes.

fgrimmer 660 comments Joined 04/09
01 Oct 2012

Refer to the article above, section Creating Connections.

denee 2 comments Joined 10/12
24 Oct 2012

Why when I try to export the results of a result set to an external file (Plain Text format) do I end up with a zero byte file? This seems to happen with larger result sets but not smaller ones. In the case of a result set with 78,312 rows the resulting export file is empty. If I limit the same SQL query to pull in only, say 20,000 rows, it exports jut fine.

Is there some setting which puts a limit on the number of rows or size of the export file that can be created?

fgrimmer 660 comments Joined 04/09
26 Oct 2012

@denee, There is not a limit that we are setting. I know with Excel there is a limit on the Excel side when you have more than 65,000 rows. But I am able to export to plain text for very large result sets. My recent test was 200,000 rows. Are there any messages in the error log?

denee 2 comments Joined 10/12
29 Oct 2012

No error message at all. It appears as though it's exporting fine but then the resulting file is just empty. This seems to happen anytime the resulting file is over about 80k rows or 5MB in size. The only exception being if I export as HTML or XML. The works but obviously that format isn't really usable.

dlabar 5 comments Joined 06/11
30 Oct 2012

Could you please highlight the differences between Studio and Studio Express?

fgrimmer 660 comments Joined 04/09
30 Oct 2012

It may be that you are hitting a OutOfMemory exception. I have made a change to resolve this issue and will include in our upcoming14.02 release.

bjteradata 11 comments Joined 11/11
30 Oct 2012

If you "X" out of the tabs in the Teradata View, how do you get them back? I closed the tab for indexes and can't figure out to get it back.

Chuckbert 37 comments Joined 07/09
30 Oct 2012

If you close a tab and there are additional tabs still displayed for the object type, you can use the toolbar button with two arrows pointing at each other (or the view menu item "Restore Tabs").

If you've closed all the tabs for a type of object, you can restore them in the Preferences dialog. Under the "Teradata Datatools Preferences" item in the Preferences dialog is the "Teradata View Object Visibility" page. That page has all the hideable tabs listed. Check the tabs you want to see and they'll appear when you next select the object.

In our upcoming release we will warn you when you close the last tab of an object type. When the last tab is closed, the only way to restore them is in the preferences dialog (as you've found).

fgrimmer 660 comments Joined 04/09
01 Nov 2012

@diabar, Teradata Studio is an administrative tool. It includes dialogs and wizards to help you create database objects, such as databases, tables, stored procedures, macros, and views, as well as administering roles, profiles, and privileges. Teradata Studio Express is more intended for running SQL statements and managing the result set data, exporting to Excel, etc. All of the functionality in Studio Express is contained in Studio.

JMB 2 comments Joined 11/12
15 Nov 2012

This query is with regards to a suggestion made to Ian Pemberton who advised to run it in this arena. We at present Use SQL Teradata Asst to run our code on several Teradata Environments. I enquired whether there was a facility that enables you to change the colour of the Query screen depending on what teradata environment you reside within. We work on a number of Teradata platforms daily and it would help us, if this was in place as you would know instantly that you are entering a different Teradata environment as you flick around your sessions. It would also remove any potential chance of human error.
I believe the colour is defined at Application Level within SQL Assistant and the suggestion I would like to propose is that there is an option at Connection Level to change the colour of the query window. This would be of tremendous value to our team.
Ian has said Teradata Studio will shortly replace SQL Assistant and I wondered if this was a facility you could offer?

fgrimmer 660 comments Joined 04/09
15 Nov 2012

@JMB,This is an interesting feature and something we can look into for future functionality.

JMB 2 comments Joined 11/12
26 Nov 2012

fgrimmer Hi thanks would be gratedul of any information regarding this in the future.

davidhfeldman 5 comments Joined 04/10
26 Nov 2012

I was wondering how many sessions the FastLoad and FastExport functions in Teradata Studio Express open, and if there's a way to modify this setting (and if not, is that a planned enhancement down the road?).

fgrimmer 660 comments Joined 04/09
26 Nov 2012

During Teradata Studio Express FastLoad and FastExport, a separate connection is created that uses the JDBC FASTLOAD/FASTEXPORT option. It doesn't have access to the FastLoad protocol directly. What is it that you are wanting to do?

davidhfeldman 5 comments Joined 04/10
26 Nov 2012

I observed that running FastExport via a batch file using the FastExport command line program exports data much more quickly (minutes) than running FastExport via Teradata Studio Express (hours). Going through TSE is much easier though (point and click), so I was hoping there was a way to speed up the FastExport via TSE by changing the TSE Fastload settings to open additional sessions (which I assumed was causing the bottleneck).

But since TSE is tied to JDBC FastExport functionality, then there may not be a way to achieve parity between the FastExport command line and FastExport via TSE. I don't know enough about JDBC FastExport to say for sure.

fgrimmer 660 comments Joined 04/09
26 Nov 2012

@davidhfeldman, Currently there is not a way of changing the number of sessions created by the JDBC driver. Teradata Studio Express is using the JDBC default, which is 8. But according the to JDBC User Guide, it is not recommended that you change the value:
"The default value is 8 or the number of AMPs if the number of AMPs is less than 8.
Note: It is generally recommended to use the default value; that is, omit the SESSIONS parameter and let the Teradata JDBC Driver create the appropriate number of FastLoad or FastExport connections. "

milanroubal 1 comment Joined 07/09
06 Dec 2012

When will be the limit of the lines exported to excel fixed? As was here already written by
sowmya.narayan on 04 Aug 2012, when you try to export result between 32768 and 65535 lines, that is the limit of excel 2003, you get in log
java.lang.IllegalArgumentException: Invalid row number (-32768) outside allowable range (0..65535)
at org.apache.poi.hssf.usermodel.HSSFRow.setRowNum(HSSFRow.java:228)
at org.apache.poi.hssf.usermodel.HSSFRow.(HSSFRow.java:86)
at org.apache.poi.hssf.usermodel.HSSFRow.(HSSFRow.java:70)
at org.apache.poi.hssf.usermodel.HSSFSheet.createRow(HSSFSheet.java:201)
at com.teradata.datatools.dtp.sqltools.result.excel.ExcelOutputter.createDataRow(ExcelOutputter.java:351)

Thank you

dunnpj1 1 comment Joined 03/10
06 Dec 2012

Hi there. I have just started to evaluate Teradata Studio, & am impressed with the functionality that it provides (including most of Teradata Administrator & SQL Assistant).
One of the things that I've found is the FastExport & FastImport functionality. I can export & import small tables OK, but when I try to import larger amounts of data (i.e., over 2000 rows - we are talking a test system here), I keep getting the following error:

Starting FastLoad...

FastLoad Error Occurred: Error Code = 0
SQL State = null
Message = FastLoad Error: Batch is empty.

FastLoad processed row count: 1972
FastLoad Failed

I can't find any information on this error in the help or online. The FastLoad wizard does not give any options to change the batch size (as suggested in the JDBC documentation) - all help will be much appreciated!

fgrimmer 660 comments Joined 04/09
09 Dec 2012

@milanroubal, Support for Excel 2007, with export sizes over 65,535, is provided in Studio Express 14.02, targeted for January 2013.

AbhiG 1 comment Joined 01/13
09 Feb 2013

Hi Francine, I just downloaded tried to setup Teradata Express [TDE 14.00.00.01 for VMware (4 GB)] on my Windows 7 Laptop. I am getting the following error while trying to create a new connection-profile using the approach that you have show above:

Could not connect to New Teradata Database.
Error creating SQL Model Connection connection to New Teradata Database. (Error: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Sat Feb 09 15:54:16 EST 2013 socket orig=testServer cid=52fa7139 sess=0 java.net.UnknownHostException: testServer at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:34) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:644) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38) at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) )
[Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Sat Feb 09 15:54:16 EST 2013 socket orig=testServer cid=52fa7139 sess=0 java.net.UnknownHostException: testServer at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:34) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.(ConnectionInfoImpl.java:644) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38) at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45) at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Error creating Teradata Database connection to New Teradata Database. (Error: [Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Sat Feb 09 15:54:16 EST 2013 socket orig=testServer cid=502c79a5 sess=0 java.net.UnknownHostException: testServer at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source) at java.net.InetAddress.getAddressFromNameService(Unknown Source) at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:34) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) )
[Teradata JDBC Driver] [TeraJDBC 14.00.00.01] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Sat Feb 09 15:54:16 EST 2013 socket orig=testServer cid=502c79a5 sess=0 java.net.UnknownHostException: testServer at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source) at java.net.InetAddress.getAddressFromNameService(Unknown Source) at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.(TDNetworkIOIF.java:182) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:281) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:130) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116) at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:579) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:94) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:208) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:277) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73) at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnectionFactory.createConnection(TeradataJDBCConnectionFactory.java:34) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360) at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:166) at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

I am however able to use bteq in the console, as follows:

Your use is subject to the terms and conditions of
the click through agreement that brought you to this
screen ("TERADATA EXPRESS") EVALUATION AND DEVELOPMENT
LICENSE AGREEMENT), including the restriction that this
evaluation copy is not for production use.

TDExpress14.0_Sles10:~ # bteq

Teradata BTEQ 14.00.00.02 for LINUX.
Copyright 1984-2011, Teradata Corporation. ALL RIGHTS RESERVED.
Enter your logon or BTEQ command:
.logon 127.0.0.1/dbc

.logon 127.0.0.1/dbc
Password:

*** Logon successfully completed.
*** Teradata Database Release is 14.00.00.01
*** Teradata Database Version is 14.00.00.01
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.

*** Total elapsed time was 1 second.

BTEQ -- Enter your SQL request or BTEQ command:
select * from dbcinfo;

select * from dbcinfo;

*** Query completed. 3 rows found. 2 columns returned.
*** Total elapsed time was 2 seconds.

InfoKey InfoData
------------------------------ --------------------------------------------
LANGUAGE SUPPORT MODE Standard
RELEASE 14.00.00.01
VERSION 14.00.00.01

Could you please let me know where I am going wrong in creating the connection-profile?

fgrimmer 660 comments Joined 04/09
11 Feb 2013

@AbhiG, From the exception message, it looks like you are getting an Unknown Host error for the server testServer. Verify that you can ping this server. You can also try using the IP address in the Database Server Name.

free2bies 1 comment Joined 06/12
22 Feb 2013

i am getting an "failed to load jni shared library error"
i have jre1.6

fgrimmer 660 comments Joined 04/09
25 Feb 2013

@free2bies, When are you getting this message? Is it when you try to launch Teradata Studio Express? What platform and JRE do you have. If you are running 64-bit, you need to make sure you have the 64-bit JRE. What is returned when you run the java -version command?

swatisvl 6 comments Joined 01/13
13 Mar 2013

Hi Grimmer,
 
When i try to create a new connection what are the default credentials that i need to place so as to connect to TD database.
Database SErver Name:
UserName :
Password:
DatabaseName:
 
Also Do i need to add any jar files if i select "Teradata Embeded JDBC Driver" Please let me know as i am unable to create a new connection.

fgrimmer 660 comments Joined 04/09
18 Mar 2013

@swatisvl, You need to provide the information in the Connection Profile Wizard, such as Database Server Name, UserName, Password. The wizard will not let you continue if you have not provided the needed information. The default is to use the Teradata Embedded JDBC Driver. You do not have to provide any additional Jars if you use the default embedded driver.

jharvat 1 comment Joined 07/04
12 Apr 2013

Is there any way to change the size of the font in the Result Set column headings?  Is there a way to vertically resize the column headings like you were able to do is SQL Assistant?
Also, I really miss the ability to right click on a table, select SQL and create a ready made SELECT statement with all the column and table names filled in.  The CTRL+SPACE function give you the syntax - but it makes you do the work of filling in the blanks.  Not nearly as handy as the old fucntionality.  Am I just missing something on the new software?
Thanks!

fgrimmer 660 comments Joined 04/09
12 Apr 2013

There is not a way to resize the column header. For the SELECT statement, you would have to drag and drop the list of columns  to the SQL Editor. Our Teradata Studio product does generate a SELECT statement for a table. I will look at bringing that functionality to Studio Express.

Kenford 2 comments Joined 08/11
15 Apr 2013

Can someone help me with the "Failed to load the jni shared library C:\Program Files (x86)\Java\jre7\bin\client\jvm.dll" error?
I just installed Studio Express (TeradataStudioExpress__win64_x86.14.02.00.00.zip) on a new Windows 7 Enterprise x64 dual-core laptop.
I have the latest JRE:
java version "1.7.0_17"
Java(TM) SE Runtime Environment (build 1.7.0_17-b02)
Java HotSpot(TM) Client VM (build 23.7-b01, mixed mode, sharing)
I have rebooted my machine but to no avail.
Thanks for any help you can provide!

13 May 2013

Hi,
is there any possibility to access the same instance of the Teradata Studio by different users at the same time? Maybe by setting up another workspace?
Any hint would be welcome...
-Thanks in advance,
Frank

fgrimmer 660 comments Joined 04/09
13 May 2013

@Kenford, It is looking for 32-bit Java. It is possible that you have both 32-bit and 64-bit Java installed but it is only finding 32-bit version in your PATH. You have downloaded Studio Express 64-bit so it will need the 64-bit JVM.

fgrimmer 660 comments Joined 04/09
13 May 2013

@Frank, Yes, you can set up separate workspaces. This is described in the Release Definition. To run Studio Express and point to a different workspace, launch with the -data option and refer to the workspace directory:
-data workspaceLocation

Kenford 2 comments Joined 08/11
22 May 2013

Thank you for the help, Francine.  I removed all my Java installs and reinstalled the latest 64-bit JRE and now it is working.
I also ran into "java.lang.IllegalStateException: The platform metadata area could not be written" error as Windows was not allowing the .metadata folder to be created.  I resolved it by changing the Workspace Directory location to a new folder that does not begin with a dot.

peng.yu 2 comments Joined 06/13
17 Jun 2013

Hi, Fgrimmer
There is a character set problem. After connected TERADATA database, Chinese character display garbled.  Does this product support Chinese display? If support, how to be set?
For instance,
org_nm
��������

fgrimmer 660 comments Joined 04/09
18 Jun 2013

@peng.yu, Where is the display garbled? What version of Studio Express are you running? In an older version, there was a problem where the SQL Editor text was not displayed correctly. A workaround was to set the Text file encoding preference for the Workspace to the proper encoding (Go to Window>Preferences>General>Workspace and Choose Other and from drop down list choose the encoding). This was fixed in Studio Express 14.02.

peng.yu 2 comments Joined 06/13
18 Jun 2013

Hi, thanks for your reply.
Where is the display garbled?   Columns containing Chinese characters.
 What version of Studio Express are you running?  TeradataStudioExpress__win64_x86.14.02.00.00
'Text file encoding' Choose other UTF-8, Columns containing Chinese characters are still garbled.
 

fgrimmer 660 comments Joined 04/09
19 Jun 2013

@peng.yu, Check the CHARSET for your connection profile and make sure it is set correctly and the same for when the data was inserted into the database.

veehell 3 comments Joined 07/12
21 Aug 2013

I am using TDS since initialy released version (after my TD-Factory course). For me it is only tool to connect Teradata, Oracle and MS SQL (no more dbviz, plssqldev+,sql+,toad). TD and MSSQL was easy to configure. Many various issues came up later with setup for Oracle: two syntaxes for jdbc url, sid vs service_name, two driver classes, many different drivers, teradata studio versions.  So here is quick-quide.

  1. get working TNS entry for your Oracle instance
  2. download (ideally from OTN website) & install Oracle jdbc drivers (ojdbc6.jar) --> just put them to any folder you like
  3. run 'new connection profile' wizard --> choose Oracle as vendor and name your connection as used to
  4. install new jdbc driver --> choose "OtherOracle" --> provide JAR file location (from step #2) -->
  5. --> properties tab values to be like this:
  • Connection URL: jdbc:oracle:thin:@//
  • ​​Driver Class: oracle.jdbc.OracleDriver 

Note: for OracleThinDriver  11 looks like this: Connection URL: jdbc:oracle:thin:@server:1521:db

  1. save it,edit credentials, for jdbc URL use notation like this: jdbc:oracle:thin@tns-entry-without-identificator
  • jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.example.net)(PORT=1526))(ADDRESS=(PROTOCOL=tcp)(HOST=node2.example.net)(PORT=1526)))(CONNECT_DATA=(SERVICE_NAME=exam.prod.net)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=1))))

@moderators: ​I am posting it as comment here rather then as post in forum, but if missplaced anyway, feel free to delete/move it.

cheers
-vh-

John L 2 comments Joined 11/12
04 Dec 2013

Franscine What is the difference between Studio and Studio Express.  Which has the richer set of functions.
Thanks John L

John

fgrimmer 660 comments Joined 04/09
04 Dec 2013

@John, Please refer to the article that compares the 2 products (http://developer.teradata.com/tools/articles/teradata-studio-products-choosing-the-right-client-tool).

DarcyVoorhees 5 comments Joined 12/13
17 Dec 2013

I finally got TDExpress running on my Mac laptop yesterday. I can pull up a console window and through BTEQ do a sel * from dbc.dbcinfo and I get rows back, so I know Teradata is up. Now I'm trying to fire up the Teradata Studio Express that comes pre-installed on the version of Teradata thats running in my VMFusion instance. When I double click it fires up briefly, starts a screen and then shuts down immediately after - it doesn't even get to a recognizable GUI screen, it just flashed the frame and shuts down. I did some digging around and I found a log under root that says the following:

# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007fffed7d2df1, pid=6408, tid=140737328940816
#
# JRE version: 6.0_43-b01
# ava VM: Java HotSpot(™) 64-Bit Server VM (20.14-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [libpangoft2-1.0.so.0+0x18df1] pango_ot_tag_from_script+0x83f1
#
# If you would like to submit a bug report, please visit:

At this point I'm not sure how to troubleshoot the problem. Any ideas?

fgrimmer 660 comments Joined 04/09
17 Dec 2013

@Darcy, I have seen this issue reported within Eclipse. It seems to be that something has become corrupted running Teradata Studio Express within the VM.  Can you try to remove the following directory and restart Teradata Studio Express: workspace-studio/.metadata/.plugins/org.eclipse.core.runtime

DarcyVoorhees 5 comments Joined 12/13
17 Dec 2013

Will do.  Thanks for the quick reply.  Keeping my fingers crossed :)

DarcyVoorhees 5 comments Joined 12/13
17 Dec 2013

Worked like a champ thanks.

fgrimmer 660 comments Joined 04/09
20 Dec 2013

@hammadmn, The error message means that the host testServer is unknown to the client. Can you ping the system testServer? It is in your host file. Can you try the IP address to connect to the Teradata server?

hammadmn 2 comments Joined 07/13
21 Dec 2013

no, im unable to ping it...what are the credentail of it? and what setting I have to add in host file?
Once I try to connectiong wizard using DB Server Name= testServer, User=testUser and Password=dbc ....Authenioncation=Password Protected....? can you please guide me
 

fgrimmer 660 comments Joined 04/09
22 Dec 2013

@hammadmn, I don't know what the credentials are for you to connect to your Teradata Database. If this is a TD Express VM system, you can try using the IP address of the VM and the username dbc, with password dbc.

04 Jan 2014

 
Hi Francine,
I use Teradata Express Studio (TES) on a mac. In SQLA (on a PC) I used to be able to connect to a Teradata instance and then be able to simply add  databases I was interested in exploring as children of the DB connection node in the DSE.  How do I achieve the same in TES? Thanks!

fgrimmer 660 comments Joined 04/09
05 Jan 2014

Gopal, the default preference is to show databases and users in hierarchy display with child databases and users nested within the parent. To change to flat display, change the preference. Go to Window>Prefernces. Choose Teradata Datatools Preferences>data source explorer load preferences and uncheck Show Hierarchy Display. This will help to find your database or user.

sk73 3 comments Joined 07/09
06 Jan 2014

Hi,
I just had a question regarding "Copy/Compare" option. Can this option let us compare a table in one TD instance with another table in another TD instance? Eg: A development version versus current prod version where dev and prod are physically different boxes.
Thanks for all the help and putting up this detailed page. 
Regards,
SS

fgrimmer 660 comments Joined 04/09
06 Jan 2014

Yes. Connect to both database servers, open the Compare View and drag and drop the table to open the Copy Compare Dialog. 

dpatelia 1 comment Joined 01/14
08 Jan 2014

Hi , 
I have installed Teradata Studio Express , when I execute query it is not showing data in result pan, it is just showing column names. Can you pl. help me to resolve this ?
Regards
Daxesh

sk73 3 comments Joined 07/09
09 Jan 2014

Thanks Francine. It worked. I had some errors, but, read through the topic here and it was fine.

Another question: Row Count. How cna we know the actual row count? In the history tab, it displays 2000 because the limit is 2000, but, the actual count is different. Am I missing something?
Regards,
SS

fgrimmer 660 comments Joined 04/09
09 Jan 2014

@sk73, We used to get the actual row count from the result set but this can cause long delays when the rows returned is very large. So this was removed. You can manually get the row count via a Select count(*) from <tablename>; statement.

09 Jan 2014

Hi Francine, on my Mac version of Teradata Express Studio, I could get to Teradata Express Studio -> Preferences -> Teradata Datatools Preferences.  Where do I go from here to uncheck the hierarchy display.

fgrimmer 660 comments Joined 04/09
09 Jan 2014

@Gopal, In the Teradata Datatools Preferences, open (click) the Data Source Explorer Load Preferences and you will see the option Show Databases and Users in Hierarchical Display. You can uncheck that option.

12 Jan 2014

Hi Francine, now using Teradata Studio 14.10 and able to implement your suggestion.  Thank You.

15 Apr 2014

Hi Francine,
    Is there anyway to use teradata utilities(bteq especially) on a Mac OS to run scripts?  Does teradata studio express support bteq?
Thanks

fgrimmer 660 comments Joined 04/09
16 Apr 2014

Harish,  Yes. BTEQ on Mac OSX is available as part of the TTU Mac OSX released on the patch server under "MacOSX Suite". Teradata Studio Express does not support BTEQ.

newb1 1 comment Joined 09/13
22 Apr 2014

Hi Franine,
I've managed to get Teradat Studio Express 14.0.3 and attempted to create a test database but got this message after finishing the wizard...'Creating connections to database has encouted a problem. Could not connect to database.' I click the details button but no further details show up. I believe it may be similar to the issue above about the unknown host error. Is there a web page that explains what to do to fix this?
 

fgrimmer 660 comments Joined 04/09
23 Apr 2014

@newb1, If there was an error connecting, the error exception will be in the Details of the pop up dialog (Problem Occurred) and will also be in the Error Log. To open the Error Log view, select the top toolbar Window>Show View>Other...Then select General>Error Log. Click OK. In the Error Log view you should see the line with the message, "Error creating Teradata Database connection...". Double click on the entry to see the full error message.  As for how to fix the connection issue, it depends on what the error is. If it is 'unknown host' than the Database Server name or IP address is possibly not correct.

nirmal_hbti 2 comments Joined 04/14
25 Apr 2014

Hi All,

 

I am trying to load data from a CSV file into Teradata using the Fast Load from the Teradata Studio Express Version: 14.00.0.201112070827

 

The content in the CSV file is like:

9,Ernest Jordan,

14,K. MORIBE,

15,D. Jakominich,

408,F. Davidson,"Department of Dairy|University of Illinois , Urbana"

72011,Jose Raniere Ferreira de Santana,""

134431,Mario Testa,"Dipartimento di Fisica dell'Universit`a ""La Sapienza"" e Sezione INFN, Roma, Italy"

231,H. De Hoop,"ESSLLI  '98 Summer school class in Saarbrücken, August 1998, and the Stanford OT-Workshop ""Is"

25,William H. Nailon,

37,P. B. Littlewood,Cavendish Laboratory|Cambridge University

75,M. Till-berg,

 

I have a simple table of 3 columns:

CREATE  TABLE authordata.Author

(

        Id INTEGER NOT NULL,

        Name VARCHAR(100),

        Affiliation VARCHAR(1000)

)

UNIQUE PRIMARY INDEX(Id);

 

However with Fast Load I am getting errors like:

Starting FastLoad...

FastLoad Error Occurred: Message = Unexpected Token

FastLoad processed row count: 6

FastLoad Failed 

 

The problem seems to be with the following records in CSV:

134431,Mario Testa,"Dipartimento di Fisica dell'Universit`a ""La Sapienza"" e Sezione INFN, Roma, Italy"

231,H. De Hoop,"ESSLLI  '98 Summer school class in Saarbrücken, August 1998, and the Stanford OT-Workshop ""Is"

 

But I am wondering the same CSV file is loaded using the normal LOAD from the Teradata Studio Express and these records are successfully loaded in the Teradata Table.

 

This is the loaded data in the Teradata table when using the Normal Load:

 

37,P. B. Littlewood,Cavendish Laboratory|Cambridge University

15,D. Jakominich,null

75,M. Till-berg,null

9,Ernest Jordan,null

72011,Jose Raniere Ferreira de Santana,

134431,Mario Testa,"Dipartimento di Fisica dell'Universit`a ""La Sapienza"" e Sezione INFN, Roma, Italy"

25,William H. Nailon,null

14,K. MORIBE,null

231,H. De Hoop,"ESSLLI  '98 Summer school class in Saarbrücken, August 1998, and the Stanford OT-Workshop ""Is"

408,F. Davidson,"Department of Dairy|University of Illinois , Urbana"

 

Is there any workaround to make that run using the Fast Load? 

 

Thanks,

-Nirmal

fgrimmer 660 comments Joined 04/09
25 Apr 2014

Nirmal, This looks like a bug. We will look to see if there is a workaround.

harristd 5 comments Joined 07/12
01 May 2014

Hi Nirmal,
I was successfully able to load all 10 rows of the file you provided into the table you provided.  I used Fastload, with , (comma) as the column delimiter, " (double quote) as the character string delimiter, and file encoding as ISO-8859-1. 
When I was using the wrong encoding (UTF-8 for example), only some of the rows would get loaded.

cobra129 1 comment Joined 09/13
08 May 2014

Hello Francine,
I have a question regarding the JDBC Fastload/FastExport options. Do we have to install the full TTU (for example Teradata Fastload, Teradata FastExport) on the machine/computer before installing Teradata Studio Express for the JDBC Fastload/FastExport options to work? Or is everything included with the Teradata Studio Express installation? How about the JDBC driver?
Thanks,
Steven

fgrimmer 660 comments Joined 04/09
09 May 2014

Steven, You do NOT need to install TTU or Teradata FastLoad/FastExport. The Teradata Studio and Teradata Studio Express Load and Export features use the JDBC FASTLOAD and FASTEXPORT options. And the latest JDBC driver is bundled with Studio and Studio Express.

gpanesar 1 comment Joined 10/14
29 Oct 2014

Hi - May i know what is database servername, username and password I should use to connect teradata on 4GB version  

fgrimmer 660 comments Joined 04/09
29 Oct 2014

@gpanesar, The database servername is server name  or the IP address of your Teradata server. For Teradata Express, you can try username and password as dbc and dbc.

robvega81 1 comment Joined 02/14
02 Nov 2014

we can add more than one IP address on the server name in the connection in teradata Studio Express?

fgrimmer 660 comments Joined 04/09
03 Nov 2014

Roberto, No. Only one name can be entered for the Database Server Name in the connection profile. You can have multiple connection profiles though.

04 Nov 2014

Hi, 
I am new to database world, 
I recently installed Teradata Express Studio 15. and i m not able to create a new connection ..
Can anyone please help me out with this .?
I m not able to figure out the Database Server Name , Username , Password ..etc?

fgrimmer 660 comments Joined 04/09
05 Nov 2014

Sameer, The Database Server Name is the name or IP address of the database you are connecting to. If you don't have a Teradata database but want to try out SQL with Teradata Studio Express, you can download Teradata Express VM and use that. Refer to the following article for Teradata Express: http://downloads.teradata.com/download/database/teradata-express/vmware. Otherwise, enter the server name or IP address of the Teradata server, your username and password. If connecting to a Teradata Express system, the default username and password is 'dbc'.

raulbenet 3 comments Joined 11/14
07 Nov 2014

Hello Francine, I am new to Teradata. I wanted to test the spatial features of Teradata and as a first step I installed Teradata Express for WMWare Player -TDE 15.00.00.08 SLES 10 for VMware (40GB) viewpoint to be more precise.
Installation went great but unfortunately the default user (dbc/dbc) does not have CREATE TABLE privileges. I can't find the User Management section in the Teradata Studio to create a new user or to modify the dbc user to give them 'dba' rights.
Can you help me?
Thanks a lot

fgrimmer 660 comments Joined 04/09
07 Nov 2014

Raul, if you are running our Teradata Studio product, version 15.00, you must select the Teradata Administrator perspective. Then select the Databases Folder in the Data Source Explorer and right click. Choose Teradata>Create>User to invoke the Create User dialog. If you are running Teradata Studio Express (installed inside the Teradata Express), there are no dialogs for managing privileges. But, you can also enter the DDL or DCL commands such as CREATE TABLE and GRANT or REVOKE directly in the SQL Editor.

raulbenet 3 comments Joined 11/14
17 Dec 2014

Hello Francine, I am not sure if this is the right forum for the following question but since you were so helpful the last time (thanks for your answer by the way!) I will take my chances :)
I have table in Teradata Express that contains the countries of the world. The NAME column contains the country names and the GEOM colum contains their geographical information (the GEOM colum is of type ST_Geography). I created this table by importing a shapefile using Teradata's TDGeospatialImporter tool.
I am looking for a query that will return the list of countries that are contained in a particular boundingbox. So the boundingbox is the input and the GEOM column will be the output.
I came up with this query that does the job.
Select Name, GEOM from mstr.world where
GEOM.ST_MBR_Xmin() >= Xmin AND
GEOM.ST_MBR_Ymin() >= Ymin AND
GEOM.ST_MBR_Xmax() <= Xmax AND
GEOM.ST_MBR_Ymax() <= Ymax;
where obvioulsly (Xmin,Ymin,Xmax,Ymax) is the boundingbox.
However, this is just a test and in reality we will be querying tables that contain potentially millions or rows. So I guess the question is how can I be sure this is the most efficient query? Is this query using Teradata's spatial index? I have no idea. Is there a similar query that would be much faster?
Also, my technology department tells me that if the output (the GEOM colum in this case) can be in WKB format it would be much faster and better for us. I have tried using the ST_WKBToSQL method but I am not sure that's what I need. I guess what I need is a function that converts the ST_Geometry type to WTB format, so my query would be something like SELECT CONVERT(ST_GEOMETRY_TO_WKB, GEOM) from mstr.world blablabla
Can you give me a hand?
I guess there are two questions in the end, not just one ;)
Thanks!
 

fgrimmer 660 comments Joined 04/09
17 Dec 2014

Raul, I am afraid I am not the right person to answer your question. I know that an EXPLAIN will tell you more information about your query that can help with understanding its effeciency. But I would suggest you post your question on the Database Forum, http://forums.teradata.com/forum/database for more help on this.

raulbenet 3 comments Joined 11/14
19 Dec 2014

Thank you Francine and Merry Christmas!

Fei Ju 1 comment Joined 06/13
20 Dec 2014

I try to user Teradat Studio Express to run sql on aster ( VM machine) . I can edit data in the table, but can not run SQL . The error message is java.lang.nullpointerexception. How can I deal with it ?

fgrimmer 660 comments Joined 04/09
22 Dec 2014

Fei, Are you running Studio Express inside the Aster VM or from outside the VM? What version of Studio Express are you running? In order to diagnose the problem we would need to see the error logs. Please open an incident with Teradata At Your Service.

AlekhyaVilla 2 comments Joined 06/12
19 Mar 2015

Ms Grimmer,
I have downloaded Teradata 15 (Teradata studio Express) for Mac OS X. I have been trying to setup the connection profile to get the databases avaiable.
I find difficulty in knowing the " Database Server name ", " user name", "Password".
Can you please share the details. I tried giving the values as in your article above, it  didnot work.
PLease help.

fgrimmer 660 comments Joined 04/09
20 Mar 2015

@AlekhyaVilla, For the database server value, you would enter the hostname or IP address of your Teradata database server. If you are running a Teradata Express VM, the username and password are dbc/dbc.

AlekhyaVilla 2 comments Joined 06/12
21 Mar 2015

Thank you Ms.fgrimmer

yasmeen_ahmad 2 comments Joined 11/13
20 May 2015

 
I have just downloaded the recent version of TD Studio Express - Teradata Studio Express 15.10.00.01.
I am using this against an Aster Appliance, however I have an issue when I try to execute queries. If I execute the query by command line (Alt+X - execute selected text) then it executes fine. However, if I choose to execute via the GUI buttons (Green Arrow - execute as individual statements) then it does not run ERROR: relation "hist_reduce" does not exist - it seems to be validating the SQL and not recognising the Aster specific commands.
Can you help on how I can resolve this? Is there an option to configure what the GUI buttons are doing?
 
Thanks in advance!

fgrimmer 660 comments Joined 04/09
20 May 2015

Yasmeen, Which version of Aster are you executing your query on?

yasmeen_ahmad 2 comments Joined 11/13
20 May 2015

Hi Francine,
I am connecting to Aster DB 6.00
In TD Studio Express it tells me it is using nCluster 6.0.1.00.
Does this sound okay?

fgrimmer 660 comments Joined 04/09
20 May 2015

Yasmeen, Yes, that version is ok. What SQL are you running?

sparvathaneni 5 comments Joined 02/12
17 Jul 2015

Folks ,
FYI: I am new to teradata
I have installed teradata 15 on windows , installed the ODBC drivers for teradata.
I am trying to login but coudn't . Do we have any defualt credentials ??
Or do i need to install the server for creating new user and password ?? 
 
Any help is greatly apperciated.

fgrimmer 660 comments Joined 04/09
17 Jul 2015

Satish, It sounds like you have install the Teradata Express VM. If you are using Teradata Studio Express to connect, you do not need ODBC. Studio Express is a Java based product and only uses JDBC to connect to the database. Using the Studio Express Connection Wizard as described above, you can try dbc/dbc and the username/password for Teradata Express.

sparvathaneni 5 comments Joined 02/12
17 Jul 2015

Thank you very much will do. Have a great weekend.!!

mojave 2 comments Joined 02/13
31 Jul 2015

No luck with the install.  Repeated errors messages "Unable to create the Teradata Studio Express Desktop shortcut", and the program does not show up in All Programs.  The workaround was to go directly to program files and create a shortcut to the .exe, but I'm surprised at such a basic error.  Opening from the shortcut, I'm getting message "An error has occured", the log file has message "An error occurred while automatically activating bundle org.eclipse.core.resources".  What is eclipse and is there a prerequisite to the install other than Java? 

fgrimmer 660 comments Joined 04/09
04 Aug 2015

Paul, It sounds like you have a permission issue on your desktop preventing it from creating the desktop shortcut and possible run issues. Can you run install "Run as Administrator"? Is there an error log in your /configuration directory of your Studio Express install. When Studio Express is launched, it will try to create a workspace directory in your <USER> directory. If there are problems, like permission issues, you can specify a different location for the workspace directory by launching from the command line and providing the -data option and -configuration option. This is described in the Readme (on the download page). 
Studio Express is based on the Eclipse open source platform. The only prerequisite is to install a supported Java Runtime Environment (versions 1.6, 1.7, or 1.8).

JustMe 10 comments Joined 03/07
25 Nov 2015

Hi,
In the article you stated  that preferences are provided that allow you to choose which objects to load and display in the Data Source Explorer.
 
Can you tell me how to accomplish that or where to find instructions for doing so?
 
Thank you.

fgrimmer 660 comments Joined 04/09
27 Nov 2015

Kimberly, go to Window>Preferences then Teradata Datatools Preferences>Data Source Explorer Load Preferences. On this preference page you can choose which folders to show for Teradata Database objects. You can also choose options for loading databases and users. 

AmruthaAneppil 1 comment Joined 04/16
06 Apr 2016

Hi,
I have recently installed Teradata express 15.10.0.7using vmware and installation went successful. When i access Teradata Studio express inside it, i am not able to run any create table SQL due to permission issue. Its showing user does not have create table access to database dbc. i have logged in as dbc/dbc for username and password. Do i need to do some additonal settings to gain access to create tables? Please advise.

fgrimmer 660 comments Joined 04/09
06 Apr 2016

Amrutha, It sounds like you will need to GRANT create for the user. Please refer to the Teradata documentation regarding security administration. Teradata Studio provides dialogs to help with database privileges. It can be download from Developer Exchange.

kaleempasha 4 comments Joined 02/11
11 Apr 2016

Hi,
I am having issues with Teradata Studio when drilling down to tables/views. The problem persists in spite of  my having deleted and reinstalled the application by cleaning the registry and deleting the directories as well. Following are the error log for this issue.  No other user appears to have this problem. Can we have assistance on this?
Thanks.
Here are the notes from "Details" above
 
 
 
com.teradata.datatools.util.dao.DAOException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.
 
            at com.teradata.datatools.util.dao.JdbcDAO.prepareStatement(JdbcDAO.java:178)
 
            at com.teradata.datatools.util.dao.JdbcDAO.parametizedListMapQuery(JdbcDAO.java:679)
 
            at com.teradata.datatools.util.dao.JdbcDAO.runQuery(JdbcDAO.java:652)
 
            at com.teradata.datatools.dao.TeradataCatalogDAO.loadTables(TeradataCatalogDAO.java:437)
 
            at com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.loadTables(TeradataCatalogSchema.java:1552)
 
            at com.teradata.datatools.dtp.catalog.TeradataCatalogSchema.getTables(TeradataCatalogSchema.java:757)
 
            at org.eclipse.datatools.modelbase.sql.schema.impl.SchemaImpl.eGet(SchemaImpl.java:597)
 
            at org.eclipse.emf.ecore.impl.BasicEObjectImpl.eGet(BasicEObjectImpl.java:1011)
 
            at org.eclipse.emf.ecore.impl.BasicEObjectImpl.eGet(BasicEObjectImpl.java:1003)
 
            at org.eclipse.emf.ecore.impl.BasicEObjectImpl.eGet(BasicEObjectImpl.java:998)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.getSchemaChildren(ServerExplorerVNodeContentProviderNav.java:250)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displayTableNodeChildren(ServerExplorerVNodeContentProviderNav.java:187)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:173)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:243)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.AbstractLayoutProviderNav.getChildren(AbstractLayoutProviderNav.java:85)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.impl.ServerExplorerContentProviderNav.load(ServerExplorerContentProviderNav.java:153)
 
            at org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.loading.LoadingJob.run(LoadingJob.java:43)
 
            at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
 
Caused by: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.
 
            at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)
 
            at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:103)
 
            at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:311)
 
            at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:200)
 
            at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:125)
 
            at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:116)
 
            at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:387)
 
            at com.teradata.jdbc.jdbc_4.TDStatement.prepareRequest(TDStatement.java:574)
 
            at com.teradata.jdbc.jdbc_4.TDPreparedStatement.<init>(TDPreparedStatement.java:129)
 
            at com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement.<init>(JDK6_SQL_PreparedStatement.java:30)
 
            at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.constructPreparedStatement(JDK6_SQL_Connection.java:81)
 
            at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1355)
 
            at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1399)
 
            at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1385)
 
            at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
 
            at org.apache.commons.dbcp.PoolingDriver$PoolGuardConnectionWrapper.prepareStatement(PoolingDriver.java:372)
 
            at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionAdapter.prepareStatement(ConnectionAdapter.java:70)
 
            at com.teradata.datatools.util.db.DBAccess.prepareStatement(DBAccess.java:623)
 
            at com.teradata.datatools.util.dao.JdbcDAO.prepareStatement(JdbcDAO.java:175)
 
 
 

fgrimmer 660 comments Joined 04/09
11 Apr 2016

Syed, Is the preferences for loading lists in the DSE using the V or VX views or custom view?

kaleempasha 4 comments Joined 02/11
12 Apr 2016

Hi,
It's both V and custom views.
 
Syed.

kaleempasha 4 comments Joined 02/11
12 Apr 2016

Also, surprise to see that when the following error message is recieved,  Querylog shows that there is no object referred from DBC (like DBC.Tables). All the error messages from Querylog seems very much like this.
 
Error Message:

Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword or '(' between the 'FROM' keyword and the 'WHERE' keyword.

 

Query from Querylog:

SELECT TableName, TRIM (TableKind) AS TableKind, TRIM (CommentString) AS CommentString FROM  WHERE DatabaseName= ? AND (TableKind IN ('T', 'O', 'V') ) ORDER BY TableName

 

Syed.
 

kaleempasha 4 comments Joined 02/11
12 Apr 2016

Hi,
I have rechecked the prefrences. I have done the changes and the issue is now resolved. Thanks for the hint.
Really appreciated.
 
Thanks,
Syed.

 

fgrimmer 660 comments Joined 04/09
12 Apr 2016

Syed, We are using parameterized query so the FROM table/view is replaced at runtime, based on your preference setting. Is there another query in the querylog that shows the replacement? What was the preference set to, just curious. If you chose Custom, then it must be a table or view that matches the definition as, for example, TablesV or DatabasesV.  The custom option is for possible staging table/view.

Madhum 3 comments Joined 08/13
05 Jul 2016

Hi,
 
I have installed this teradata studio in my office machine for project work. My colleague is having BTEQ,Fastexport utilities in his studio but I am unable to find them in my machine. Kindly help.Version is 14.10 both have same versions but I am unable to see them.
 
Thanks
Madhu

Regards,
Madhu

fgrimmer 660 comments Joined 04/09
05 Jul 2016

Madhu, Studio does not include BTEQ. It does use JDBC FastExport for data transfer. It may be that you are looking for Teradata TTU Client tools to be installed? You can access these from your Teradata install media or download from the Teradata TSS Patch Server.

fgrimmer 660 comments Joined 04/09
11 Jul 2016

Madhu, For Teradata tables that are over 100,000 rows, Studio and Studio Express will use the JDBC Fast Export option, otherwise, JDBC Batch will be used when the Export Data option is selected. From the Data Source Explorer, navigate to a table in either Aster or Teradata, right click and choose Data>Export Data... option. Do you see this option?
BTW, the screen shot was not attached.

Madhum 3 comments Joined 08/13
18 Jul 2016

thanks for the info Fgrimmer....

Regards,
Madhu

You must sign in to leave a comment.