#DateForumTypeThreadPost
19429 Apr 2013 @ 10:30 PDTConnectivityReplyerror message "two different data types are being set" - documentation? advice?This error typically occurs when using a PreparedStatement batch.   The Teradata Database requires that all parameter values in batch that are bound to the same parameter marker must be the ...
19312 Apr 2013 @ 09:25 PDTConnectivityReplyJDBC Data source for Teradata database in weblogic consoleThe Teradata JDBC Driver Reference here on Developer Exchange lists instructions for how to use the Teradata JDBC Driver with WebLogic.   http://developer.teradata.com/doc/connectivity/jdbc/...
19211 Apr 2013 @ 06:50 PDTDatabaseReplyTeradata DBLinkData Mover is our recommended product for moving data from one Teradata system to another. http://www.teradatamagazine.com/Article.aspx?id=13432   TPT can use an ODBC driver to communicate ...
19110 Apr 2013 @ 11:18 PDTDatabaseReplySession to Node MappingRegarding your original question: "When a user tries to establish a connection to Teradata, will Teradata Gateway receive and send that request to any 1 NODE?(if yes, on what basis)" Ses...
19010 Apr 2013 @ 11:13 PDTDatabaseReplySession to Node MappingPEs can communicate with any/all AMPs as needed, regardless of whether the AMP is located on the same node as the PE ("on-node") or a different node ("off-node"). The Bynet hand...
18910 Apr 2013 @ 06:36 PDTDatabaseReplyJDBC - create timestamp from LogonDate and LogonTimeMahesh, please start a new topic in the Connectivity forum for your issue. Please do not post problems to unrelated topics. Thanks.
18829 Mar 2013 @ 10:51 PDTConnectivityReplyJDBC updateRow error - No value has been set for parameter 3The fix for JDBC DR 163807 is now available in Teradata JDBC Driver versions 13.00.00.32, 13.10.00.35, 14.00.00.36, and 14.10.00.16.
18728 Mar 2013 @ 06:45 PDTTeradata ApplicationsReplyTeradata Syntax TroubleDieter is correct that the Teradata JDBC Driver does not have a "BTEQ mode". What is the data type of the EXCH_RATE_START_Y column? If the EXCH_RATE_START_Y column is a DATE already, th...
18615 Mar 2013 @ 10:00 PDTTeradata ApplicationsReplyselect * works but not "select count(*)" via JDBCIt is supported to do a select count(*) from DBC.AccessRights. I just tested that using Teradata JDBC Driver 14.00.00.33 with several different Teradata Database releases. Your exception text ...
18515 Mar 2013 @ 09:46 PDTDatabaseReplySql column alias contains non-English CharactersAs you said, CHARSET=UTF8 is recommended. Please use it. The only reason that CHARSET=UTF8 might not work for your application is for retrieving fixed-width CHAR columns, and your application h...
18413 Mar 2013 @ 01:07 PDTDatabaseReplyParameter substitution to allow Explain A caution -- in case you are asking about in-flight JDBC/ODBC/etc. parameterized queries that you want to explain using a separate session and/or a separate tool like BTEQ. If you simply subs...
18313 Mar 2013 @ 12:50 PDTConnectivityReplyJdbc Driver - What's New in ..The Teradata JDBC Driver User Guide (here on Developer Exchange) has an Overview chapter containing a "What's New" section that lists all the important changes release-by-release: h...
18207 Mar 2013 @ 06:35 PSTToolsReplyUsing FastExport with Teradata JDBC DriverTeradata JDBC Driver 14.00.00.33 is now available for download here on Developer Exchange. It contains the fix for DR 161123 ("Bypass JDBC FastExport for unsupported ResultSet scrollability, c...
18101 Mar 2013 @ 09:46 PSTConnectivityReply[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is emptyNo, there is no Connection URL parameter to suppress this check. Any time a Java application calls the executeBatch method for an empty batch, the Teradata JDBC Driver will throw SQLException with...
18001 Mar 2013 @ 09:43 PSTConnectivityReplyJdbc Driver < > Teradata Instance Version Level CompatibilityI'm not sure what you mean by "Instance". I will take a guess that you mean the Teradata Database version. Our Supported Platforms matrix, published here on Developer Exchange, ...
17927 Feb 2013 @ 03:24 PSTConnectivityReply[TeraJDBC 13.10.00.32] [Error 1382] [SQLState HY000] The batch is emptyError 1382 indicates that the Java application called the executeBatch method with an empty batch. This problem typically occurs due to an application bug such that the application is inserting ma...
17827 Feb 2013 @ 03:21 PSTConnectivityReplyJDBC updateRow error - No value has been set for parameter 3JDBC DR 163807 - Updatable ResultSet exception "No value has been set for parameter" with unique column has been created to cover this problem. Thanks for reporting it to us!
17721 Feb 2013 @ 09:32 PSTConnectivityReplyQuery Timeout again....Peter, this thread was regarding the .NET Data Provider for Teradata. Please create a new thread for your issue. Thanks.
17621 Feb 2013 @ 09:25 PSTToolsReplyUsing FastExport with Teradata JDBC Driver >>> about the fast export jdbc connectivity. is there any detailed instructions how to get the row count before fetch by not using select count(*)? Select count(*) is the only way to ...
17515 Feb 2013 @ 08:41 PSTThird Party SoftwareReplyTeradata JDBC driver is too slow when access CLOB access from Teradata. This is sample code I tested with my systemSome more information would be helpful... What version of the Teradata Database are you using? What version of the Teradata JDBC Driver are you using? How many rows did your query select? How big...
17431 Jan 2013 @ 09:49 PSTConnectivityReplyTD JDBC Error 857 - Two different data types are being set for parameter 42 when using sqoopPlease provide the complete exception message and stack trace.
17307 Jan 2013 @ 09:48 PSTDatabaseReplyParse and validate select statementYes, the way to parse and validate a SQL select statement without executing it, using the Teradata JDBC Driver, is to prepare the SQL statement: PreparedStatement ps = con.prepareStatement("s...
17212 Dec 2012 @ 01:42 PSTThird Party SoftwareReplyColdfusion and TeraData JDBC Documentation Documentation for how to use the Teradata JDBC Driver with ColdFusion is available as part of the Teradata JDBC Driver Reference here on Developer Exchange. http://developer.teradata.com/doc/c...
17112 Dec 2012 @ 10:40 PSTToolsReplyExamples of writing prepared statements in CLIv2Appendix A of the Network CLIv2 Reference manual contains section titled "Sending a Parameterized SQL Using APH Defined Extension Elements" which lists an example C program that executes ...
17007 Dec 2012 @ 08:50 PSTToolsReplyExamples of writing prepared statements in CLIv2Sybase's original proprietary connectivity library was DB-Library, and it has been superseded by CT-Library. Each database vendor's proprietary connectivity library is typically quite diff...

Pages