#DateForumTypeThreadPost
1924 Jun 2015 @ 01:36 PDTDatabaseReplyNUSI when accessing data from a viewI've just seen that this "TOP 100 PERCENT" is used in the application to create ordered views when working on Teradata (I haven't copied the "order by.." in my initial m...
1823 Jun 2015 @ 09:21 PDTDatabaseReplyCreate a PK and PI on a NoPI tableThank you for your help! Carlos, okay, got it. I was confused by the Teradata Studio Express, which actually shows these columns as UPI after I've created a PK on a NoPI table, but I believe y...
1723 Jun 2015 @ 08:55 PDTConnectivityReplyTeradata JDBC fastload hangs after 50K recordsThanks you for clarification!
1622 Jun 2015 @ 07:17 PDTDatabaseReplyNUSI when accessing data from a viewDear Teradata experts, I just wanted to get back to this topic. Any ideas, why this could happen? Thanks! Katja
1522 Jun 2015 @ 07:11 PDTDatabaseTopicCreate a PK and PI on a NoPI tableHello Teradata experts, I have a question regarding NoPI tables. We have a table, which should have a primary key, which also should be set as a unique primary index. For performance re...
1422 Jun 2015 @ 06:44 PDTConnectivityReplyTeradata JDBC fastload hangs after 50K recordsFor information: jdbc driver 14.00.00.37, Teradata DB version 15.0.1.06.
1322 Jun 2015 @ 06:31 PDTConnectivityTopicTeradata JDBC fastload hangs after 50K recordsHello Teradata experts, I'm now working on optimization of loading of data into Teradata. Our application allows to load big csv files by means of jdbc connection and executeBatch. ...
1228 May 2015 @ 05:35 PDTDatabaseTopicNUSI when accessing data from a viewHello, I have the following questions regarding NUSI and the use of views. Let's consider for simplicity, we have the following table: CREATE SET TABLE T1 (p_key INTEGER, c1_ind INT...
1127 May 2015 @ 01:09 PDTToolsTopicTeradata Studio and Teradata Analyst PackHello everybody, I would like to investigate possibilities of Teradata Visual Explain and I'm using Teradata Express Studio (v. 15.00) to connect our Teradata installation. To use the tool...
1029 Sep 2014 @ 07:33 PDTToolsReplyArchive all tables with dataYou are right, the script is correct. There are some other reasons of the problem that we have. I'll create a separate topic for that. Anyways, thanks for your fast reply!
926 Sep 2014 @ 04:40 PDTToolsTopicArchive all tables with dataHi all! May be a very simple question.. I want to dump the current state of the Teradata database. To do it, I use arcmain and the following script: ARCHIVE DATA TABLES (dbname), RELEASE LOCK, ...
823 Sep 2014 @ 05:38 PDTDatabaseTopicTriggers on Views Hello everybody!   In the "Teradata SQL Data Definition Language" book, I read that it is not possible to create triggers on data views. I wanted to ask, whether it is als...
716 Sep 2014 @ 04:31 PDTGeneralReplyProblem when iterating jdbc resultSetThank you for the fast reply!
615 Sep 2014 @ 04:50 PDTGeneralTopicProblem when iterating jdbc resultSet Hello!   We discovered some strange behaviour of a cursor in a result set, when extracting data from the Teradata DB using jdbc. The versions that we use: Teradata database 14.10.00...
505 Sep 2014 @ 05:08 PDTDatabaseReplyError: "3927: Response Parcel requested a max byte count less than 256"Thank you for a fast reply! We will try to get a newer version and double check these problems.
404 Sep 2014 @ 09:08 PDTDatabaseReplyError: "3927: Response Parcel requested a max byte count less than 256"small update here: when I increase the fetch size to 100, it works...  but I think, it is not a normal behaviour?
304 Sep 2014 @ 08:40 PDTDatabaseReplyError: "3927: Response Parcel requested a max byte count less than 256" Hello Teradata experts!   I also have some problem with the error 3927. I'm currently adapting a program that works on the oracle db for the teradata.    The p...
204 Sep 2014 @ 03:16 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]"Thank you very much, you are completely right! one of them was 2644, which I've solved as described in admin guide
103 Sep 2014 @ 09:38 PDTDatabaseReplyerrors "[Teradata JDBC Driver] [TeraJDBC 13.00.00.16] [Error 1339] [SQLState HY000]" Hello,   I have a very similar problem, as described here. The code that I look at was working on Oracle, and with Teradata I get errors with codes 1339 and 1338.  The ...