Recent comments
Teradata Studio Express 14.01 now available
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.
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
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?
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
Also remove the workspace directory that is created in the user's home directory, such as c:/Users//workspace.
removing all the associated directories after uninstall then reinstall fixed the issue. Thanks!
Jeff
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".
The parser does not keep track of names. In some cases, the alias has not been defined when prompted for code assist.
Is there a way to create folders/subfolders structure within 'Data Source Explorer' > 'DatabaseConnections' list?
cheers
-vh-
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.
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
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.
Is there a way to change the display order in the Data Source Explorer window from alphabetical to hierarchical? Something for like Teradata Administrator?
@tgrahaI, Not at this time.
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.
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.
@Bill828,
The Stored Procedure > Edit problem has been resolved in our next release, 14.02.
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.
Yes, this is on our list of improvements.
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
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?
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
@Bjorn, Which versions of Teradata are you connected to for the two systems?
I'm switching between Teradata 13.00 and 13.10. Just to clearify: This is related to Teradata Studio 14.10
Bjorn S
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
If you can send the DDL for the procecure, we can take a look to see if there is a problem in the parser.
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
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.