#DateForumTypeThreadPost
31921 Apr 2014 @ 09:56 PDTDatabaseReplyGENERIC JDBC and Teradata DatabasesWhen you specify the JDBC connection parameter TMODE=ANSI, then the CREATE TABLE command's default behavior is to create a MULTISET table. When you specify the JDBC connection parameter TMODE=...
31821 Apr 2014 @ 09:56 PDTDatabaseReplyGENERIC JDBC and Teradata DatabasesWhen you specify the JDBC connection parameter TMODE=ANSI, then the CREATE TABLE command's default behavior is to create a MULTISET table. When you specify the JDBC connection parameter TMODE=...
31717 Apr 2014 @ 03:10 PDTDatabaseReplyTeradata Java UDFFirst, this forum thread title is incorrect. This is not a Java UDF, this is a Java Stored Procedure.   JDBC/SQL access is supported for Java Stored Procedures, but is not supported for Java...
31616 Apr 2014 @ 06:46 PDTDatabaseReplyExplain PermissionsNo activity has occurred on that DBS RFC since I created it in 2011.   Pierre, your profile says that you are with Orange France. If that's still true, create an incident with Teradata C...
31514 Apr 2014 @ 02:03 PDTGeneralReplysetCharacterStream is not supported The PreparedStatement setCharacterStream method with 2 arguments is not supported yet by the Teradata JDBC Driver.   Instead, you need to use the PreparedStatement setCharacterStream method ...
31417 Mar 2014 @ 09:51 PDTGeneralReply.0 is appending at lat of timestamp value while fetching using java JDBCThe JDK built-in method java.sql.Timestamp.toString prints the Timestamp value with the trailing ".0" That is not under the control of the database or the JDBC Driver.   What exac...
31317 Mar 2014 @ 06:42 PDTToolsReplyTerradataParallelTransporter-Load errorThe Teradata JDBC Driver is the supported interface for Java applications to transfer data to and from the Teradata Database.   Using JNI with TPT is not supported.
31206 Mar 2014 @ 12:42 PSTConnectivityReplyCan I use the Teradata ODBC Linux drivers with Mac OS XThe Teradata ODBC Driver for Mac OS X is intended to be freely available for download from Developer Exchange (it is not limited to customers only) but the download packages are simp...
31128 Feb 2014 @ 06:40 PSTAnalyticsReplyConnecting to Teradata in R via the teradataR packagePlease list all the R code you are using to connect to Teradata.
31018 Feb 2014 @ 06:54 PSTTeradata ApplicationsReplyTPT export and error code 2595OK, abhijitvyas, then you're not using JDBC at all.
30917 Feb 2014 @ 08:34 PSTTeradata ApplicationsReplyTPT export and error code 2595abhijitvyas, TPT Export doesn't use the Teradata JDBC Driver. I'm not sure what you meant here. Did you mean you're using ODBC with TPT? Or did you mean you are using the Teradata JDBC ...
30813 Feb 2014 @ 09:45 PSTGeneralReplyIs dropping/creating tables over and over an ok or should you leave the table structure in place?Here are some reasons why you might want to reuse an existing table for a load job:   1. Creating a table, and dropping a table, are both relatively expensive operations, in terms of ti...
30707 Feb 2014 @ 10:50 PSTTeradata StudioReplyTeradata Embedded JDBC driver includes encryption?LDAP authentication occurs on the server-side by the Teradata Database Gateway. It is not a function of the client-side Teradata Studio or client-side Teradata JDBC Driver.   Here is th...
30607 Feb 2014 @ 09:44 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemI'm glad you were able to find the constant values for java.sql.Types. For reference, here is a link to the official Java documentation from Oracle: http://docs.oracle.com/javase/7/docs/api/c...
30506 Feb 2014 @ 01:01 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemYes, JDBC FastLoad supports NULLs.   The signature (ID)V means that R is attempting to call a method that has int and double arguments, and returns void. Such a method doesn't ...
30406 Feb 2014 @ 09:47 PSTConnectivityReplyJDBC URL specify failover serverFirst, we need to understand what you are trying to do. Are you trying to fail over to a different node within the same Teradata Database system, or are you trying to fail over to a different Terad...
30306 Feb 2014 @ 09:36 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemWell, I'm not an R programmer, so sorry that the j[i1] <- NA didn't fix the problem for you.   Types.INTEGER is a Java constant value equal to 4. Perhaps R does not provide a...
30205 Feb 2014 @ 11:08 PSTConnectivityReplyLoad Nulls with R & JDBC Fastload ProblemThe "myinsert" function tests for NA with this line: if (is.na(arg3)==TRUE) {   The is.na test will only return TRUE for NA, and will return false for NaN.   On line 48 you...
30131 Jan 2014 @ 06:42 PSTTeradata StudioReplyTeradata Export in Eclipse Plugin not using TMODE=TeraYour DBA is concerned about the wrong issue. The potential for a transaction to hold a lock for a long time is not limited to ANSI mode; that can also occur with TERA mode.   Your appli...
30030 Jan 2014 @ 05:54 PSTTeradata StudioReplyTeradata Export in Eclipse Plugin not using TMODE=TeraThere are two aspects to a JDBC FastLoad connection: 1. The first part is what we call the "application SQL connection", which can be either ANSI mode or TERA mode. It sounds like your D...
29930 Jan 2014 @ 06:49 PSTConnectivityReplyJDBC Hebrew SupportFred gave a complete, and correct, answer. I don't really have anything to add from a technical point of view.   Character data in Java is stored as Java String objects, and the Ter...
29828 Jan 2014 @ 11:31 PSTConnectivityReplyJDBC Drivers for Coldfusion running on SUSE LinuxThe Teradata JDBC Driver now supports ColdFusion 10.
29728 Jan 2014 @ 11:03 PSTDatabaseReplyGet query metadata without running itHere is another alternative that doesn't require the creation of the volatile table:   help column * from (select * from dbc.dbcinfo) dt  
29628 Jan 2014 @ 10:57 PSTDatabaseReplyGet query metadata without running itI verified that the CREATE VOLATILE TABLE approach works: create volatile table foo as (select * from dbc.dbcinfo) with no data on commit delete rows help column foo.*     This app...
29522 Jan 2014 @ 12:47 PSTConnectivityReplyExport from Teradata to MySQL using JavaYou would need to write a Java program that uses the Teradata JDBC Driver to execute a SQL query and read the rows from the result set. As the Java program reads each row from the Teradata result s...

Pages