Welcome! Teradata Developer Exchange is a community-oriented website that connects Teradata Associates with Customers and others interested in the related technologies. Think of it as a technical collaborative community for sharing ideas, asking questions, learning, and solving problems related to Teradata solutions and beyond. Sounds great doesn't it? So sign up and join the community now!

Expand All Subscribe to Teradata Developer Exchange - All content The Latest
How to Create and Debug a Scalar CUDF using Eclipse

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the C/C++ programming languages, installing them on the database, and then using them like standard SQL functions.

Teradata Database supports three types of CUDFs (C/C++ User-Defined Functions). They are scalar UDF, aggregate UDF and window aggregate UDF, and table UDF. 

How to Create and Debug a Java XSP using Eclipse

In addition to stored procedures, which use SQL control and condition-handling statements, input and output parameters, and local variables to provide applications with a server-based, precompiled procedural interface, Teradata Database supports external stored procedures.

You can write external stored procedures in the Java programming language, install them on the database, and then use the SQL CALL statement to call them like other stored procedures. JXSP (Java eXternal Stored Procedures) can use JDBC to directly execute SQL statements.

How to Create and Debug a Table JUDF using Eclipse

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming languages, installing them on the database, and then using them like standard SQL functions.

Teradata Database supports three types of Java UDFs. They are scalar UDF, aggregate UDF, and table UDF. 

How to Create and Debug an Aggregate JUDF using Eclipse

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming language, installing them on the database, and then using them like standard SQL functions.

Teradata Database supports three types of Java UDFs. They are scalar UDF, aggregate UDF, and table UDF. 

How to Create and Debug a Scalar JUDF using Eclipse

SQL provides a set of useful functions, but they might not satisfy all of the particular requirements you have to process your data.

User-defined functions (UDFs) allow you to extend SQL by writing your own functions in the Java programming language, installing them on the database, and then using them like standard SQL functions.

Teradata Database supports three types of Java UDFs. They are scalar UDF, aggregate UDF, and table UDF. 

Speed up Large Object (LOB) retrieval with CommandBehavior.SequentialAccess

Teradata Database supports Inline and Deferred Large Object Retrieval modes. The LOB retrieval modes control the content of rows and accessibility of LOB columns. 

Using SQL Assistant to compose a report or email

 

This article will describe a few simple features of Teradata SQL Assistant that can help you to create an eye-catching report or email.

Hitchhikers' Guide to using Excel with Teradata

It is believed that the computer called Deep Thought in the famous Douglas Adams' novel, “The Hitchhiker’s Guide to the Galaxy,” used Excel in the last step of figuring out the meaning of life. It is too bad Deep Thought couldn’t access the data in Teradata Database and let Teradata do the analytics because it would've figured out the meaning of life much sooner.

Throttlepedia: A Detailed Look at Teradata Concurrency Control

Throttles are the most popular Teradata workload management option today. This webinar provides a simple yet thorough explanation of how these concurrency control rules actually work, reviewing the basics as well as focusing on important enhancements in the Teradata 13.10 and 14.0 releases.

Preserving Data Integrity when TPT Export to Stream Job Restarts

This article describes how to preserve data integrity when a Teradata Parallel Transporter (Teradata PT) export to stream job restarts.

Pages