#DateForumTypeThreadPost
56927 Jun 2016 @ 01:45 PDTDatabaseReplyspecial char 0xFF convert to 0X1A with character set LATIN1_0A Are you trying to use the Euro sign? That won't work with session character set LATIN1_0A.   According to the Teradata Database Reference / International Character Set Support / Chapter ...
56827 Jun 2016 @ 10:50 PDTDatabaseReplyspecial char 0xFF convert to 0X1A with character set LATIN1_0A You mentioned that column specialchar is varchar(10), but what is its character set? Specifically, is the "specialchar" column declared as:   specialchar varchar(10) character...
56722 Jun 2016 @ 04:54 PDTDatabaseReplyISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMNThe regexp_similar function should provide what you need. select regexp_similar(results, '.*TITLE OF BLOCK.*(WORD2.*WORD4|WORD4.*WORD2).*Signed By.*', 'c') as words2and4 , resul...
56622 Jun 2016 @ 04:43 PDTDatabaseReplyHow to query specific time select * from MyTable where scan_tm = time '11:22:33'  
56521 Jun 2016 @ 06:38 PDTDatabaseReplyTeradata Table Naming select databasename,tablename from dbc.tablesv where characters(tablename) > 30;  
56415 Jun 2016 @ 11:55 PDTDatabaseReplyDatabase per object type -- Best practice or over engineered?"DB names follow no pattern" is not a Teradata best practice.   Please work with your DBAs to design a naming convention for databases that makes sense for your application, and th...
56315 Jun 2016 @ 11:35 PDTDatabaseReplyGetting junk values for Latin column when using JDBCIf you are storing characters in a LATIN column that are actually supported by the Teradata Database for the server-side LATIN character set, then you will be able to retrieve those ...
56214 Jun 2016 @ 04:19 PDTDatabaseReplyGetting junk values for Latin column when using JDBCThe "junk values" might be non-ASCII characters stored in your LATIN column, that cannot be represented with CHARSET=ASCII.   We recommend that you use CHARSET=UTF8 in order to ens...
56114 Jun 2016 @ 04:16 PDTDatabaseReplySQL error using Teradata JDBCError 3536 is a Teradata Database error, not a Teradata JDBC Driver error, so this is not likely to be due to "inconsistent behavior" from the Teradata JDBC Driver.   It is more li...
56013 Jun 2016 @ 06:59 PDTToolsReplyTD utilities and JAVA.The Teradata JDBC Driver implements the wire protocol for FastLoad and FastExport. You do not need to understand the wire protocol.   The Teradata JDBC Driver's FastLoad and FastExport f...
55903 Jun 2016 @ 02:00 PDTDatabaseReplyColumnValueListYou could write a script or a program to do that.
55826 May 2016 @ 06:56 PDTTeradata ApplicationsReplyBSD compatibilityBSD is not a supported client operating system for any of the Teradata client connectivity products.   The only supported way for a BSD application to connect to the Teradata Database is to ...
55723 May 2016 @ 09:37 PDTDatabaseReplyMacro vs Procedure - SQL SECURITYTeradata Database Reference / SQL Data Control Language / Chapter 2 "Statement Syntax / section "Grant (SQL Form) / subsection "Security Considerations With the CREATE MACRO Privileg...
55620 May 2016 @ 10:22 PDTDatabaseReplyMacro vs Procedure - SQL SECURITYAs Dieter alluded to, macro security works very differently from stored procedure security.   The answers to your questions can be found in the Teradata Database Reference "SQL Data Def...
55520 May 2016 @ 10:08 PDTToolsReplyNeed help in using SQL AssistantI agree with VandeBergB. The Teradata Database provides access controls (GRANT / REVOKE) for this purpose. If your team member was not supposed to delete data from the prod system, then he should n...
55418 May 2016 @ 11:35 PDTDatabaseReplyhow to determine concurrent Instances/connectionThere is one, and only one, TCP socket connection per Teradata Database session.   However, note that a "JDBC connection" is a different concept from a "TCP socket connec...
55312 May 2016 @ 06:57 PDTConnectivityReplyTeradata JDBC Connection FailureYou specified 192.168.2.2 as your Teradata Database hostname. Is that correct? Is there a Teradata Database running on a machine with that IP address.   I'm asking because 192.168.x.x is...
55206 May 2016 @ 02:00 PDTDatabaseReplyPerformance : Stored procedure Vs BteqYou can test this yourself with DBQL enabled and compare the captured DBQL data for the two cases.   I would not expect much difference in performance for single-row INSERT statements with l...
55102 May 2016 @ 09:56 PDTConnectivityReplyTD JDBC Driver Upgrade question>>> Can the JDBC driver 15.00.00.20 still work with TD 15.10 if we are not using any new features of 15.10 in our application?   Yes, Teradata JDBC Driver 15.0 is supported for use ...
55002 May 2016 @ 09:48 PDTTeradata StudioReplyJDBC Connection properties>>> I found one that said 'tnano' is now ignored and was only for the fastload connection   That is incorrect. The opposite is true. The TNANO connection parameter is used f...
54902 May 2016 @ 09:46 PDTTeradata StudioReplyJDBC Connection propertiesThe entire Teradata JDBC Driver Reference is available here on Developer Exchange. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/frameset.html   And here is a d...
54802 May 2016 @ 09:43 PDTConnectivityReplyDelay in establishing connection form hibernate to Teradata.I agree with Dieter that the network speed differs between the two connections.   For the "server" connection, how far away from each other are the client and server machines? For ...
54702 May 2016 @ 09:32 PDTConnectivityReplyTD JDBC Driver Upgrade questionYes, Teradata JDBC Driver 15.0 is supported for use with Teradata Database 15.10.   The entire Teradata JDBC Driver supported platforms matrix is available here on Developer Exchange. http:...
54628 Apr 2016 @ 09:43 PDTExtensibilityReplyJava interface to TPT OPERATORSMy post from 2011 is still accurate.   Teradata does not recommend use of TPTAPI via JNI. Our recommendation is for Java applications to use the Teradata JDBC Driver.   The Teradata J...
54527 Apr 2016 @ 11:12 PDTToolsReplyProblem during acceesing the function created on the top of the JAR file installed on the databaseIt's hard to diagnose your problem without seeing all the pieces, including the Java source code for the Java stored procedure.   My initial reaction is that this line looks incorrect: E...

Pages