Teradata provides three Eclipse-based client tools, Teradata Studio, Teradata Studio Express, and Teradata Plug-in for Eclipse. All three products are built from the same code base and provide connectivity to your Teradata Database, but each has a different end user focus.

Teradata Studio Express is the base level product. It is an information discovery tool for retrieving and displaying data from your Teradata Database systems. Its main use is for running SQL statements, displaying result set data, and storing SQL execution history.

Teradata Studio, in addition to the features provided in Teradata Studio Express, includes administration dialogs and wizards. It's main use is for administrators to create and administer database objects. Teradata Studio is a tool for DBAs, Data Scientists, and Power Users.

Teradata Plug-in for Eclipse, in addition to the features provided in Teradata Studio, plugs into your existing Eclipse IDE and provides wizards to help users create Java database objects such as Java Stored Procedures and Java User Defined Functions. Teradata Plug-in for Eclipse is a tool for developers creating Java applications and database objects.

Feature Comparison Chart

Below is a feature comparison chart showing the three Teradata client tools and the list of features:

 

Features

Studio Express

Studio

Plug-in for Eclipse

  Connection Management

  Support for Aster Database

  Embedded JDBC Drivers

  SQL Execution

  SQL Templates

  SQL History

     (Import from SQL Assistant)

  Result Set Viewer   

     (Export to Excel, Text, XML, HTML)

  Visual SQL Builder

   Table Data Load and Extract

  Teradata View

     (Detailed object information)

   Data Labs
     (Copy Objects, Smart Load)

   Smart Load (Teradata)

  Multi-Platform Support

     (Windows, Mac, Linux)

 

  Administrative Dialogs

 

  Create and Drop Dialogs

 

  Copy and Compare Objects

 

  Hadoop Data Transfer

       (Smart Loader for Hadoop)

 

  Plug into existing Eclipse installation

   

  Java Development (Teradata Project)

 

 

  Java Stored Procedures Wizard

 

 

  Java User Defined Types Wizard

 

 

  Ant Build Files

 

 

  Create/Read/Update/Delete (CRUD) Table Wizard

 

 

  Web Service Wizard

     

 

Download Products

All three products are available on the Developer Exchange Download page. For more information on these products, refer to the articles: Teradata Studio Express, Teradata Studio, and Getting Started with Teradata Plug-in for Eclipse.

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

 

 

Discussion
rslosey 1 comment Joined 07/09
20 Feb 2013

Can some one help please, I installed the teradata studio. I am able to connect the teradata dbms but I can't seem to find the hadoop import export connection options. Do I need to install something else to see these

fgrimmer 470 comments Joined 04/09
21 Feb 2013

@rslosey, Please refer to the Help page. Go to the top level Help menu and choose Help Contents. Open the Teradata Studio book and refer to the Hadoop Transfer Perspective.

LUCAS 9 comments Joined 06/09
27 Mar 2013

Hi !
i can't download Teradata Studio on my PC, due to site control policy ...
therefore i could download TTU from TAYS some weeks ago.
Why Teradata Studio should not be avalaible on TAYS ?
 
Thanks for help,
Pierre
 

fgrimmer 470 comments Joined 04/09
27 Mar 2013

Pierre,
We are looking into providing Teradata Studio as part of the TTU install.

naveen.kalia 3 comments Joined 04/08
04 Apr 2013

Does Teradata Studio support SSO conectivity

fgrimmer 470 comments Joined 04/09
04 Apr 2013

Yes, It allows for no username or password to be specified when using LDAP and Kerberos authentication mechanisms.

naveen.kalia 3 comments Joined 04/08
04 Apr 2013

When I choose KRB5 as connection mechanism, I still have to specify a password, how do I get around that. If I specify dummy password I get the error the ping failed.
For my ODBC configuration set up I can either check Use Integrated Security or Select KRB5 and don't specify login and password and can connect using SQL Assistant or TD Admininstrator.
 
Any Suggestions?
 

fgrimmer 470 comments Joined 04/09
04 Apr 2013

You should not have to enter a password when selection KRB5. Enter the database server name, (username and password are optional), and select KRB5. The Finish button will be enabled.

padhia 11 comments Joined 06/10
23 Apr 2013

Thanks for this article. It's much easier to compare the functionality available in these products. Just curious, is there a reason why Plug-in is not cross platform? Does it not come with the embedded jdbc driver?

fgrimmer 470 comments Joined 04/09
23 Apr 2013

@padhia, We are working on adding additional platform support for Teradata Plugin. Yes, all three products come with embedded Teradata and Aster JDBC drivers.

mzs 11 comments Joined 09/10
15 May 2013

Yesterday I started testing TDS to eventually migrate from SQL Assistant / Teradata Administrator, and found couple of pretty convenient things missing -
1. It seems I can't execute only highlighted SQL, I can't even have something like that in SQL window:
DATABASE my_target;
SELECT * FROM CTL_DETAIL;
I am getting an error "Only a COMMIT STATEMENT or null statement is legal after a DDL Sattement." no matter what option I use to execute it.
2. Explain can still be invoked with F6 as a "hot key", but Execute lost F5 "hot key", and now has some ugly combination of "Ctrl-Alt-I"
3. Where are the line numbers in SQL Editor?
Please let me know if I just didn't read Help File carefully enough.
Most likely, I will have more feedback as I keep learning the tool, but I am pretty upset with initial impressions.
Thank you,
  
 
 
 
  
 

fgrimmer 470 comments Joined 04/09
15 May 2013

@mzs, 1. Because you have a DDL statement, you will want to choose the option 'Execute as Individual Statements'.
2. We are looking to allow the F5 for executing SQL in our next release.
3. Right click in the left margin of the SQL Editor and the drop down menu has the 'Show Line Numbers' option. You can also set the option in the Preferences. In the top most toolbar, click on Window>Preferences. In the Preferences dialog, enter the word 'line' in the 'type filter text' window to filter the preference pages. Choose the Text Editors page under the General heading. There is an option 'Show line numbers'. Check the box and click Apply.
 

fgrimmer 470 comments Joined 04/09
15 May 2013

@mzs, Regards to #2, as a workaround,  there is also a way to add a key binding for execute SQL command: Bring up the Preferences dialog and enter 'binding' in the filter text. In the Keys preference page you can add or change key bindings. Scroll down and select  Execute Individual SQL in the Command list. You can change the key binding from Ctrl+Alt+I to F5 or click the Copy Command to create a new key binding for Execute Individual SQL. Click Apply. I hope that helps.

mzs 11 comments Joined 09/10
20 May 2013

Thank you very much for your answer.  I have another issue I can't solve - when I drag the database as an object from Data Source Explorer into Compare Objects, I get both options - "Copy Object" and "Compare Object Definitions".  However, when I drag just one table, or stored procedure, I only get an option to "Copy Object", "Compare..." button is disabled.  Please help. 
Mike
 
 

fgrimmer 470 comments Joined 04/09
20 May 2013

@mzs, Copy and Compare allows you to drag a source object and drop it on the destination parent object or a comparative object.
Because a schema (database) can be compared with another schema (database) and have another schema as a parent schema, both the copy and compare options are given. If you want to compare two tables or stored procedures, you would drag and drop the source table or procedure on another table or procedure. If you want to copy the table or procedure, you would drop it on the destination parent schema (database).

mzs 11 comments Joined 09/10
20 May 2013

Great thank you.  Can this be added to the Help file.
Mike
 

fgrimmer 470 comments Joined 04/09
20 May 2013

@mzs, Yes, I will review the help for clarity on this.

mzs 11 comments Joined 09/10
21 May 2013

Hello Francine,
I have one more question - at some point we discovered that SQL Assistant is not able to execute a script of more than about 400 lines, sort of.  It would run, and then "Completed successfully" without indicating an error, i.e. a script that should of create 15 stored procedures, would create 10, and then report success, or if a single procedure script would be more than about 400 lines, and there is a syntax error, it would not get reported, so we had to run long scripts in parts, and just do a heavy duty testing on some known long code procedures to flash out possible syntax issues.  I tried running a long script in TD Studio, and got an error: "Parse Error splitting statement".  The good thing - it did report an error.  The question is - what is the limit on the number of lines in a single procedure definition, or a script containing multiple DDL statements, that is executed as individual statements?
Also, in SQL Assistant, a right-click brings up "Find/Replace" menu, plus couple other options.  Is there a plan to get them back (at least "Find/Replace") on a right-click menu?
Thank you

mzs 11 comments Joined 09/10
21 May 2013

almost forgot - Help File window is done as a modal form, i.e. it prevents changing focus from itself to other windows.  Extremely inconvenient. 

fgrimmer 470 comments Joined 04/09
21 May 2013

@mzs, There is not a limit that we are aware of for SQL statements. Also, there is no plan to add Find/Replace to the right click menu. We can consider this for future enhancements.
The Help Contents is not a modal window. You can bring up Help (Help>Help Contents), which opens in a separate window, and return focus to your Studio or Studio Express window. How did you invoke the Help?

mzs 11 comments Joined 09/10
22 May 2013

I invoked Help from New Driver Definition bottom left corner "?". Actually, the entire form is modal, but most likely it is intentional.  I tried to create connection to MS SQL Server, so I opened "New Connection Profile --> New Driver Definition", so I opened Help, and tried to follow the steps described, so I tried to go to "Window --> Preferences", and found I have to close "New Driver Definition" form first. 
What would be the cause of "Parse Error splitting statement" if there are no limitations on the length of the script?  I was trying to execute our production script which has around 10000 lines and would create 85 stored procedures. 

fgrimmer 470 comments Joined 04/09
22 May 2013

The Connection profile dialog is modal. You can bring up a separate Help window from the top Help>Help Content. It contains all of the help files. You can enter a search string for find what you need help with.
Because you are executing DDL as individual statements, it will try to split the SQL into its individual SQL statements. The "Parse Error splitting statement" means that there is an error in the SQL when it tries to split. Are you seeing a red 'X' or hash mark in the right hand margin?
 

mzs 11 comments Joined 09/10
22 May 2013

There were no red 'X' or other marks, but it was my fault - there was an obsolete object in a script.
I tried to create just one procedure - and the only way I was able to do that is to highlight the text of entire procedure and then right-click and select "Execute Selected Text".  If I did not highlight the entire script (which is the only thing in SQL window) , I would get an error, because there is only one option enabled - "Execute Current Text".  Unless I am not doing something right, I see combination of two separate tools, SQL Assistant and TD Adminstrator, as a much better alternative for now. The only option in TD Studio absent in the former - is "Compare Objects". 

mcetraro 2 comments Joined 04/13
23 May 2013

Does Teradata Studio Express include Fastload?

Marco

fgrimmer 470 comments Joined 04/09
24 May 2013

@mcetraro,it uses JDBC Fastload when loading large amounts of data for table loads. 

29 May 2013

Is there a link to the license of Teradata Studio?

fgrimmer 470 comments Joined 04/09
30 May 2013

The license is available on the download page.

tb185024 1 comment Joined 12/11
31 May 2013

Is Teradata Studios able to use an ODBC connection?  Everything that I've read only point to JDBC connections.  I'm looking for a tool that I can connect to a TD14 ODBC 64bit.  If not, do you know if a tool that can be used with ODBC 64 bit?

fgrimmer 470 comments Joined 04/09
31 May 2013

No, Teradata Studio just supports JDBC. I am not aware of any.

mzs 11 comments Joined 09/10
05 Jun 2013

It appears that when connecting to Teradata, JDBC configuration requires physical host name.  Also, when we tried to connect to MS SQL Server, using sql jdbc driver, we needed port number for the MS SQL instance.  In many companies both pieces of information are closely guarded.  This is, of course, not tool-specific, it is JDBC issue.  Is there a plan to allow use of ODBC connections (which, by the way, can be distributed by desktop support, so developers would not need neither admin rights nor specific knowledge to configure connections)?

fgrimmer 470 comments Joined 04/09
05 Jun 2013

At this time, there are no plans to support ODBC.

lynxstormcat 3 comments Joined 01/11
13 Jun 2013

I want to do some SQL script automation using Teradata Studio. Is there a way to execute SQL files under a project by calling teradata studio via command line?
What are the other command line options does Teradata Studio support?
 

fgrimmer 470 comments Joined 04/09
13 Jun 2013

@lynxstormcat, Studio does not have any command line execution of SQL at this time. You can execute one or more SQL files inside of Studio, from the Project Explorer.

20 Jun 2013

We've run into some issues using Studio as our GUI tool to access our Teradata Aster database. At this time the biggest problem is exporting to a CSV. The output file is just a line of text with no delimiters and while you can import it into Excel you can't do any calculations on the numeric data since Excel views it as text. In addition large result sets fail to export due to a Java heap error.
We're using 14.02.
 
I have other items and additional documentation if you would like to see it.
 
Thank you.

fgrimmer 470 comments Joined 04/09
20 Jun 2013

@assolij, I am not able to recreate your issue. I was able to Extract the data from my Aster table as CSV. It opened in Excel and I was able to SUM my integer column. Am I missing something that you did? There is an issue with Excel '97 (.xls) as to row limitation. You can increate the Java heap in Studio or Studio Express by increasing the memory sizes in your TeradataStudio.ini or TeradataStudioExpress.ini file and restarting Studio or Studio Express. Current values are:
-Xms256m
-Xmx256m
-XX:MaxPermSize=256m
You can increase, for example:
-Xms512m
-Xmx512m
-XX:MaxPermSize=512m
Your ini file is located in the install directory. For example, for Teradata Studio:
C:\Program Files (x86)\Teradata\Client\14.00\Teradata Studio
Another option is to export the value from the Result Set Viewer. It provides an option to directly create an Excel file (.xls and .xlsx). You would also have to increas your Java memory values if your result set if very large.

20 Jun 2013

 
That's 2 z's. Don't feel bad, you're not the first and won't be the last.
 
I'll pass on the information about the .INI file to the user. The user is using Excel 2010 so hopefully the Excel 97 issue has been resolved.
The testing is being done by doing something he does often with SQL Assistant against our Teradata environment with Studio. Here are his comments about the export functionality:

  1. Unable to use CAST in Sales by Hour query. (Other cast commands do work). CAST(Transaction_End_Tm AS CHAR (2)) SalesHour. Need to extract the hour portion of a timestamp for grouping. Error is “Right truncation of string data”. Note: Truncation is the desired result. This is a major issue, SBH queries are used for many projects, analysis of merchandise tests and seasonal sales.
  2. There is no option to export results directly to a file or database.  Exporting the result window is limited to a few data types, no MBD or ACC available.
    1. CSV is not working (see result.csv attached).  The output is not comma delimited, just a single line of text for each row.
    2. XLSX and XLS creates all decimal fields as text (see result.xlsx attached), useless for our purposes. Cause appears to be left justification of decimal columns in the Studio result window. 
    3. Large result sets fail “An internal error occurred during: "Handle Result Sets Java heap space”
    4. Unable to copy the entire result window, only the portion visible on screen.  However that copy is formatted as CSV.
  3. Parameter syntax is changed (from ?name to ? and a value must be entered for each occurrence of the parameter.  Minor issue but time consuming and clunky. 

 
 
 

fgrimmer 470 comments Joined 04/09
20 Jun 2013

@azzolij, Sorry about the mistype on your name. :-(. Let me address your issues:
1. One difference is that the Studio connection JDBC property TMODE is set to ANSI, where SQLA is TERA mode, which does not allow for truncation issues causing the "Right truncation of string data" error to be returned. You can change your connection's JDBC TMODE property to TERA and see if that helps.
2. We are working on an 'Export Mode' feature and hope to have it in a future release. For Teradata, we have a Teradata Export option that has more features than the Extract option (from Eclipse). For Aster Database, only the Extract option is available but that is also something we are working on for future release.
3. You can name your parameters with ?\name syntax. SQLA treats paramters as text substitutions where with Studio they are parameterized statements that get passed to the JDBC driver/database. I am not sure what it would take to allow multiple occurrences of the same named parameter. But something to look into.

21 Jun 2013

Is there a target date for the future release? We have an Aster project going live in about 3 weeks and we were hoping to have a single GUI product to give our users. Your release date isn't likely that soon, but at least it would help the people making the decision.
 

fgrimmer 470 comments Joined 04/09
21 Jun 2013

@azzolij, Our next release for Studio products is 14.10, scheduled for Q3 of this year.

joe.ruvolo 2 comments Joined 11/11
11 Jul 2013

Francine
I'm trying to determine what TTU products the studios replace as we plan our v14.10 upgrade. 
Seems like what was called the TTU Utility pack (ODBC/JDBC drivers, SQL Assistant, TD Administrator, GSS, ICU, etc) is all included or replace by Studio... everything but BTEQ, correct?
In a previous note, you indicated that JDBC Fastload is used.  Is that a 1-for-1 replacement for the PC-based Teradata Fastload in TTU?  Same question for FastExport... is it a replacement for Teradata FastExport? 
From the DBA perspective, many of these products are not in the Studio (yet).  I'm referring to Visual Explain, SET, Index and Stat Wizards, Query Scheduler and Workload Analyzer.  Can you comment on which, if any, of these will be in the 3Q13 v14.10 release? 
Appreciate any and all feedback, or insights on where to get this info...
Thx!
Joe

Thx!
Joe

fgrimmer 470 comments Joined 04/09
11 Jul 2013

@guitarjoe, Teradata Studio is intended as an alternative to Teradata Administrator and SQL Assistant. I have not seen plans for incorporating GSS and ICU functionality. There are plans to include Visual Explain and Teradata Analyst Pack (Index Wizard and SET) in future revisions. As well as a Studio Platinum that would include Teradata Workload Analyzer. The future items are still in the planning phase and not part of the upcoming 14.10 release.
Teradata Studio does not replace Teradata FastLoad or Teradata FastExport but mentions the JDBC FastLoad/FastExport options that are used under the covers when loading or exporting large amounts of data. The stand alone Teradata FastLoad and FastExport tools allows you to control and customize your FastLoad/FastExport scripts.

davevernon99 1 comment Joined 07/13
17 Jul 2013

Hi,
 
Where can I install Teradata GSS Client 14.10 from please?
 
Dave
 

fgrimmer 470 comments Joined 04/09
17 Jul 2013

TTU 14.10 software is available on the install CDs that customers can get from their Teradata account team.

mlueck 2 comments Joined 07/13
22 Jul 2013

When I open up Teradata Studio Express 14.00, I get the message:
The application can not be started because its workspace is in use.
Only one application can us a workspace at a time
I have removed and reinstalled the software, and still get this message on the initial startup.
I do have a workspace folder in my directory.
Any suggestions?

fgrimmer 470 comments Joined 04/09
22 Jul 2013

Are you running Eclipse separately? Studio Express uses a workspace directory called "workspace", as well does Eclipse. You can change the name of your workspace directory when you launch Studio Express by including the -data option on the command line. Refer to the Release Definition, located in your /doc directory of the install, for specifics on Changing your Workspace.

mlueck 2 comments Joined 07/13
22 Jul 2013

I noticed that the options show building the Workspace on open.  I deleted the existing folder, and re-opened Studio Express.  It rebuilt the folder, and now works correctly.

gandham 2 comments Joined 05/12
01 Aug 2013

In Tereadata Studio Express Query window, Select the query and press F6 for Explain. 
Select multiple queries and press F6; First query explain results set in results set viewer and the other queries(other than the first query) are getting executed and results are produced. 
 

gandham 2 comments Joined 05/12
01 Aug 2013

In TSE, Is there a way to redirect the multiple queries output result sets to file like export in SQA Assist.  Thanks. 

fgrimmer 470 comments Joined 04/09
01 Aug 2013

@gandham, we'll look into explain for multiple statements. As well, the ability to redirect output to a file, 'export mode', is on the list for our next release.

fgrimmer 470 comments Joined 04/09
16 Aug 2013

@azzolij, Teradata Studio 14.10 is available for download on the DevX Download link.

pauldancer 4 comments Joined 05/09
11 Sep 2013

I am taking advantage of the new hierarchical view of the Data Source Explorer in Studio 14.10 (option "Show Databases and User in Hierarchical Display" is checked).
If I then use the SQL Query Builder and try to Add Table, it only lists the databases/users in the top level of my hierarchy.
Is this a bug or do I need to set another option to get the hierarchy to work there as well?
thanks and regards,
Paul

fgrimmer 470 comments Joined 04/09
11 Sep 2013

@DFJoe, This looks like a bug. Can you open an incident on this and we will get a fix for it. In the meantime, you should uncheck the Show as hierarchy option to see the full list. Sorry for the inconvenience.

cburk001c 2 comments Joined 10/13
09 Oct 2013

I am getting the following error trying to execute a sql statement in Studio Express:
Failed [3996 : HY000] Right truncation of string data.
I can run the statement in SQL Assistant with no problems but we are in the process of switching to Studio Express.  Is there some parameter I need to set for larger queries?
Thank you for your help

sri.aue 1 comment Joined 10/13
09 Oct 2013

Do we have any client tool for teradata which is like SQL server management studio for SQLServer, SQL Navigator for Oracle, where table and column names will be prompted immediately after using table alias in select or where clause in select queries.
i.e. select * from table t where t.<<prompts all columns for the table>>
I tried to use studio express & Teradata SQL Assitant and I am not able to find the option to do this. Everytime I need to navigate the tables and columns in database.
Please need your help.
THanks!!

Thanks
Sridhar T S

fgrimmer 470 comments Joined 04/09
10 Oct 2013

@cburk001c, The issues is likely the TMODE setting. In SQLA, the default TMODE is set to TERA and with Studio Express it is set to the recommended default of ANSI. With ANSI mode, the sting is not truncated and the error is returned. You can change the SQL by using the SUBSTRING function to prevent such errors or you can change your TMODE setting for your connection profile to TERA so it will truncate the values. The change the connection profile, right click on the connection profile in the Data Source Explorer, choose the Properties menu option, then Teradata JDBC Connection Properties. Then click the Add.. button and add the TMODE=TERA to replace the TMODE-ANSI property.

fgrimmer 470 comments Joined 04/09
10 Oct 2013

I can't answer for SQL Assistant but Studio parser does not recognize aliases for content assist.

cburk001c 2 comments Joined 10/13
11 Oct 2013

Thank you - changing the TMODE worked.

WillowCat 1 comment Joined 10/13
29 Oct 2013

Hi there. I have installed Studio Express 14.2 but I dont have the Smart Load wizard, how do I get this installed ?

fgrimmer 470 comments Joined 04/09
29 Oct 2013

In our 14.02, the Smart Load Wizard is only available for Data Lab. Download our 14.10 release of Studio where it is available for all Teradata Databases.

rkgudde 7 comments Joined 08/07
29 Oct 2013

i am using teradata studio to execute a stored procedure, which for right now, generates some create user statements.  when i execute the SP in studio, nothing shows up in the result set viewer.   i am populating the output into an OUT variable within the SP
in the hiostory window i get in the result column: "Executed as Single statement.  Elapsed time = 00:00:00.040 STATEMENT 1: CALL  completed."
I am very new to studio and have no idea where to go from here.  below is the answer set i get when using SQLA.
any help or direction would be greatly appreciated.  thanks so much
output in SQLA:
Creating userid using:
CREATE USER "REGUSER_ID" from "TDUSERS"
as perm = 0
password = "PASSWORD"
spool = 0
temporary = 0
account = ('$L$_NO_PROFILE_&S&D&H')
STARTUP = ''
DEFAULT DATABASE = "REGUSER_ID"
NO FALLBACK
NO BEFORE JOURNAL
NO AFTER JOURNAL
COLLATION = HOST
DEFAULT CHARACTER SET LATIN
DATEFORM=INTEGERDATE
TIME ZONE=NULL
profile="p_tq_td_infra"
default role ="R_SYSTEM_ADMIN"
;
Updating Comment:
comment on user "REGUSER_ID" as "COMMENT - USER NAME - JOB TITLE - DEPARTMENT";
Setting adoc PW to null:
GRANT LOGON ON ALL TO "REGUSER_ID" WITH NULL PASSWORD;
 
 

tjfoley 1 comment Joined 10/11
30 Oct 2013

I've encountered a couple of issues that are making it difficult to transition to Teradata Studio from SQL Assistant; would appreciate any clarification from Teradata personnel.

  1. I’d recently started using the .IF construct from BTEQ in my promotion scripts as a work-around for Teradata’s lack of the “IF EXISTS” capability, for example when a table must be replaced but it doesn’t exist in all the applicable promotion environments, for instance:

 
/* DROP stage table view in Interim environment if it exists */
 
SELECT 1 FROM DBC.TABLES WHERE DATABASENAME = 'DEV_STAGE_Interim_V' AND TABLENAME = 'VIEW_NAME_V' ;
.IF ACTIVITYCOUNT = 0 THEN GOTO OK1
DROP VIEW  DEV_STAGE_Interim_V.VIEW_NAME_V;
.LABEL OK1
 
This works well in SQL Assistant starting with the 14 versions, but is flagged as a syntax error in Teradata Studio, and I’ve been told by local support personnel that they’re not aware of any plans to support it in Teradata Studio.
 

  1.  With respect to parameterized queries – it appears they’ve been made so cumbersome as to be essentially unusable.  Here’s my use case:

 
This query works well in SQL Assistant (prompts a single time for each parameter, then applies it in multiple places as intended):
 
sel 'DEV ?Parm1 not DEVNEXT   ' (title 'Discrepancy'), tablename,' '  (title 'GT') from DBC.TABLES
where databasename = 'BUILD_DEV_?Parm1'||'_T'  and tablename like '?Parm2\_%' ESCAPE '\'
and tablename in (sel table_name from BUILD_METADATA_T.TABLE_SOURCE where source_system_name = '?Parm3')
and tablekind  = 'T'
minus
sel 'DEV ?Parm1 not DEVNEXT   ', tablename, ' '  from DBC.TABLES
where databasename = 'BUILD_METADATA_?Parm1'||'_T' and tablename like '?Parm2\_%' ESCAPE '\'
and tablekind = 'T'
UNION ALL
sel 'DEVNEXT ?Parm1 not DEV   ', tablename, ' '  from DBC.TABLES
where databasename = 'BUILD_METADATA_?Parm1'||'_T' and tablename like '?Parm2\_%' ESCAPE '\'
and tablekind = 'T'
minus
sel 'DEVNEXT ?Parm1 not DEV   ', tablename, ' '  from DBC.TABLES
where databasename = 'BUILD_DEV_?Parm1'||'_T' and tablename like '?Parm2\_%' ESCAPE '\'
and tablename in (sel table_name from BUILD_METADATA_T.TABLE_SOURCE where source_system_name = '?Parm3')
and tablekind = 'T'
UNION ALL
sel 'GLOBAL TEMP inconsistent', tablename, CommitOpt from DBC.TABLES
where databasename = 'BUILD_METADATA_?Parm1'||'_T' and trim(tablename) like '?Parm2\_%\_GT' ESCAPE '\'
and tablekind = 'T'
minus
sel 'GLOBAL TEMP inconsistent', tablename, CommitOpt from DBC.TABLES
where databasename = 'BUILD_DEV_?Parm1'||'_T' and trim(tablename) like '?Parm2\_%\_GT' ESCAPE '\'
and tablename in (sel table_name from BUILD_METADATA_T.TABLE_SOURCE where source_system_name = '?Parm3')
and tablekind = 'T'
UNION ALL
sel 'DEVNEXT not MULTISET', tablename, ' '  from DBC.TABLES
where databasename = 'BUILD_METADATA_?Parm1'||'_T' and tablename like '?Parm2\_%' ESCAPE '\'
and tablename in (sel table_name from BUILD_METADATA_T.TABLE_SOURCE where source_system_name = '?Parm3')
and tablekind = 'T'
and ( (version = 1 and index (RequestText, 'CREATE MULTISET' ) = 0) or (version > 1 and checkopt = 'N') )
order by 2,1;
 
The problems with this in Teradata Studio are multiple.  One is that the entire query has to be rewritten, since apparently a parameter is not recognized inside a quoted string.  So the first line of the select above must be re-coded for concatenation as:
 
sel 'DEV ' || ?\Parm1 ||' not DEVNEXT   ' (title 'Discrepancy'), tablename,' '  (title 'GT') from DBC.TABLES
 
This in itself would not be an unworkable solution (the recoding would only need to be done once.)  The problem is with the execution.  We are prompted separately for every instance of the parameter, such that before the query is executed, one must manually type in the values for 11 instances of the ?Parm1 parameter, 4 instances of the ?Parm3 parameter, and 7 instances of the ?Parm2 parameter.
 
This almost completely destroys the value of the parameterized query for us.  The intent is that the user grab the stored query, enter 3 parameters to customize for the intended environment comparisons, and run.
Are any near-term resolutions in sight?

fgrimmer 470 comments Joined 04/09
30 Oct 2013

@rkgudde, We are not parsing the SQL Editor for Call statements. Try running the stored procedure from the Data Source Explorer by right clicking on the stored procedure and click the Run... menu option. It then knows that it is a stored procedure and may have OUT values and will display them in the Result set viewer.

fgrimmer 470 comments Joined 04/09
30 Oct 2013

@tjfoley, 1. There are features of the ODBC driver that are not implemented by the JDBC driver. This sounds like one of them.
2. We will look into this issue. The quoted string issue may be hard to resolve since the parser treats them as identifiers. But the repeated parameter names should be something we can fix.

rkgudde 7 comments Joined 08/07
30 Oct 2013

Thanks for getting back with me.  I drilled down to where my stored proc is.  left clicked on it and hit the run.  but now i following error:
"Executed as Single statement.  Failed [5531 : HY000] Named-list is not supported for arguments of a procedure.
Elapsed time = 00:00:00.000
 
STATEMENT 1: Unknown failed."
and the contents of the SQl statement field is "call rgudde.createUserId".  i have several input parms that need to be passed.  the entire call statement is:
CALL rgudde.createUserId ('REGUSER_ID','U','USERNAME','JOBTITLE','DEPARTMENT','COMMENT','PASSWORD','p_tq_td_infra','R_SYSTEM_ADMIN',a,a);
when I right click and hit run, how do i get the input parms passed.
thanks so much

fgrimmer 470 comments Joined 04/09
30 Oct 2013

@rkgkudde, If you are running from the Data Source Explorer than it will know that you have IN parameters and prompt you for them. You do not need to execute the CALL statement. It will create a JDBC Callable Statement and execute the stored procedure.
Open  the Teradata View (or if already opened then bring in focus) and then select your stored procedure in the DSE. What does the Parameters tab show? It should list all of the IN and OUT parameters. Is your stored procedure a SQL Stored Procedure or external Stored Procedure (C++ or Java)?

rkgudde 7 comments Joined 08/07
30 Oct 2013

i didnt run a call statement.  i just hit the run when i right clicked.  the call without parms showed up in the history.  when i click on the parm tab it shows my parm definitions (position, name, parm type, mode, comments).  i dont see any place to enter values in need passed in.  it is an SQL SP.  nothing fancy.  Im sorry about this i know its probably a RTFM fix.

 

rkgudde 7 comments Joined 08/07
30 Oct 2013

does the SP need to be created in Studio? 

fgrimmer 470 comments Joined 04/09
30 Oct 2013

@rkgudde, In the Teradata View, what does it show in the Mode column for each of the parameters. For example, I have a stored procedure that takes in a parameter called region and returns the parameter as output (thus INOUT).
Position   Name   Parameter Type    Mode   Comments
1              region  VARCHAR(64)        INOUT

fgrimmer 470 comments Joined 04/09
30 Oct 2013

@rkgudde, No, it does not.

rkgudde 7 comments Joined 08/07
31 Oct 2013

9 columns are "IN" and 2 columns are "OUT"

 

fgrimmer 470 comments Joined 04/09
07 Nov 2013

@SF186017, It sounds like it is having trouble collect the metadata from the Teradata VM data dictionary. Can you disconnect and reconnect the connection profile and see if that helps?

fgrimmer 470 comments Joined 04/09
07 Nov 2013

@tjfoley, The issue with the parameters inside strings is treated differently with Studio than SQLA.
In SQLA, parameters are simply text substitution markers. They aren't SQL parameters. So, question marks inside strings are simply question marks inside strings. If you want to have parameterized strings they might try using string concatenation, as you mentioned above, to create the parameterized string:
'First part of string ' || ? || ' rest of string'
Parameter placeholders in SQL represent constants so they have to appear where a constant can (which is not inside a quoted string).
As for repeated parameters within the SQL, we will add that improvement to the list of items for future release.

Mahesh_4_Data 2 comments Joined 11/13
18 Nov 2013

Hi All,

I am unable to connect ther server :

it is giving the below error :
 

Could not connect to SAIRAM.

Error creating SQL Model Connection connection to SAIRAM. (Error: [Teradata JDBC Driver] [TeraJDBC 14.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Connection to SAIRAM Mon Nov 18 13:42:20 IST 2013 socket orig=SAIRAM cid=78f32600 sess=0 java.net.UnknownHostException: SAIRAM   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(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.<init>(TDNetworkIOIF.java:185)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:284)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:133)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:119)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:586)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:217)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)   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:359)   at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)   at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690)   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.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Connection to SAIRAM Mon Nov 18 13:42:20 IST 2013 socket orig=SAIRAM cid=78f32600 sess=0 java.net.UnknownHostException: SAIRAM   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)   at java.net.InetAddress.getAddressesFromNameService(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.<init>(TDNetworkIOIF.java:185)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:284)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:133)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:119)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:586)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:217)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)   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:359)   at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:705)   at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:690)   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 SAIRAM. (Error: [Teradata JDBC Driver] [TeraJDBC 14.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Connection to SAIRAM Mon Nov 18 13:42:20 IST 2013 socket orig=SAIRAM cid=421372ab sess=0 java.net.UnknownHostException: SAIRAM   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.<init>(TDNetworkIOIF.java:185)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:284)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:133)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:119)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:586)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:217)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)   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:359)   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.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Connection to SAIRAM Mon Nov 18 13:42:20 IST 2013 socket orig=SAIRAM cid=421372ab sess=0 java.net.UnknownHostException: SAIRAM   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.<init>(TDNetworkIOIF.java:185)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:284)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:133)   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.<init>(TDNetworkIOIF.java:119)   at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:586)   at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:98)   at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:217)   at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)   at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)   at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)   at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)   at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)   at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:293)   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:359)   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)  

Please let me know , need any thing from my end.

waitning for your reesponse..!!

Thanks,
Mahesh Alam
Teradata aspirant

Mahesh Alam

fgrimmer 470 comments Joined 04/09
18 Nov 2013

Mahesh, the stack trace shows a JDBC error UnknownHostException error. This means that the hostname SAIRAM is not known. Try the IP address or update your hosts file to include the hostname SAIRAM.

Mahesh_4_Data 2 comments Joined 11/13
18 Nov 2013

Hi Fgrimmer,

Thanks for your response.

i have tried like this .

opened the drivers file  -- > ETC -- > Hosts File --> Copied the IP Address of the local host 
and pasted in the database server name and followed remaining.

Still ,  I am unable to connect ..

Please suggest , if above is wrong.

Any step - by step guide is more help full.

Thanks,
Mahesh Alam
Teradata aspirant

Mahesh Alam

fgrimmer 470 comments Joined 04/09
18 Nov 2013

Mahesh, What happens when you enter the IP address into Studio connection profile dialog for the database server name?

anhngo56 3 comments Joined 11/13
04 Dec 2013

I'm using Teradata Studio 14.10 (connecting to Aster) and trying to look for the position of the '?' character within a string.  The following query wont work in Teradata Studio however, it's working just find when I use Aster act tool.
SELECT position('?' IN 'hello?') FROM sometable;
Any suggestion?
Thanks
 

fgrimmer 470 comments Joined 04/09
04 Dec 2013

Please upgrade to our 14.10.01 release as I believe this issue was resolved.

anhngo56 3 comments Joined 11/13
04 Dec 2013

Thanks fgrimmer for the quick respond.  I'm using 14.10.01.  Do you know if there's any workaround?

fgrimmer 470 comments Joined 04/09
04 Dec 2013

@anhngo56, What is the error you are getting when running the query?

anhngo56 3 comments Joined 11/13
04 Dec 2013

The number of parameters in the SQL doesn't match the number of parameters reported by the database.
This makes it impossible to match the parameters to the individual statements.
Please use one of the other Execute operations.

fgrimmer 470 comments Joined 04/09
04 Dec 2013

@anhngo56, The problem is that we don't have a parser for Aster and so the question mark is mistaken for a parameterized query. When I tried the same query on my 14.10.01 Studio, I got a different error message, with an option to "continue processing the SQL with an unparameterized handler."

nshah54 2 comments Joined 11/13
17 Jan 2014

I cannot install Teradat Studio 14.10.01. It gives error after Java file location it comes error "The wizard was interrupted before Teradata Studio could be completed install.
Please help.
Thanks,

fgrimmer 470 comments Joined 04/09
17 Jan 2014

I have sent your issue to our install team. I hope to hear back soon. I am assuming you tried a second time to see if it was just a timing issue?

fgrimmer 470 comments Joined 04/09
21 Jan 2014

@nshah54, Can you paste the contents of the log file, %TEMP%\STUDIO.log, available under %TEMP% folder so we can see what went wrong. thanks.

MikeDempsey 77 comments Joined 10/06
21 Jan 2014

sri.aue - I just saw your question about dropdown column name lists after an alias.
SQL Assistant does display column lists after you type an alias name followed by a period. 
However, if you are using the comma separated table/view names in the From clause (as opposed to the 'Join ... On' syntax) it has a problem picking up the last table and alias name in that From clause.
In order to force it to pick that last item up you need to do one of the following:
- Type another comma and then backspace to remove it
- Press Ctrl+Shift+Space after typing the alias name
- continue typing the Where clause after the From.
  (You just need to type the Where keyword and the following space) 
Any of these should make it pick up the table name and the alias - and then that alias can be used to get the column names.

kittudar 2 comments Joined 01/14
24 Jan 2014

This is krishna....cn you pls let me know how to create Teradata 14.0 express studio  new connection profile.......

fgrimmer 470 comments Joined 04/09
26 Jan 2014

Krishna, Follow the steps in the Studio Express article, http://developer.teradata.com/tools/articles/teradata-studio-express, section Creating Connections.

IrishJim 1 comment Joined 02/14
10 Feb 2014

I just had my PC replaced by our PC shop, got updated to Windows 7, and updated to Teradata 14.10 (with Studio Express). Lots new to me.
I got my Studio Express to connect to our Teradata data warehouse, but I also used to use  the Teradata front end to connect to a SQL Server database (which I can't get to connect now), and also to one of the corporate Sybase databases (which don't connect any more).
Judging from your comments in May and June, it sounds like my long-faithful ODBC connections won't be there any more.
However, in other places in this Teradata Developer site I see discussions about ODBC.  Is that just to connect to a Teradata database from a different front end tool?
Also, how do I know when I'm using a 32-bit or a 64-bit program or connection?
Thanks.  Jim

fgrimmer 470 comments Joined 04/09
11 Feb 2014

Jim, Teradata Studio Express uses JDBC to connect to the database. You can still connect to SQL Server but need to use their JDBC driver to connect from Teradata Studio Express. There is a Generic JDBC interface that may work with Sybase and its JDBC driver. ODBC can still be used with other client tools. As for 32-bit or 64-bit, this refers to the application not the connection. Which version of Studio Express did you install. You can check which version of Java it is going to use by opening a DOS window and running java -version.

arun_tim1 2 comments Joined 02/14
28 Feb 2014

Hi ,
I would like share my issue which is currently facing in Teradata parallel transporter script in Z/Os. I am having the TPT job for loading file data into table but the file volume is high.
i am using the DATA CONNECTOR AS PRODUCER to read the file. i gave producer instance as 2 but it is taking 1 instance to read file.
Like , Instance 1 Reading file 'DD:PTYIN'. i have used the attribute MultipeReaders='Y' but the TPT job got disconnecting while acqusition phase.
Kindly help on this !!
Thanks  in advance .
 
 
 
 

fgrimmer 470 comments Joined 04/09
28 Feb 2014

Arun, Please redirect your post to the Tools Forum so someone familiar with TPT can respond. Thanks.

arun_tim1 2 comments Joined 02/14
02 Mar 2014

Thank you very much !

jgrattan 1 comment Joined 02/11
21 Mar 2014
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/error-2738-could-not-access-vbscript-run-time-for/1a4499ae-8bc1-4534-9c6f-4d399ac70d9a

@nshah54 - I was having a similar error as you in a Win7x64 environment when attempting to install the 64-bit version.  I decided to then try the 32-bit version and received an error similar to "Error 2738 could not access VBScript run time for custom action".  I searched the internet and found a forum discussion on this at the link in this post.  The fix referenced by EmilyF resolved the issue for me, with my 64-bit installation and I was able to also launch the application.  I've had a similar issue with another development application on this same system and am hopeful it may also address it, as the behavior is very similar (i.e. installation fails or quits near the beginning of the install process with limited diagnostic information).

fgrimmer 470 comments Joined 04/09
23 Mar 2014

John, Thanks for the link!

Adi_C 1 comment Joined 06/14
19 Jun 2014

Do the same license terms apply to all products? I.e. does Studio require a different license from Studio Express?

fgrimmer 470 comments Joined 04/09
19 Jun 2014

Adrian, Both Studio and Studio Express have the same download license.

kurmarao1 7 comments Joined 02/14
1 month ago

Don't we have any teradata tool,that  will execute stored procedures with out installing  C/C++/VC++ compilers externally?..
because teradata is releasing hell lot of versions month over month..
But none of the tools are inbuilt  C/C++/VC++ compilers and executing Stored Procs without  any issues?.. 
 
 
 

fgrimmer 470 comments Joined 04/09
1 month ago

Kurmarao, With Teradata Studio or Studio Express, you can execute (Run... menu option) C/C++/VC++ stored procedures. But we don't include compilers for C/C++/VC++. You must build them and load outside the tool. That functionality is on our list of future features but currently low priority.
We do provide tools to help build and load Java stored procedures as part of our Teradata Plugin for Eclipse product.

kurmarao1 7 comments Joined 02/14
1 month ago

Thank You

WayneNewton 2 comments Joined 05/09
1 month ago

Hi Francine, Just making the move from SQLA to Studio. Currently running Studio 14.10.01. In SQLA, I frequently edit in column-mode by pressing CTRL while highlighting text and dragging the mouse down. This allows you to align text easily. I cannot find similar functionality in Studio. Can you please tell me if there is a hidden key sequence or command in Studio to do this. Thanks!

fgrimmer 470 comments Joined 04/09
1 month ago

Wayne, I am trying to repeat the sequence in SQLA Edit Table and it highlights the rows as I drag down the mouse, as if selecting those rows. Is that the behavior you are looking for? If so, you can select multiple rows in the Studio Table Editor by selecting the row number column and pressing the Shift key or CTRL key to include other rows. I apologize if I am not following.

WayneNewton 2 comments Joined 05/09
1 month ago

Hi Francine, In SQLA you can press and hold either CTRL or ALT while selecting (highlighting) with your mouse. Could you please try going into SQLA's Query Window, click anywhere inside the Query Window. Now, press and hold either CTRL or ALT, then press and hold the left mouse button and then drag your mouse down and across. You should see a highlighted rectangle. This is the behaviour I was looking for. Sorry that my previous post was a little vague. Hope this one is clearer. It's a really nice feature - hope it's in Studio. Thanks and regards, Wayne.

dhg 1 comment Joined 04/10
2 weeks ago

At what point does Smart loader convert into JDBC fastload mode vs. just JDBC, 50K rows?
Thanks!!

fgrimmer 470 comments Joined 04/09
2 weeks ago

David, When it begins the load process, if the file contains more than 100,000 rows it will use JDBC FASTLOAD option else JDBC BATCH INSERT. There is also consideration of column types. If JDBC sees a column type that is not supported by FastLoad, it will switch to Batch Insert.

You must sign in to leave a comment.