Extensibility covers the mechanisms by which you, as the user or developer, can extend the functionality of the Teradata Database, for example with the use of User Defined Functions, or UDFs.

Expand All Subscribe to Teradata Developer Exchange - Extensibility 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. 

How to Set up a UDF / XSP Debugging Environment

An integrated development environment is crucial to software developers for editing, building and debugging their program all within one environment. Therefore, setting up the right development environment is an important first task.

Here we set up a User-defined Functions (UDFs) / External Stored Procedures (XSPs) debugging environment used to debug typical UDF/XSPs. Eclipse Indigo is used as the IDE. A Teradata Express (TDExpress) VM is used as the running DBS.

Block Level Compression Evaluation Utility

Teradata 13.10 features Block Level Compression (BLC), which provides the capability to perform compression on whole data blocks at the file system level before the data blocks are actually written to storage. Like any compression features, BLC helps save space and reduce I/O.

This BLC utility is for Teradata users to run against TD 13.10 system to select the list of BLC candidate tables and evaluate BLC impact on space and speed for each specific table in interest, to get information for selecting appropriate tables to apply BLC.

Putting Teradata Geospatial on the Map

Since Teradata first introduced native Geospatial capabilities in the database there have been inquiries about how to interoperate with the spatial data via client GIS and visualization tools.  In this article we are going to discuss how to view and edit spatial features and attributes maintained within Teradata in real-time by using the GeoServer web services.

Picture This - Teradata and Digital Image Processing

As most of you might agree, managing our collections of digitial pictures is becoming quite a challenge.  The number of photos continues to increase and now includes pictures from cameras as well as multiple mobile devices.  And to add to my troubles, I find that I have duplicate copies in different folders and on different computers.  Getting this organized is becoming a high priority.  Sure there are management solutions already available, but hey, we're tech people and it's more fun to try to build our own!  With the free Teradata Express database and some java coding, we have the right tools to get started.

Teradata 13.10 SQL Language Functions and User Defined Ordered Analytic Functions

Teradata 13.10 continues the strategy of delivering features that enable extending the Enterprise Data Warehouse functionality. SQL Language User Defined Function (UDFs) allows function to be implemented in SQL which is a natural fit for SQL writers. This session describes the feature and use cases. It also describes other enhancements in Teradata13.10 which includes User Defined Ordered Analytic Functions and new system functions for BIT, string and numeric processing.

Pages