Teradata Studio Express 14.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX. It is built on top of the Eclipse Rich Client Platform (RCP) which allows Teradata Studio Express to benefit from the many high quality Eclipse features available while focusing on value-add for the Teradata Database.

What's New:

  • Find Object/Find Next Object

A new Find button has been added to the Data Source Explorer (DSE) toolbar to find a database object in the DSE tree. Find can also be invoked by entering Ctrl+F shortcut key. The Find operation will open a dialog for you to enter the search value and select a database object type. It will start the search relative to the selected object in the DSE. For example, if you have selected a connection profile node, the find operation will search all of the schemas on that Teradata server. If you have selected a specific schema (or database), the Find operation will search only that schema. Upon locating the object, the Find will select the object in the DSE. If the Teradata View is opened and in focus the object will be opened in the Teradata View.


A Find Next option has been added that will find the next object in the DSE tree that matched the previously entered search value and object type. Find Next uses the F3 shortcut key.

  • Advanced Find Dialog

An Advanced Find dialog is also provided that allows you to choose more detailed find options and presents the list of all objects that match the search value. The Find dialog contains an Advanced Find button to invoke the Advanced Find dialog. The dialog allows the user to select the specific connection profiles or schemas to search, the type of objects for which to search, and a limit on the number of objects found. The search result list is presented in the Teradata View.

  • Teradata View Filter List Option

A Filter option has also been added to the lists that are displayed in the Teradata View for Schemas, Tables, Macros, Stored Procedures, Indexes, User Defined Functions, User Defined Types, and Views. The user can filter the lists by a starting value, ending value, or containing value.

For more information on using Teradata Studio Express, refer to the article, Teradata Studio Express.

Discussion
j355ga 8 comments Joined 12/05
27 Jul 2012

Francine - having trouble with this version. Studio express opens and immediatly shuts down. Reinstall doesn't work. Suspect the registry entries may be the problem. Can you tell me what are the pertinent entries? Thanks

Jeff

fgrimmer 660 comments Joined 04/09
30 Jul 2012

We are not putting entries into the Windows registry. Is there an error message displayed or error log created? The error log is located in the workspace directory, /.metadata/Teradata. Can you verify that you don't have permission issues writing to home directory?

j355ga 8 comments Joined 12/05
30 Jul 2012

This is on a Windows 7 - I have access to c:/, program files etc.

Initially Studio Express 14 was running. Malfunction began after closing it and the reopening. Is there anything else to clean up after the uninstall? I don't see any remaining files in C:\Program Files\Teradata\Client\14.00\Teradata Studio Express nt-x8664

The only thing I see is as shown. Note the error timestamp is july 20. No further logs are created for later run attempts.

2012-07-20 13:11:15,861 Teradata Datatools [Worker-1] INFO com.teradata.datatools.dtp.catalog - DTS0001: Profile [mytd]- Kanji Enabled = false
2012-07-20 13:11:27,904 Teradata Datatools [main] ERROR com.teradata.datatools.dtp.sqltools - Parse Error splitting statement
2012-07-20 13:21:03,982 Teradata Datatools [main] ERROR com.teradata.datatools.dtp.sqltools - Parse Error splitting statement
etc...

Thanks

Jeff

fgrimmer 660 comments Joined 04/09
30 Jul 2012

Also remove the workspace directory that is created in the user's home directory, such as c:/Users//workspace.

j355ga 8 comments Joined 12/05
31 Jul 2012

removing all the associated directories after uninstall then reinstall fixed the issue. Thanks!

Jeff

sailor36 1 comment Joined 09/12
17 Sep 2012

How do I get the Code Assist Autoactivation to work when I alias a table like the following.

dbname.customer as cm

when i try to cm."ColumnName" the list doesn't come up unless i give the fully qualified name like dbname.customer."ColumnName".

fgrimmer 660 comments Joined 04/09
17 Sep 2012

The parser does not keep track of names. In some cases, the alias has not been defined when prompted for code assist.

veehell 3 comments Joined 07/12
22 Sep 2012

Is there a way to create folders/subfolders structure within 'Data Source Explorer' > 'DatabaseConnections' list?

cheers
-vh-

fgrimmer 660 comments Joined 04/09
24 Sep 2012

No, not by the user. The DSE SQL model is an internal model to represent the database objects. The user can create folders/subfolders in the Project Explorer.

palukuri 1 comment Joined 10/12
20 Oct 2012

Hi ,How can i create Database in teradata studio, i tried giving the create database databasename ; but it is giving the parse error splitting statement. Is there any default databases are to work on them.

Thanks
Raja.S.Palukuri

fgrimmer 660 comments Joined 04/09
21 Oct 2012

Our Teradata Studio product can help you create a database, using the Create Schema dialog. Teradata Studio is a separate download from Teradata Studio Express, providing an administrative toolkit for Teradata.

tgraha1 1 comment Joined 06/11
29 Oct 2012

Is there a way to change the display order in the Data Source Explorer window from alphabetical to hierarchical? Something for like Teradata Administrator?

fgrimmer 660 comments Joined 04/09
30 Oct 2012

@tgrahaI, Not at this time.

Bill828 4 comments Joined 03/10
25 Nov 2012

I want to use "Format SQL" function in "SQL/SQL Scratchpad", You know SQL-A is not good when SQL-Text includes "FROM" keyword in functions. for example:
SELECT EXTRACT(DAY
FROM calendar_date) t,
calendar_date
FROM Sys_Calendar.CALENDAR;

I hope Teradata Studio can format it corrtectly. There are some functions(extract, substring, etc.) use "FROM" as operator.

Bill828 4 comments Joined 03/10
25 Nov 2012

I have found another issue, When I use the pop menu "Edit" at one Stored Procedures object, the DDL text is not complete, but "Teradata/Show DDL" is correct. I suggest remove menu item"Edit" or correct it.

fgrimmer 660 comments Joined 04/09
26 Nov 2012

@Bill828,
The Stored Procedure > Edit problem has been resolved in our next release, 14.02.

Ryan.Costello 7 comments Joined 03/11
29 Nov 2012

With regards to viewing the databases in a Hierarchical format, are there plans to implement this kind of view? I find that presentation in Teradata Administrator far more user-friendly from a DBA perspective, is it gives a very easy way to see owner relationships.

fgrimmer 660 comments Joined 04/09
30 Nov 2012

Yes, this is on our list of improvements.

Bjorn 12 comments Joined 08/07
13 Sep 2013

Hi, I have just started using Teradata Studio and have installed version 14.10. I have 2 database connections, one to a Teradata 13.00 system and one to a 13.10 system.
In SQL Editor I run this simple SQL: Select * from DBC.DBCInfo; This execute ok.
Then I change to the other Connection profile and try to run the same sql. This one returns error message:
Failed to execute SQL: Reason Parse Error splitting statement.
Isn't it possible to swicth between 2 different Teradata systems by just changing the Connection Profile?

Bjorn S

fgrimmer 660 comments Joined 04/09
13 Sep 2013

Yes, that works. You can simply choose a difference connection profile from the drop down list.  If the connection profile is not connected, it will ask you if you want to connect. If you are getting a Parse Error, you have something wrong with your SQL statement. It sounds like, with a split error that a semi-colon is in the wrong place. Are there any red underscores present in the SQL?

Bjorn 12 comments Joined 08/07
14 Sep 2013

Hi, the SQL I tested was very simple. Select * from dbc.dbcinfo;
I did not change anything in the sql, I just chose the other connection wich also had status connected. I got this split error message when I tried execute to the other connection. A red underscore occured under the "*" in my statement.

Bjorn S

fgrimmer 660 comments Joined 04/09
14 Sep 2013

@Bjorn, Which versions of Teradata are you connected to for the two systems?

Bjorn 12 comments Joined 08/07
15 Sep 2013

I'm switching between Teradata 13.00 and 13.10. Just to clearify: This is related to Teradata Studio 14.10

Bjorn S

Bjorn 12 comments Joined 08/07
15 Sep 2013

Hi, now it works, the only change I have done is a "Reset to Default" on both my database connections, but they did not change, they still show "TMODE=TERADATA" and "CHARSET=UTF8"
But still I get red underscores on some legal syntaxes and a red cross in front of the statement starting with: "Was expecting one of ....." a long list of legal names.
This happens when I right click on a procedure and choosing "Show DDL". One example: The statement "Locking Table CRM_KAPDB.ActiveLeads FOR WRITE;" get a red underscore under the Locking statement and a red cross in front of the statement. This happens both against Teradata 13.00 and 13.10

Bjorn S

fgrimmer 660 comments Joined 04/09
16 Sep 2013

If you can send the DDL for the procecure, we can take a look to see if there is a problem in the parser.

Bjorn 12 comments Joined 08/07
17 Sep 2013

Hi this is the DDL. The 3 Locking Table statements and the "IF"-test are all marked with red indicating syntax-errors.

REPLACE PROCEDURE CRM_KAPDB.KAP_InsertResponse
( INbruker_id CHARACTER(7)
 ,INselskap_id INTEGER
 ,INresponse_dt DATE 
 ,INresponse_tm CHARACTER(8)
 ,INchannel_typ_cd INTEGER
 ,INchannel_id INTEGER
 ,INresponse_id INTEGER
 ,INnext_step_dt DATE
 ,INmore_info_cd VARCHAR(12) 
 ,INmore_info_txt VARCHAR(100)
 ,INkunde DECIMAL(11,0)
 ,INecamp_id CHARACTER(12)
 ,INselection_dt DATE
 ,INlogonid CHARACTER(7)
 ,INfreetext VARCHAR(2048)
 ,INeier CHARACTER(7)
 ,INfrist_kl INTEGER
 ,INaccount_id INTEGER

)
BEGIN

DECLARE  gid CHAR(7);

BEGIN TRANSACTION
;

/* Usman 20110411, moved locking statement in the beginning to avoid Deadlock */
LOCKING TABLE CRM_KAPDB.ActiveLeads FOR WRITE;
LOCKING TABLE CRM_KAPDB.ReservedLeads FOR WRITE;
/*  B.Saastad Bevisst lock for å unngå Deadlock: */
LOCKING TABLE CRM_KAPDB.Channel_Responses FOR WRITE;

DELETE FROM CRM_KAPDB.Channel_Responses
WHERE
 kunde = :INkunde
 AND account_id = :INaccount_id
 AND ecamp_id = :INecamp_id
 AND selection_dt = :INselection_dt
 AND response_dt = :INresponse_dt
 AND invalid_resp_reason_cd = 4
;

UPDATE CRM_KAPDB.Channel_Responses
SET
 invalid_resp_reason_cd = 4
WHERE
 kunde = :INkunde
 AND account_id = :INaccount_id
 AND ecamp_id = :INecamp_id
 AND selection_dt = :INselection_dt
 AND response_dt = :INresponse_dt
 AND invalid_resp_reason_cd = 0
;

SELECT gident INTO :gid FROM CRM_KAPDB.Selger_Ss WHERE gident=INlogonid
;

IF gid <> '' THEN 
 INSERT INTO CRM_KAPDB.Channel_Responses
 (  kunde
  ,household_id
  ,customer_id
  ,account_id
  ,ecamp_id
  ,selection_dt
  ,response_id
  ,response_dt
  ,response_tm
  ,resp_channel_typ
  ,resp_channel_id
  ,next_step_dt
  ,invalid_resp_reason_cd
  ,more_info_cd
  ,more_info_txt
  ,gident
  ,freetxt
  ,opprettet_av
  ,eier
  ,frist_kl
 )
 SELECT
   :INkunde
  ,Cust.household_id
  ,Cust.customer_id
  ,Cust.account_id
  ,:INecamp_id
  ,:INselection_dt
  ,:INresponse_id
  ,:INresponse_dt
  ,:INresponse_tm
  ,'105'
  ,:INchannel_id
  ,:INnext_step_dt
  ,0
  ,COALESCE(Mic.more_info_cd,'')
  ,:INmore_info_txt
  ,:INlogonid
  ,:INfreetext
  ,:INbruker_id
  ,:INeier
  ,:INfrist_kl
 FROM
  CRM_FO.Customer_All AS Cust
  LEFT OUTER JOIN
  CRM_Kapdb.more_info_cd AS Mic
  ON Mic.ecamp_id=:INecamp_id
 WHERE
  Cust.kunde = :INkunde
  AND Cust.account_id = :INaccount_id
 ;
ELSE 
 INSERT INTO CRM_KAPDB.Channel_Responses
 (  kunde
  ,household_id
  ,customer_id
  ,account_id
  ,ecamp_id
  ,selection_dt
  ,response_id
  ,response_dt
  ,response_tm
  ,resp_channel_typ
  ,resp_channel_id
  ,next_step_dt
  ,invalid_resp_reason_cd
  ,more_info_cd
  ,more_info_txt
  ,gident
  ,freetxt
  ,opprettet_av
  ,eier
  ,frist_kl
 )
 SELECT
   :INkunde
  ,Cust.household_id
  ,Cust.customer_id
  ,Cust.account_id
  ,:INecamp_id
  ,:INselection_dt
  ,:INresponse_id
  ,:INresponse_dt
  ,:INresponse_tm
  ,'101'
  ,:INchannel_id
  ,:INnext_step_dt
  ,0
šššššššššš,COALESCE(Mic.more_info_cd, '')
  ,:INmore_info_txt
  ,:INlogonid
  ,:INfreetext
  ,:INbruker_id
  ,:INeier
  ,:INfrist_kl
 FROM
  CRM_FO.Customer_All AS Cust
  LEFT OUTER JOIN
  CRM_Kapdb.more_info_cd AS Mic
  ON Mic.ecamp_id=:INecamp_id
 WHERE
  Cust.kunde = :INkunde
  AND Cust.account_id = :INaccount_id
 ;
END IF
;

UPDATE CRM_KAPDB.ActiveLeads
FROM
(
 SELECT
   id_nr
  ,navn
 FROM
  CRM_fo_kDB.gident
) AS GNM
SET
  eier = :INeier
 ,frist_kl = :INfrist_kl
 ,behandlet = 1
 ,eier_navn = GNM.navn
 ,next_step_dt = :INnext_step_dt
 ,reservert_av= NULL
WHERE
 ecamp_id = :INecamp_id
 AND selection_dt = :INselection_dt
 AND kunde = :INkunde
 AND account_id = :INaccount_id
 AND :INeier = GNM.id_nr
;

DELETE FROM CRM_KAPDB.ReservedLeads
 WHERE kunde = :INkunde
 AND account_id = :INaccount_id
 AND ecamp_id = :INecamp_id
 AND selection_dt = :INselection_dt
;

END TRANSACTION
;

END;

 

Bjorn S

fgrimmer 660 comments Joined 04/09
17 Sep 2013

Thanks for sharing this large SQL statement. It looks like we have a parser issue with the null statement after the LOCKING FOR WRITE clause. We will look into fixing this.

You must sign in to leave a comment.