Getting Started with Teradata Plug-in for Eclipse (Discontinued)

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

An excellent and detailed article
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

There was a bug in Eclipse with overloading functions that we have recently fixed. The fix will be available in our upcoming release of Teradata Plugin for Eclipse that is due out mid June.
Enthusiast

Re: Getting Started with Teradata Plug-in for Eclipse

Thanks for your reply. Is it just a problem of eclipse plugin or is it an overall problem with overloading functions as I tried to do it manually but I am getting error of Function already exists. here is how I am trying to create functions

CREATE FUNCTION myFunction("number" BIGINT, "limit" INTEGER)
RETURNS BIGINT
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(long, int) returns long';

CREATE FUNCTION myFunction("number" VARCHAR(256), "limit" INTEGER)
RETURNS VARCHAR(256)
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(String, int) returns String';

Can you please guide me what am I doing wrong?
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

You need to use a specific name (See below).

CREATE FUNCTION myFunction("number" BIGINT, "limit" INTEGER)
RETURNS BIGINT
SPECIFIC myFunction1
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(long, int) returns long';

CREATE FUNCTION myFunction("number" VARCHAR(256), "limit" INTEGER)
RETURNS VARCHAR(256)
SPECIFIC myFunction2
LANGUAGE JAVA
NO SQL
PARAMETER STYLE JAVA
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'MyJar:MyClass.myFunction(String, int) returns String';
Enthusiast

Re: Getting Started with Teradata Plug-in for Eclipse

When will OSX support be introduced?
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

We currently do no have plans to add support for OSX.

Re: Getting Started with Teradata Plug-in for Eclipse

I'm able to connect to Teradata database. But when I try to use XML services, I'm getting the error 'could not generate XSD.
com.teradata.jdbc.jdbc_4.util.JDBCException[TeraJDBC 13.10.00.20]
[Error 7504][SQLState HY000] in UDF/XSP/UDM SYSXML.GEN_QUERY_
CANONICAL_SCHEMA_U:SQLSTATE U0027: Failed to create a CLI connector'. Pls help
.
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

@borlanges: The error indicates that the UDF failed. From looking at past notes that I had on Teradata XML Services, it could be a CLI problem. In my case, the tester was using Teradata 12.0 system and had to reinstall CLIv2 version 12.0. Then restart Teradata.

Re: Getting Started with Teradata Plug-in for Eclipse

@fgrimmer ..I was able to sucessfull work till last friday..Am using XML services since 2009.Saturday we had a upgrade to 13.10 so where problem had started.

Note : I was able to query the tables sucessfully.Am not able to create XSLT using eclipse.
I was able to query the tables using SQA and not able to run few XML related procedures.Ex:
CALL Failed. 7504: in UDF/XSP/UDM SYSXML.GEN_DB_CANONICAL_SCHEMA: SQLSTATE U0027: Can't connect to db
Teradata Employee

Re: Getting Started with Teradata Plug-in for Eclipse

@borlanges Can you provide more information on which version on Teradata XML Services you are using. Which version of CLIv2? Also was it Teradata Plugin 13.10? Which version of Teradata are you connecting to? thanks.