#DateForumTypeThreadPost
54426 Apr 2016 @ 10:37 PDTToolsReplyTeradata procedure creation || Aquadata studio What kind of stored procedure are you trying to create? SQL stored procedure, Java external stored procedure, C external stored procedure?   What is the complete error that you are getting?
54321 Apr 2016 @ 01:54 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCCarrie's blog has some additional information about this topic. She lists the benefits of Utility Limits (a.k.a. Utility Throttles) over the old tenacity and sleep approach. https://developer....
54219 Apr 2016 @ 10:26 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCThe Viewpoint User Guide is available here: http://developer.teradata.com/viewpoint/reference/user-guide   In the Teradata Viewpoint 15.11 User Guide, you will want to review Chapter 33 &qu...
54118 Apr 2016 @ 10:08 PDTConnectivityReplyDelay in establishing connection form hibernate to Teradata.You can specify the LOG=TIMING connection parameter, which will log to System.out the elapsed time for each of the steps of establishing the socket connection and logging on to the Teradata Databas...
54018 Apr 2016 @ 09:57 PDTGeneralReplySet tenacity and sleep in Tearadata JDBCFred is correct -- "tenacity" and "sleep" functionality are NOT provided by the Teradata JDBC Driver, and if you want that kind of functionality in your application, then you&nb...
53908 Apr 2016 @ 09:33 PDTDatabaseReplySubtracting Timestamps as decimals hoursYou clearly have a business need to use a UDF like the TimeStamp_Diff_Seconds function that Dieter offered. I think that you should escalate this issue to your management and obtain permission to u...
53807 Apr 2016 @ 09:50 PDTDatabaseReplyHow do I list the installed jar files inside Teradata Database?DBC.JARS is a Data Dictionary view, and you are not permitted to delete rows directly from the underlying Data Dictionary table.   In order to remove a Jar file from your Teradata Database, ...
53707 Apr 2016 @ 09:45 PDTConnectivityReplyRetreiving database name from JDBC connectionThe short answer is No.   The longer answer is... I covered this topic in my blog https://developer.teradata.com/blog/tomnolan/2012/03/how-to-determine-or-switch-the-current-database-using-...
53601 Apr 2016 @ 11:29 PDTTeradata ApplicationsReplyHow to find number of concurrent users in TeradataPlease refer to the Teradata Database "Data Dictionary" Reference, Chapter 3 "Views Reference", the LogOnOffV[X] views. The following query should provide the kind of informatio...
53501 Apr 2016 @ 10:39 PDTDatabaseReplyHow do I list the installed jar files inside Teradata Database?Jar files are listed in the SQLJ.JARS view. This information is documented in the Teradata Database "Data Dictionary" Reference.
53430 Mar 2016 @ 06:53 PDTDatabaseReplyHow PDE increase Teradata performance?>>> Can't a Oracle machine do the samething with parallel hints?   This is a Teradata forum. Questions about Oracle should be posted to an Oracle forum.
53328 Mar 2016 @ 01:51 PDTDatabaseReplyViews - internal processing stepsNo, the Teradata Database does not materialize the view before querying the view.   Prefix your query with the EXPLAIN keyword in order see all the steps that the Teradata Database will perf...
53222 Mar 2016 @ 11:52 PDTConnectivityReplyErrors obtaining jdbc:default:connection from external Java stored procedureCorrect -- you should not include terajdbc4.jar and tdgssconfig.jar within your jar file that contains your stored procedure.
53122 Mar 2016 @ 11:50 PDTDatabaseReplyJava external stored procedure returns ResultSet - how to insert this contents to a (temporary) tableIt's not possible to use a stored procedure's output dynamic result set as input to another SQL statement.   You will need to change your stored procedure to insert the data into the...
53021 Mar 2016 @ 01:38 PDTDatabaseReplyGUID data type equivalent in TeradataYou can store a GUID in character format in a VARCHAR column, or store a GUID as a binary value in a VARBYTE column.
52917 Mar 2016 @ 10:22 PDTGeneralReplyDo Forum posts get deleted ?yottadata, please remember that Developer Exchange segregates Comment activity from Forum activity. Perhaps your post was in the other category than where you searched?   For reference, here...
52814 Mar 2016 @ 09:46 PDTConnectivityReplyUnable to establish connection between R studio and TeradataIf you're a Teradata customer, please open a customer service incident.
52711 Mar 2016 @ 10:05 PSTConnectivityReplyUnable to establish connection between R studio and TeradataThat exception is due to tdgssconfig.jar not being accessible on the classpath, as discussed in the Troubleshooting section of the Teradata JDBC Driver User Guide. http://developer.teradata.com/do...
52601 Mar 2016 @ 01:26 PSTToolsReplyTransfering data from one server to anotherA couple of options are:   1. Teradata QueryGrid Teradata-to-Teradata http://www.teradata.com/News-Releases/2015/Teradata-QueryGrid-Expands-Customer-Choice-for-Best-of-Breed-Analytic-Techno...
52526 Feb 2016 @ 06:46 PSTTeradata StudioReplyTeradata Studios Default Time DisplayMy recommendation is that you use the CURRENT_TIME function instead of the TIME function. The Teradata Database documentation indicates that the TIME function is deprecated, so you should stop usin...
52424 Feb 2016 @ 01:49 PSTTeradata StudioReplyTeradata Studios Default Time DisplayThe Teradata Database Reference / "SQL Functions, Operators, Expressions, and Predicates" says the following:    TIME versus CURRENT_TIME TIME is deprecated. Use the ANSI SQL...
52322 Feb 2016 @ 10:49 PSTConnectivityReplyParameters in JDBC Connector for Kereberos Connection The documentation says "To put the information in a file, specify the location of that file with the JVM directive".   The following is a command-line option that must be adde...
52212 Feb 2016 @ 10:32 PSTConnectivityReplyParameters in JDBC Connector for Kereberos Connection To use Kerberos authentication, specify the Teradata JDBC Driver connection parameter LOGMECH=KRB5 which is documented here: http://developer.teradata.com/doc/connectivity/jdbc/reference/current/j...
52112 Feb 2016 @ 09:36 PSTConnectivityReplyJavaDoc for JDBC DriverThe com.teradata.jdbc.jdk6 package is an internal, undocumented, package of the Teradata JDBC Driver. That package name is subject to change, and all the classes in that package are subject to chan...
52011 Feb 2016 @ 10:53 PSTConnectivityReplyJavaDoc for JDBC DriverAll Teradata JDBC Driver documentation is available here on Developer Exchange: http://developer.teradata.com/doc/connectivity/jdbc/reference/current/frameset.html   In the left naviga...

Pages