All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
Teradata ODBC 03.04.00.00 setting for handling UTF8 data Topic by Karraj 20 Mar 2006

Teradata ODBC 03.03 was working fine when used for moving UTF8 data. But with the same setting when ODBC was upgraded to 03.04.00.00, the UTF8 characters are not handled properly. Is there some thing that needs to be set for the ODBC 03.04.00.00 that was not needed for the previous versions of ODBC? Please let me know.

13731 views
0 replies
ODBC- Enable MS-ACCESS Interoperability Mode Topic by candyman 16 Mar 2006

We are using Access to gather Teradata from one source and SQL Server data from another source for comparisonand reporting. My laptop has an ODBC connection that under Options/Advanced it lists two items that need to be checked for proper operation: "Enable MS-ACCESS Interoperability Mode" and "Enable custom Catalog Mode for 2.x Applications". This configuration works. We need to duplicate the process on a desktop, both running XP Service Pack 2. That computer's Options/Advanced window looks alittle different with a Custon Options section at the bottom. It only lists the "Enable custom Catalog Mode for 2.x Applications" line. Not mentioning MS-ACCESS. This configuration with the 2.x option checked FAILS. It does give a message "Can't find host" then lists the same teradata server info. I am not sure whether this is an host access problem or the issue of a missing "Enable MS-ACCESS Interoperability Mode".Please, excuse the length as it has the tech people scratchiing their heads. I can send a jpg of the srceen shots if that would help.Thanks, I am quite stumped.Candyman

29277 views
3 replies, 14 years ago
How to use Decimal(15,2) Topic by Koentje 11 Mar 2006

Can someone give me an example for a very simple UDF. I just want to have the C-code and the definition of the function.Name: UDF_Multiplyby2()Input: Decimal(15,2)Output: Decimal(15,2)To do: Multiply Input by 2, that's all.Teradata gives me always a stack error.I'm using DECIMAL8 as in- and output.Thank's a lot,Koen.

52344 views
2 replies, 14 years ago
Embedded SQL in UDF C code Topic by AP 01 Mar 2006

Can we include embedded SQL in UDF C Code? We want to do some business calculation through UDF. The calculation needs some info from other tables, other than the table which is queried.

13882 views
0 replies
TeraResultSet:getINt: Conversion(l) Topic by Rex Chan 01 Mar 2006

We are getting error in DBMetaData.java method getProcedureMetaData in the following program.String paramType = getParamTypeDescription (rs.getShort("COLUMN_TYPE")); We are getting the error from the Type-3 driver that comes with the Demo Database CD (running Teradata 2.5). The creation date is 2/27/2003.If you have seen this error, please let us know how you resolve it.import java.sql.*;import com.ncr.teradata.*;class test_proc{ static Connection con = null; static DatabaseMetaData dbmd = null; static String errMsg = null; static String url_type3 = "jdbc:teradata://teradata:6666/DemoTDAT"; public static void main (String args[]) { try { // Load the Teradata Driver Class.forName ("com.ncr.teradata.TeraDriver"); // get the connection con = DriverManager.getConnection(url_type3, "dbc", "dbc"); //getting metadata dbmd = con.getMetaData(); //calling getProcedureMetaData() method getProcedureMetaData("","manufacturing","GetChildren","PROCEDURE"); //closing connection System.out.println("Closing Connection"); con.close(); } catch (java.lang.Exception ex) { ex.printStackTrace (); } } public static void getProcedureMetaData(String pcatalog, String pschema, String pname, String ptype) throws Exception { errMsg = ""; try { if (pcatalog.equals("")) { pcatalog = null; } if (pschema.equals("")) { pschema = null; } // get procedure parameter information ResultSet rs = dbmd.getProcedureColumns(pcatalog, pschema, pname, "%"); int pos = 0; while (rs.next()) { pos++; String parmName = rs.getString("COLUMN_NAME"); if (parmName != null) { // strip off "@" in front of parameter name if (parmName.charAt(0) == '@') { parmName = parmName.substring(1); } } else { // parameter name is not return - call it "param" parmName = "param" + String.valueOf(pos); } System.out.println("panam name : "+parmName); int dataType = rs.getInt("DATA_TYPE"); // we are getting error in the below line //java.sql.SQLException: [NCR][Teradata JDBC Driver]:TeraResultSet:getInt: conversion error (I) short paramType = rs.getShort("COLUMN_TYPE"); System.out.println(paramType); int nullable = rs.getShort("NULLABLE"); int numericPrecision = rs.getInt("PRECISION"); short numericScale = rs.getShort("SCALE"); // create a parameter and add it to the vector } rs.close(); // now copy Vector to array // now set up parameters in the procedure to return } catch (Exception e) { e.printStackTrace(); errMsg = e.getLocalizedMessage(); throw e; } } }

14206 views
0 replies
unable to install Teradata odbc driver 03.05.00 Topic by Shri Rao 22 Feb 2006

I am trying to install the teradata odbc drivertodbc_windows_i386.03.05.00.00.exe as I am using MDAC 2.8.1. It gives me the following errorThe NTVDM CPU has encountered an illegal instruction.Thanks in advance,Shri

14509 views
0 replies
Oracle Gateway - Teradata ODBC - unable to insert dates Topic by jkurzy 31 Jan 2006

Hello,I am using the Oracle Gateway for Teradata, Teradata ODBC version 3.5. I have created a table in Oracle and loaded it with 5000 rows. I created the same table in Teradata and attempted to load it from Oracle. Having trouble getting dates to load.Oracle TableSQL> desc applications3 Name Null? Type ----------------------------------------- -------- ---------------------------- APP_ID NUMBER(38) SUB_ID NUMBER(38) WARR_PLAN_ID NUMBER LANGUAGE_CODE CHAR(2) DAYS NUMBER(38) CURRENCY_CODE NUMBER(38) CONTRACT_TYPE_CODE CHAR(3) AMORTIZATION_INTEREST NUMBER(9,6) LIFE_STATUS NUMBER(38) CURRENT_WQ NUMBER(38) LOCK_STATUS NUMBER(38) DAG_ID NUMBER(38) CONTRACT_NO NUMBER(8) CONTRACT_CREATED_BY NUMBER(38) ENTERED_BY NUMBER(38) LOCKED_BY NUMBER CONTRACT_CREATED_DATE DATE ENTERED_DATE DATE OWNED_BY NUMBER(38) SUBFOCUS_BY NUMBER(38) SUBFOCUS_DATE DATE DEALER_ID NUMBER(38) LAST_ARCHIVED_BY NUMBER LAST_ARCHIVED_DATE DATE COUNTRY_CODE CHAR(2) IVA_RATE NUMBER APP_ADDRESS_GRP NUMBER(38) DISCOUNT_RATE NUMBER(9,6) APP_TYPE_ID NUMBER(38) FOCUS_BR_CODE NUMBER(2) IRR NUMBER(9,6) WARR_AMT_FINANCED CHAR(1) PRE_APPRV_AMT NUMBER(10,2) PRE_APPRV_TERM NUMBER PRE_APPRV_PMT NUMBER(10,2) PRE_APPRV_EXP_DATE DATE RECALC_REQUIRED CHAR(1) CBRA_ID NUMBER(38) INTEREST_RATE_TYPE CHAR(1) CHRG_OPEN_FEE CHAR(1) GFV_AMT NUMBER(9,2) IS_MULTI CHAR(1) TRANSFER_DATE DATE IS_CONTRACT_BACKDATED CHAR(1) CONTRACT_DATE_EXPIRED CHAR(1) IS_COTIZADOR_APP CHAR(1) PURCHASE_TYPE_CODE CHAR(1) LEASE_CONTRACT_NO NUMBER(38) NON_ZERO_DAYS NUMBER(38) SUBS_VAL NUMBER(9,6) CURRENT_VERSION NUMBER(38) CHECK_VIN CHAR(1) PAYSTATUS CHAR(1) CSC CHAR(1) IS_SCORED CHAR(1) FRANCHISE_CODE VARCHAR2(30) SP_ID NUMBER(38) IS_PREDISCOUNTED CHAR(1) IS_BLOCKED CHAR(1) LAST_SCORE_NO_TL CHAR(1) IS_DIRECT_DEBIT CHAR(1) UNBLOCK_REASON VARCHAR2(35) UNBLOCK_FOCUS_CODE CHAR(1) UNBLOCK_DATE DATETeradata TableSQL> desc applications@teradata; Name Null? Type ----------------------------------------- -------- ---------------------------- APP_ID NOT NULL NUMBER(10) SUB_ID NUMBER(10) WARR_PLAN_ID NUMBER(10) LANGUAGE_CODE CHAR(2) DAYS NUMBER(10) CURRENCY_CODE NUMBER(10) CONTRACT_TYPE_CODE CHAR(3) AMORTIZATION_INTEREST NUMBER(9,6) LIFE_STATUS NUMBER(10) CURRENT_WQ NUMBER(10) LOCK_STATUS NUMBER(10) DAG_ID NUMBER(10) CONTRACT_NO NUMBER(10) CONTRACT_CREATED_BY NUMBER(10) ENTERED_BY NUMBER(10) LOCKED_BY NUMBER(10) CONTRACT_CREATED_DATE DATE ENTERED_DATE DATE OWNED_BY NUMBER(10) SUBFOCUS_BY NUMBER(10) SUBFOCUS_DATE DATE DEALER_ID NUMBER(10) LAST_ARCHIVED_BY NUMBER(10) LAST_ARCHIVED_DATE DATE COUNTRY_CODE CHAR(2) IVA_RATE NUMBER(10) APP_ADDRESS_GRP NUMBER(10) DISCOUNT_RATE NUMBER(9,6) APP_TYPE_ID NUMBER(10) FOCUS_BR_CODE NUMBER(10) IRR NUMBER(9,6) WARR_AMT_FINANCED CHAR(1) PRE_APPRV_AMT NUMBER(10,2) PRE_APPRV_TERM NUMBER(10) PRE_APPRV_PMT NUMBER(10,2) PRE_APPRV_EXP_DATE DATE RECALC_REQUIRED CHAR(1) CBRA_ID NUMBER(10) INTEREST_RATE_TYPE CHAR(1) CHRG_OPEN_FEE CHAR(1) GFV_AMT NUMBER(9,2) IS_MULTI CHAR(1) TRANSFER_DATE DATE IS_CONTRACT_BACKDATED CHAR(1) CONTRACT_DATE_EXPIRED CHAR(1) IS_COTIZADOR_APP CHAR(1) PURCHASE_TYPE_CODE CHAR(1) LEASE_CONTRACT_NO NUMBER(10) NON_ZERO_DAYS NUMBER(10) SUBS_VAL NUMBER(9,6) CURRENT_VERSION NUMBER(10) CHECK_VIN CHAR(1) PAYSTATUS CHAR(1) CSC CHAR(1) IS_SCORED CHAR(1) FRANCHISE_CODE VARCHAR2(30) SP_ID NUMBER(10) IS_PREDISCOUNTED CHAR(1) IS_BLOCKED CHAR(1) LAST_SCORE_NO_TL CHAR(1) IS_DIRECT_DEBIT CHAR(1) UNBLOCK_REASON CHAR(35) UNBLOCK_FOCUS_CODE CHAR(1) UNBLOCK_DATE DATEinsert statementSQL> insert into applications@teradata 2 select 3 APP_ID 4 , SUB_ID 5 , WARR_PLAN_ID 6 , LANGUAGE_CODE 7 , DAYS 8 , CURRENCY_CODE 9 , CONTRACT_TYPE_CODE 10 , AMORTIZATION_INTEREST 11 , LIFE_STATUS 12 , CURRENT_WQ 13 , LOCK_STATUS 14 , DAG_ID 15 , CONTRACT_NO 16 , CONTRACT_CREATED_BY 17 , ENTERED_BY 18 , LOCKED_BY 19 , CONTRACT_CREATED_DATE 20 , ENTERED_DATE 21 , OWNED_BY 22 , SUBFOCUS_BY 23 , SUBFOCUS_DATE 24 , DEALER_ID 25 , LAST_ARCHIVED_BY 26 , LAST_ARCHIVED_DATE 27 , COUNTRY_CODE 28 , IVA_RATE 29 , APP_ADDRESS_GRP 30 , DISCOUNT_RATE 31 , APP_TYPE_ID 32 , FOCUS_BR_CODE 33 , IRR 34 , WARR_AMT_FINANCED 35 , PRE_APPRV_AMT 36 , PRE_APPRV_TERM 37 , PRE_APPRV_PMT 38 , PRE_APPRV_EXP_DATE 39 , RECALC_REQUIRED 40 , CBRA_ID 41 , INTEREST_RATE_TYPE 42 , CHRG_OPEN_FEE 43 , GFV_AMT 44 , IS_MULTI 45 , TRANSFER_DATE 46 , IS_CONTRACT_BACKDATED 47 , CONTRACT_DATE_EXPIRED 48 , IS_COTIZADOR_APP 49 , PURCHASE_TYPE_CODE 50 , LEASE_CONTRACT_NO 51 , NON_ZERO_DAYS 52 , SUBS_VAL 53 , CURRENT_VERSION 54 , CHECK_VIN 55 , PAYSTATUS 56 , CSC 57 , IS_SCORED 58 , FRANCHISE_CODE 59 , SP_ID 60 , IS_PREDISCOUNTED 61 , IS_BLOCKED 62 , LAST_SCORE_NO_TL 63 , IS_DIRECT_DEBIT 64 , UNBLOCK_REASON 65 , UNBLOCK_FOCUS_CODE 66 , UNBLOCK_DATE 67 from applications3 68 /insert into applications@teradata*ERROR at line 1:ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Transparent gateway for TERA][NCR][ODBC Teradata Driver] Invalid date/time/timestamp value (SQL State: 00000; SQL Code: 0) ORA-02063: preceding 2 lines from TERADATA Any ideas??? I have duble checked dateformat = AAA in [DSN]

14881 views
0 replies
Transparent Gateway for Teradata on SUN Topic by ellen 23 Jan 2006

I am trying to find the Teradata Client Software to install on a Sun SOLARIS in order to use the the Transparent Gateway for Teradata with an ORACLE database. I have not had any luck finding what I need. Any help will be appreciated.

14102 views
0 replies
Why username and password need to be passed with dataSource.getConnection() Topic by prashanth777 12 Jan 2006

I have configured V5 datasources on WSAD for DB2, Oracle and Teradata. While dataSource.getConnection() with no parameters work fine with DB2 and Oracle, but not with Teradata. For Teradata, we either have to set properties for user and password on the datasource configuration or, pass them as parameters with dataSource.getConnection() method.Neither of them is an option for us as we want to use the security configured on the WSAD(those are the same user and password that we would otherwise pass with getConnection()) and we set the Component-managed authentication alias and Container-managed authentication alias to use this security setting. That should supply the username and password, why do we duplicate the samething from properties or with method call.We have a Password protection application that will update the security on WSAD datasource, no one knows what the password is. Writing to the security file on WSAD keeps it encoded. I am using "com.ncr.teradata.TeraConnectionPoolDataSource" as connection pool datasource class. Please let me know if I am missing something.

19282 views
1 reply, 14 years ago
Ole DB Connection string Topic by Sancerre 10 Jan 2006

We are (attempting) to use the Ole Db provider for .NET. I am able to connect to the database, but cannot figure out the correct way to set the default database. What is the connection string property for setting the Default Database?

26313 views
2 replies, 14 years ago
"org/ietf/jgss/GSSName" exception Topic by karina 06 Jan 2006

Hello,I’m trying to set up Teradata JDBC on my local machine and it is giving me grief. I downloaded the drivers "TTU8.0 Windows TeraJDBC.03.02.00.03" from Teradata website.It loads the drivers, but gives me a “javax.servlet.ServletException: org/ietf/jgss/GSSName” error when I try to use one of the server names for Teradata Servers in the DriverManager.getConnection() method.

13804 views
0 replies

Pages