569 | 27 Jun 2016 @ 01:45 PDT | Database | Reply | special 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 ... |
568 | 27 Jun 2016 @ 10:50 PDT | Database | Reply | special 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... |
567 | 22 Jun 2016 @ 04:54 PDT | Database | Reply | ISOLATING A BLOCK OF TEXT FROM A LARGER BLOCK OF TEXT WITHIN 1 COLUMN | The 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... |
566 | 22 Jun 2016 @ 04:43 PDT | Database | Reply | How to query specific time |
select * from MyTable where scan_tm = time '11:22:33'
|
565 | 21 Jun 2016 @ 06:38 PDT | Database | Reply | Teradata Table Naming |
select databasename,tablename from dbc.tablesv where characters(tablename) > 30;
|
564 | 15 Jun 2016 @ 11:55 PDT | Database | Reply | Database 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... |
563 | 15 Jun 2016 @ 11:35 PDT | Database | Reply | Getting junk values for Latin column when using JDBC | If 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 ... |
562 | 14 Jun 2016 @ 04:19 PDT | Database | Reply | Getting junk values for Latin column when using JDBC | The "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... |
561 | 14 Jun 2016 @ 04:16 PDT | Database | Reply | SQL error using Teradata JDBC | Error 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... |
560 | 13 Jun 2016 @ 06:59 PDT | Tools | Reply | TD 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... |
559 | 03 Jun 2016 @ 02:00 PDT | Database | Reply | ColumnValueList | You could write a script or a program to do that.
|
558 | 26 May 2016 @ 06:56 PDT | Teradata Applications | Reply | BSD compatibility | BSD 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 ... |
557 | 23 May 2016 @ 09:37 PDT | Database | Reply | Macro vs Procedure - SQL SECURITY | Teradata Database Reference / SQL Data Control Language / Chapter 2 "Statement Syntax / section "Grant (SQL Form) / subsection "Security Considerations With the CREATE MACRO Privileg... |
556 | 20 May 2016 @ 10:22 PDT | Database | Reply | Macro vs Procedure - SQL SECURITY | As 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... |
555 | 20 May 2016 @ 10:08 PDT | Tools | Reply | Need help in using SQL Assistant | I 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... |
554 | 18 May 2016 @ 11:35 PDT | Database | Reply | how to determine concurrent Instances/connection | There 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... |
553 | 12 May 2016 @ 06:57 PDT | Connectivity | Reply | Teradata JDBC Connection Failure | You 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... |
552 | 06 May 2016 @ 02:00 PDT | Database | Reply | Performance : Stored procedure Vs Bteq | You 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... |
551 | 02 May 2016 @ 09:56 PDT | Connectivity | Reply | TD 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 ... |
550 | 02 May 2016 @ 09:48 PDT | Teradata Studio | Reply | JDBC 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... |
549 | 02 May 2016 @ 09:46 PDT | Teradata Studio | Reply | JDBC Connection properties | The 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... |
548 | 02 May 2016 @ 09:43 PDT | Connectivity | Reply | Delay 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 ... |
547 | 02 May 2016 @ 09:32 PDT | Connectivity | Reply | TD JDBC Driver Upgrade question | Yes, 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:... |
546 | 28 Apr 2016 @ 09:43 PDT | Extensibility | Reply | Java interface to TPT OPERATORS | My 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... |
545 | 27 Apr 2016 @ 11:12 PDT | Tools | Reply | Problem during acceesing the function created on the top of the JAR file installed on the database | It'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... |