#DateForumTypeThreadPost
49414 Oct 2015 @ 06:54 PDTConnectivityReplyJDBC connection timeout The exception stack trace shows that the Teradata JDBC Driver was unable to connect to the Teradata Database.   If you are able to ping the Teradata Database from the client, but the Te...
49312 Oct 2015 @ 01:43 PDTDatabaseReplyWithin transaction, how to find keys from one table and use those to delete from other tables in a single request?Use an IN-predicate that contains a SELECT subquery, like this:   delete from ChildTable where ChildKey in (select ParentKey from ParentTable where ... )
49205 Oct 2015 @ 01:44 PDTConnectivityReply first time ...to install JDBC Driver 15.10Teradata Studio includes the Teradata JDBC Driver embedded as part of Teradata Studio.   If you are using Teradata Studio, there is no need to separately download the Teradata JDBC Driver.
49105 Oct 2015 @ 09:58 PDTConnectivityReply first time ...to install JDBC Driver 15.10The Teradata JDBC Driver does not have an installer, and it does not need to be installed.   You must list the two jar files -- terajdbc4.jar and tdgssconfig.jar -- on the classpath for...
49002 Oct 2015 @ 09:22 PDTConnectivityReplyWrong result set when iterating through a TYPE_SCROLL_INSENSITIVE jdbc TDResultSetIf you're a customer, please open an incident, so we can get the details from you for reproducing the problem.   At the present time, there is one known issue with the Teradata Database ...
48929 Sep 2015 @ 12:59 PDTDatabaseReplyWrong resultset via JDBC in ANSI ModeThe most common cause of a query returning a different number of rows in ANSI mode versus TERA mode is due to character comparison operations in the query's WHERE clause, such as the equal ( = ...
48825 Sep 2015 @ 06:57 PDTConnectivityReplyExceptionInInitializerError while connecting to Teradata through JDBC DriverThe most likely cause of that error is that the tdgssconfig.jar file is missing from your classpath.   Both the terajdbc4.jar file and the tdgssconfig.jar file must be present on your classp...
48725 Sep 2015 @ 06:48 PDTConnectivityReplyConnecting into Teradata Database from IBMi AS400Teradata does not currently offer any connectivity software for the IBMi AS400 platform.
48615 Sep 2015 @ 06:57 PDTDatabaseReplyError code: 3610 - Internal error, please do not submit the last request. Subcode, Crashcode:0,2693 Teradata Database Error 3610 means that you have encountered a problem with the Teradata Database.   If you are a customer, then please open an incident with Teradata Customer Service to rep...
48515 Sep 2015 @ 06:55 PDTConnectivityReplyConnectng from a 15.00 Client to a 15.10 DatabaseMany, but not all, of the Teradata client products offer forwards compatibility, meaning that they support connecting to a Teradata Database with a later release number than the client softwar...
48409 Sep 2015 @ 09:57 PDTConnectivityReplyRetrieving TimeZone from TimeStampThe Teradata JDBC Driver User Guide has a very detailed section on working with Timestamps and Time Zones. In particular, please read the subsection titled "Receiving DATE, TIME, and TIMESTAMP...
48303 Sep 2015 @ 09:58 PDTConnectivityReplyLogin Failure for connection to severner name through SQL developer ..The most likely cause of that error is that you specified the wrong hostname for the Teradata Database.   If you need further troubleshooting assistance, please provide the complete exceptio...
48227 Aug 2015 @ 01:35 PDTDatabaseReplytrademark sign ™ not properly inserted.What JDBC API method are you using to insert the data?   For example, if you are using a PreparedStatement, and you are binding a Java String value to a question-mark parameter marker by cal...
48121 Aug 2015 @ 12:15 PDTDatabaseReplySubtracting Timestamps as decimals hoursFirst, let's review the basics regarding SQL timestamp arithmetic...   You can obtain the difference between two timestamps as hours with the following syntax: select (timestamp '...
48020 Aug 2015 @ 09:27 PDTConnectivityReplyCalling a macro via JDBCLucas, please start a new forum topic. Please do not add more questions to this thread. Thanks.
47920 Aug 2015 @ 06:45 PDTTeradata StudioReplyComment above REPLACE PROCEDURE causes errorThe Teradata Database requires a special wire protocol to be used for the CREATE PROCEDURE and REPLACE PROCEDURE statements, that is slightly different than the wire protocol used fo...
47814 Aug 2015 @ 06:56 PDTConnectivityReplyCalling a macro via JDBCI can't find that section in newer versions of that documentation.   This is the Connectivity forum, so it's not the best place for questions about the Teradata Database statement ca...
47713 Aug 2015 @ 09:50 PDTDatabaseReplyHelp to Interpret DBQL logging for JDBC running Stored Procedures.Does your application use a PreparedStatement or CallableStatement to call the stored procedure?   If yes, then please be aware that the prepare operation is logged separately from the execu...
47610 Aug 2015 @ 09:14 PDTConnectivityReplyCalling a macro via JDBCYes, exactly.
47510 Aug 2015 @ 09:11 PDTTeradata StudioReplyv15.10.3 - commit processingYes, the Teradata JDBC Driver conforms to the JDBC API Specification, as closely as we are able to.   When auto-commit is turned on, a JDBC Driver is expected to commit each SQL request as i...
47407 Aug 2015 @ 09:38 PDTDatabaseReplyQuery Running Slow with Qualify FunctionPlease refer to my blog post on JDBC ResultSet pagination. http://developer.teradata.com/blog/tomnolan/2012/03/jdbc-resultset-pagination   My blog post refers to the approach that you are u...
47307 Aug 2015 @ 09:31 PDTTeradata StudioReplyv15.10.3 - commit processing>>> the student would have to switch autocommit on/off throughout the exercise.   Yes, that makes sense. Using Studio with the Teradata JDBC Driver is different from using BTEQ.&nbs...
47207 Aug 2015 @ 08:37 PDTData ModelingReplySurrogate vs business keys>>> Every table has a primary key.   First, I think you're confusing the terms "primary key" and "primary index". Those are different concepts for the Terada...
47104 Aug 2015 @ 08:56 PDTDatabaseReplyFASTLOADCSV Error JAVAError 2632 is a Teradata Database error ("All AMPs own sessions for this Fast/Multi Load or FastExport.")   The Teradata Database Messages book says the following: Explanation: Th...
47004 Aug 2015 @ 06:53 PDTConnectivityReplyReading Clob column using teradata JDBC is too slowIn the future, please create a new forum topic for a new question. Please do not add an unrelated post to old thread.   >>> What are the situations wherein we should consider u...

Pages