#DateForumTypeThreadPost
29422 Jan 2014 @ 12:37 PSTConnectivityReplytd wallet for jdbcNo, at the present time, there is no interoperability between Teradata Wallet and the Teradata JDBC Driver.   The primary obstacles are (1) Teradata Wallet uses native platform-dependent cod...
29320 Jan 2014 @ 08:27 PSTTeradata StudioReplyError with Teradata Embedded JDBC Driver (TD14)Please refer to the "Troubleshooting Security" section of the Teradata JDBC Driver User Guide. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5.html...
29220 Jan 2014 @ 06:58 PSTConnectivityReplyHow to disable DNS COP lookup at loginYes, you can define the Teradata Database hostname in an /etc/hosts file and the Teradata JDBC Driver will use that.   You should specify the COP=OFF connection parameter so that the Teradat...
29116 Jan 2014 @ 06:52 PSTTeradata ApplicationsReplyUnity Source LinkRaja, if you're actually interested in Unity Source Link, then you should read the documentation. http://www.info.teradata.com/edownload.cfm?itemid=131360001 http://developer.teradata.com/dat...
29008 Jan 2014 @ 07:13 PSTConnectivityReplyFrequency timeout when connect to the TD14 vitrual machine.The Teradata JDBC Driver User Guide (located here on Developer Exchange) includes a Troubleshooting chapter. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_5....
28908 Jan 2014 @ 06:37 PSTConnectivityReplyColumn Title Impact in Java - issueAre you using ResultSet getter methods that have a columnName argument? If so, then it is expected that you will only be able to retrieve one of the column values if there are two columns with the ...
28807 Jan 2014 @ 12:40 PSTConnectivityReplyDoes the Teradata JDBC drivers has support for turkish charactersYes, the Teradata JDBC Driver supports Turkish characters.   The destination column must be declared as CHARACTER SET UNICODE, or the Teradata Database will return Error 6706 "The strin...
28720 Dec 2013 @ 09:31 PSTConnectivityReplyUnable to connect to Teradta Express 13 via JDBC I'm not sure why you copy-and-pasted all that documentation from the Teradata JDBC Driver User Guide. Yes, I'm familiar with all that documentation, because I wrote it.   You no...
28619 Dec 2013 @ 06:42 PSTDatabaseReplyEXPLAIN IN XML Plan Truncated in JDBC in Teradata 13.10I have not heard of this problem before. Your profile says that you work at Cisco. You should open an incident with Teradata Customer Service to report the problem.
28519 Dec 2013 @ 06:39 PSTConnectivityReplyTeradata JDBC Exception If your Java application is running on Windows and you receive an error message "Incomplete LAN message header", then you have a different problem than the "Slow Logon on Linux"...
28419 Dec 2013 @ 06:39 PSTConnectivityReplyUnable to connect to Teradta Express 13 via JDBC If your Java application is running on Windows and you receive an error message "Incomplete LAN message header", then you have a different problem than the "Slow Logon on Linux"...
28317 Dec 2013 @ 11:22 PSTAnalyticsReplyWhy FastLoad Does not support NUSI ?Dieter gave a good reason why FastLoad doesn't need to support NUSIs.   Regarding the original question of why FastLoad doesn't support NUSIs -- it's the same reason why FastLoad...
28211 Dec 2013 @ 01:28 PSTDatabaseReplyMacro Metadata Log TableDBQL tables fill up rapidly and can grow quite large, so most customers have automated procedures in place to archive and delete old records from DBQL tables.   You would have to work with t...
28110 Dec 2013 @ 11:39 PSTDatabaseReplyHow long it will take to insert 20 million rows to teradata table from java using jdbc drivers TYPE=FASTLOADCSV As Kawish said, the throughput that you obtain will be dependent on many factors, such as the number of columns, the average amount of data per row, the available network bandwidth, the CPU and I/O...
28010 Dec 2013 @ 11:20 PSTDatabaseReplyPerformance Metrics for Fastload Implementation Options: 1.JDBC Fastload 2.JDBC Fastload CSV 3.(External scripted) Fastload No, there are no published performance metrics, and we (Teradata Engineering) are unlikely to publish anything like that, for a couple of reasons: 1. We want to avoid the notion of "competiti...
27909 Dec 2013 @ 12:40 PSTDatabaseReply"CONTAINS" opertatorFor questions about functions and operators, you should refer to the Teradata Database SQL Reference volume "SQL Functions, Operators, Expressions, and Predicates". All Teradata documenta...
27809 Dec 2013 @ 12:32 PSTDatabaseReplyMacro Metadata Log TableIf you enable query logging, DBQL will contain most of what you asked for, such as "who execute, when exec, success flag". I'm not sure what you mean by "count(*)"...
27705 Dec 2013 @ 08:43 PSTTeradata StudioReplyError - Right truncation of string dataI agree with Francine. DannyChin, you said "The same query runs fine in SQL Assistant." No, it doesn't "run fine". What it actually does is truncate your data silently witho...
27602 Dec 2013 @ 11:16 PSTDatabaseReplyChange DBS Language support modeChanging the Language Support Mode requires a sysinit. That's the only way.
27502 Dec 2013 @ 06:40 PSTTeradata ApplicationsReplyselect * works but not "select count(*)" via JDBCDid this problem only occur once? Or is the problem reproducible? Did you examine /var/log/messages on the Teradata Database server to see if any problems are reported there?
27422 Nov 2013 @ 06:40 PSTMarketing & CRMReplyBusiness solution without TechnologyRaja, in the future, post meaningful questions. The OP was close to trolling. If I see you trolling again, I will ban your account.
27321 Nov 2013 @ 06:54 PSTMarketing & CRMReplyBusiness solution without TechnologyWhat is a "business solution without technology"? Even an entirely paper-based business solution without any computers uses paper technology.   Therefore, the answer to the or...
27220 Nov 2013 @ 06:57 PSTDatabaseReplyUnable to access application tables.Sayali, did you read what I posted? That error typically comes from your application calling DatabaseMetaData methods such as DatabaseMetaData.getColumns, not from querying tables.
27119 Nov 2013 @ 06:45 PSTDatabaseReplyUnable to access application tables.This is not a bug. You must be granted SELECT access to DBC.UDTInfo in order to call some of the DatabaseMetaData methods that can return UDT information.
27018 Nov 2013 @ 06:45 PSTConnectivityReplyUnable to connect to Teradta Express 13 via JDBC Marco, you probably have a different problem that the one discussed in this forum thread. The Teradata JDBC Driver is used to connect to the Teradata Database, not the Aster Database.   You ...

Pages