#DateForumTypeThreadPost
46931 Jul 2015 @ 06:47 PDTDatabaseReplyFASTLOADCSV Error JAVAYour program needs to iterate through and print the entire SQLException chain, by calling getNextException. Please refer to our JDBC FastLoad sample programs for how to do this. All JDBC sample pro...
46831 Jul 2015 @ 06:43 PDTConnectivityReplyCalling a macro via JDBCPreparing a SQL request is a completely different operation from executing an EXEC macro SQL request.   For the Teradata Database, parsing can and often does occur when preparing a SQL ...
46728 Jul 2015 @ 06:53 PDTTeradata StudioReplyv15.10.3 - commit processing>>> correctly test transactions in Teradata mode. At the moment I can't test some scenarios - particularly error ones involving DDL requests. >>> a couple of exercises that r...
46623 Jul 2015 @ 09:37 PDTTeradata StudioReplyv15.10.3 - commit processing>>> the Teradata manuals page doesn't seem to have a 'jdbc driver manual'   The Teradata JDBC Driver User Guide, and the other available documentation, is published...
46520 Jul 2015 @ 03:14 PDTTeradata StudioReplyv15.10.3 - commit processingTo answer Dieter's question about how the Teradata JDBC Driver behaves in TERA mode with autocommit turned off...   First, some background: As part of the wire protocol between the Terad...
46406 Jul 2015 @ 09:51 PDTHadoopReplyCan we recommend TDCH for Extract-Load processYou are correct that the Teradata JDBC Driver does not support FastLoad checkpoints when using a TYPE=FASTLOAD connection.   However, that is a separate topic from TDCH's internal.f...
46325 Jun 2015 @ 08:08 PDTConnectivityReplyParameter for no of connections or sessions to TeradataIf this application is running on Linux, then it may be encountering the "Slow Logon on Linux" problem, as documented in the Teradata JDBC Driver User Guide. http://developer.teradata.co...
46223 Jun 2015 @ 12:05 PDTDatabaseReplyCreate a PK and PI on a NoPI table>>> Is it actually normal to have such a huge difference in performance between loading into a table with a PK and into a NoPI table?   That is the largest performance discrepancy t...
46122 Jun 2015 @ 11:56 PDTConnectivityReplyTeradata JDBC fastload hangs after 50K recordsThe addition of checkpoint functionality to JDBC FastLoad would be a new feature, not something to be "fixed".   And No, that functionality is not present in Teradata JDBC Driver 1...
46022 Jun 2015 @ 09:50 PDTDatabaseReplyCreate a PK and PI on a NoPI tableYou can use two tables.   You can load data into a NoPI staging table, and then do an INSERT...SELECT from the NoPI staging table into your PI table.
45922 Jun 2015 @ 09:46 PDTConnectivityReplyTeradata JDBC fastload hangs after 50K records>>> We had an Incident to Teradata GSC for 13.10 and the response was use of JDBC for large data set is not recommended in other words its not certified.   That is not correct. JDBC...
45822 Jun 2015 @ 06:54 PDTConnectivityReplyTeradata JDBC fastload hangs after 50K recordsIf you are a customer, then please open an incident with Teradata Customer Service.
45718 Jun 2015 @ 10:18 PDTDatabaseReplyTO_DATE with LIKE causing issues in Prepared statements using JDBCError 3536 is a Teradata Database error. The Teradata JDBC Driver does not generate that error.   You may have found a limitation with the Teradata Database. If you are a customer, please op...
45629 May 2015 @ 01:51 PDTConnectivityReplyDoes TeraJDBC works with JDK/JRE 8 version?The Teradata JDBC Driver is now supported for use with JDK 8, and we have updated our supported platforms matrix published here on Teradata Developer Exchange. http://developer.teradata.com/d...
45527 May 2015 @ 06:47 PDTDatabaseReplyGet the date and time in yyyy-mm-dd 00:00:00 format in TERADATA SQL@gtreddy, you didn't say what tool you are using. For example, are you using BTEQ?   If you are getting an output date/time format that you need to change, then you need to cast the valu...
45419 May 2015 @ 01:57 PDTGeneralReplyRandom Identify Column creationThe INCREMENT BY 1 clause in the CREATE TABLE command can be misleading to people, because it implies that the values will be assigned sequentially with no gaps, but that's not how the Teradata...
45318 May 2015 @ 06:49 PDTDatabaseReplyJDBC queries on Teradata not logged in DBQLogTbl with parameters.First, let's clear up a misconception. The parameterized query with question-mark parameter markers is the "final" query. The Teradata Database does not rewrite the query and replace ...
45215 May 2015 @ 10:15 PDTData ModelingReplySurrogate vs business keys>>> 2. What are the pros and cons of surrogate vs business keys from a real world perspective?   Regarding the OP's question, Wikipedia has a good explanation of the pros and co...
45115 May 2015 @ 09:58 PDTDatabaseReplyGetting junk values from Teradata thru JDBC driver"4.0" is not a valid version number of the Teradata JDBC Driver.   Only Unicode table columns are supported for storing non-Latin characters; however, some customers use the unsupp...
45013 May 2015 @ 06:55 PDTConnectivityReplyDoes TeraJDBC works with JDK/JRE 8 version?The status has not changed. We are currently in the process of testing Teradata JDBC Driver 15.0 with JDK 8 on all our supported platforms. When that process is done, we will update the Supported P...
44905 May 2015 @ 09:39 PDTConnectivityReplyTeiid Designer table metadata read through teradata jdbc connect slow >30sec.Please review the Teradata JDBC Driver User Guide section "DatabaseMetaData Performance". Slow performance of queries against Data Dictionary views can sometimes be due to a lack of accur...
44823 Apr 2015 @ 06:49 PDTDatabaseReplyBulk Insert In Teradata taking alot of time(Using Jdbc driver terajdbc 14.00.00.41)Consider loading your data into an empty staging table using JDBC FastLoad or JDBC FastLoad CSV, and then executing an INSERT...SELECT statement to copy the data from the staging table to your actu...
44722 Apr 2015 @ 08:10 PDTConnectivityReplyGET METADATA FROM JDBC DRIVER (Query NOT performant)Sorry, no, we do not yet have a scheduled availability date for JDBC RFC 161165.
44621 Apr 2015 @ 12:13 PDTConnectivityReplyGET METADATA FROM JDBC DRIVER (Query NOT performant)Regarding the question: "Is there a way to modify the query generate by JDBC driver ?"   No, there is no may for the user to modify the query that is composed by the Teradata JDBC ...
44521 Apr 2015 @ 12:02 PDTDatabaseReplyIncrease the size limit of teradata objects name from 30 characters to more.Teradata Database 14.10 and later releases support object names (such as database names, table names, column names, etc.) up to 128 characters in length.   Keep in mind that you must query t...

Pages