Teradata Studio

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

Re: Teradata Studio

Bill, Not quite sure how you would do that from a macro. But you can re-execute data loads from within Studio. After completing a data load (Data Transfer), an entry is placed in the Transfer History View. You can select the entry and press the ReExecute button. It will bring up the dialog and give you the option to replace or append the data.

Enthusiast

Re: Teradata Studio

Thanks, that should work!

Enthusiast

Re: Teradata Studio

Good article Thanks fgrimmer! We recently switched some of our business users from SQL assistant to Teradata Studio and I gave a demo to these users last week I got questions from users and I was not sure these features in Teradata Studio can you please answer these:

  1. Is there any max row limit to export results to a file?
  2. Any option to export results direct to the file without displaying on result set window.

Please update on this. Thank you.

Teradata Employee

Re: Teradata Studio

Ashwin, 1) No, not from a result set. You can filter the data when exporting from a table. 2) We are working on providing this feature now. It will be available in our next release.

Highlighted
Enthusiast

Re: Teradata Studio

When can we expect the next release and what is the version number?

Thank you!

Teradata Employee

Re: Teradata Studio

We are planning a 15.01.00 release by end of year.

Enthusiast

Re: Teradata Studio

Hi fgrimmer,

Our users are facing issue while executing Stored Procedure from Teradata studio here is error:

Failed [5510 : HY000] Invalid session mode for procedure execution.

Elapsed time = 00:00:00.000

My Question : Every time we need to change this Mode or Can we save couple of modes in properties? since user run variety of SQL's may have in different mode so changing the mode every time is hard right.

Please suggest on this.

Thanks.

 

Enthusiast

Re: Teradata Studio

Also Forget to mention:

Some of our users are highly experiencing stability / system freeze issues which make running queries very slow for them. This is on Windows XP OS.

What could be the issue and how can we resolve please suggest.

Thank you!

Teradata Employee

Re: Teradata Studio

Ashwin, The error message 'Failed [5510 : HY000] Invalid session mode for procedure execution.' occurs because "the session mode within which the CALL SQL is submitted is different than the one in which the stored procedure was created. A stored procedure created in ANSI mode cannot be executed in Teradata mode and vice versa." You could have a separate connection profile with the session mode set differently for executing the stored procedure. But a connection profile can only have one TMODE property setting.

Can you provide more information about the system freeze issue? We have fixed some issues with canceling long running queries in our recent release.

Enthusiast

Re: Teradata Studio

Hi fgrimmer,

Hi fgrimmer,

The users are experiencing very long time to connect TD and loading schemas.

While expanding the schemas on left panel under Data Source Explorer when you click on SCHEMAS immediately getting freeze and taking long to get back from freeze. 

Please suggest on this.

Appreciate your quick Response.

Thanks.