Pages
![]() |
Hi, I am trying to create my first function in Teradata SQL Assistant using a script I found on the internet. the purpose of the function is to convert a timestamp to a unix timestamp and is as follows;
30 Jun 2016
| 1 comment
,
|
![]() |
Hello, Executed as Single statement. Failed [7509 : HY000] Result Exceeded maximum length for UDF/XSP/UDM pm_edw_etl_load.oreplace2. Elapsed time = 00:00:00.437 STATEMENT 1: SEL failed.
29 Jun 2016
| 1 comment
,
|
![]() |
Is there a database where we can create user defined functions so that it is not necessary to qualify them with the databasename when we use them. The UDFs that have been created by the Teradata installation are all in the TD_SYSFNLIB database, and don't need to be prefixed with the databasename.
29 Mar 2016
| 3 comments
,
|
![]() |
Teradata Debugger for C/C++ UDF Eclipse Plug-in Release 15.10.01 has been released and is available in the Teradata Developer Exchange download section at Teradata Debugger for C/C++ UDF .
29 Jan 2016
| 2 comments
,
|
![]() |
The Teradata Debugger for C/C++ UDF (CUDB) Eclipse Plug-in provides a Graphical User Interface for CUDB on the Eclipse IDE.
24 Jan 2016
,
|
![]() |
|
![]() |
I can't find a library listing of INMODs or UDFs anywhere on here.
04 Jun 2015
| 2 comments
,
|
![]() |
BackgroundThis article is a follow on to article [1] which discussed implementing K-means using a Teradata release 14.10 table operator. The main contribution of this article is to discuss how to use the new Teradata 15.0 multiple input stream feature and a short discussion on a gcc compiler performance optimization.
25 Jan 2015
,
|
![]() |
Hi,
26 Oct 2014
| 11 comments
,
|
![]() |
Hi,
24 Sep 2014
| 2 comments
,
|
![]() |
Hi,
11 Sep 2014
| 4 comments
,
|
![]() |
Hi experts
05 Sep 2014
| 1 comment
,
|
![]() |
How does TASM enforce rules such as classification and workload exceptions against User Defined Functions? What about table functions and table operators, some of which do their work outside of Teradata? How far can you rely on TASM classifications using estimated processing time in these cases? Will there be accurate resource usage numbers reported to support workload exceptions on CPU or I/O? These are some of the questions that need answering if you are extending the use of simple or more complex user-defined functions on your platform.
31 Jul 2014
| 7 comments
,
|
![]() |
1)There are certain UDFs cretaed in my Prod Teradata system.I am trying to grant "EXECUTE FUNCTION" on the UDFs to users.
17 Jul 2014
| 6 comments
,
|
![]() |
Hi there,
24 Apr 2014
| 3 comments
,
|
![]() |
I have a java udf that basically just does a bunch of shows on each and every procedure and macro and then inserts those into a table. The jar is installed and my definition for the procedure is below. The problem i'm getting is i keep getting the error:
17 Apr 2014
| 3 comments
,
|
![]() |
Hi Guys,
19 Mar 2014
,
|
![]() |
While compiling UDF in Teradata, We place the .c program of the function in a folder and compile the function structure in Teradata specifying the file path in the EXTERNAL NAME part.
16 Feb 2014
| 4 comments
,
|
![]() |
Hi
20 Jan 2014
,
|
![]() |
Hi all,
27 Dec 2013
| 6 comments
,
|
![]() |
User-Defined Functions
This feature was introduced in Teradata Database V2R5.1.
10 Dec 2013
,
|
![]() |
We need to make UDP connections from Java UDF functions to run some external processing. This processing is multithreaded and we can serve up to 100 concurrent requests.
14 Oct 2013
| 7 comments
,
|
![]() |
Hi,
17 Jul 2013
| 2 comments
,
|
![]() |
I need to store the value in the DataParcel column(which is of VARBYTE datatype) in the first error table of FASTLOAD into a permanent teradata table but with a proper format(The ddl of this table will be exactly the same as the target table, except that all datatypes are varchar)
04 May 2013
| 1 comment
,
|
![]() |
We have a basic (test) ALC UDF (actually it is just a dummy), and it works.
20 Feb 2013
| 3 comments
,
|
![]() |
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.
14 Jan 2013
,
|
![]() |
Customers are currently leveraging Teradata's features such as User Defined Functions (UDFs) and External Stored Procedures (XSPs) to develop complex applications. The aim of this set articles is to show the user how to use the Eclipse IDE to debug in a single-node, controlled, non-production environment:
The audience for this set of articles ranges from Teradata associates within the R&D and Professional Services organizations to Teradata Customer and Partner developers who want to debug a UDF/XSP running on their DBS VM before installing it on a production system.
26 Dec 2012
,
|
![]() |
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.
26 Dec 2012
,
|
![]() |
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.
26 Dec 2012
| 2 comments
,
|
![]() |
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.
26 Dec 2012
,
|
![]() |
Hi, I'm looking for an external UDF that will emulate the strtok function in C. I'm aware that it is available as an internal function on TD14, but our client is running 13.10. I am using it in a recursive query to denormalize a view, so i need a scalar UDF that will return a single value result. Thanks!
05 Nov 2012
,
|
![]() |
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.
25 Oct 2012
,
|
![]() |
Hi,
27 Sep 2012
,
|
![]() |
It is the Big Data era. But we do not have enough "big applications". This tool - 'Common UDF' - provides a code builder for both Teradata table UDF and Hadoop Pipes UDF based on the same core code. In this way, we can implement applications for both Teradata and Hadoop with the same code.
This topic will be disucssed at Teradata PARTNERS 2012, Session ID 1987 - Common UDF cross Hadoop and Teradata – One Software for Two Platforms. Please join us at this session to learn more.
11 Sep 2012
,
|
![]() |
How to do casting in Userdefined function?
10 Jul 2012
| 3 comments
,
|
![]() |
Hi, We are developing some user defined functions (aggregates, window aggregates) and table functions in TD 12.0. We tried to use the example from the "SQL External Routine Programming" book. Unfortunately, the releasea listed on this book is 13.10.
27 Apr 2012
| 2 comments
,
|
![]() |
Hello, Are there any doc's which discuss SQL UDF's? (Especially the various qualifiers in the CREATE FUNCTION statement). I am trying to determine why my regular SQL works as expected, but when you put the same code into an SQL UDF, it returns unexpected results. Any insight would be greatly appreciated.
14 Feb 2012
| 2 comments
,
|
![]() |
|
![]() |
So you are testing or developing in a Teradata Express 13 or a general Teradata environment and you are anxious to integrate your Java code into your Teradata DB using Java UDF extensibility...just to find yourself in an errors-headache with things like: - 7583 The secure mode processes had a set up error
23 Jan 2012
| 3 comments
,
|
![]() |
As I qualified in a previous post, I'm a Teradata newbie (migrating from Oracle). Just started writing UDF's. I see the following Warning in the UDF Programming manual and wanted to understand this in more detail. There are also some additional comments in the same doc section referring to core dumps, and where they are stored.
12 Dec 2011
,
|
![]() |
hello ,i write a AGGREGATE udf and compile it to database,but report error when execute it : Teradata Database] [TeraJDBC 13.00.00.02] [Error 7502] [SQLState HY000] A system trap was caused by UDF/XSP/UDM FW.group_concat for SIGSEGV does someone can help me ? Thanks! this is my code:
08 Sep 2011
,
|
![]() |
Hi, I'm working on creating my UDF for Teradata. Before deploying my UDF, I would like to check whether a UDF with the same name exists or not in Teradata. In which table/view does Teradata keep UDF descriptions? It seems Teradata store UDF list for each database. Is there a way to create a UDF that shared among all databases?
21 Jul 2011
| 2 comments
,
|
![]() |
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.
27 Jun 2011
,
|
![]() |
Hello, I am trying to use the Oracle UDFs provided by teradata in my TPT script. The problem I am facing is with the use of single quotes " ' " inside my insert part of my apply. since the INSERT statement within the APPLY has to be contained within " ' "(single quotes) I cannot use the "nvl" udf that requires the replacement string to be in " ' ". Example: 'Insert into table1 values ( nvl(:column, 'replacement string'));' If anyone knows the escape character that may be used to escape the " ' " enclosing the "replacement string" then please help me.
20 Jun 2011
| 2 comments
,
|
![]() |
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.
09 May 2011
,
|
![]() |
Hello. Anyone ever tried to run FULL PUSHDOWN on informatica 8.6.1 with UDFs? I'm thinking about implementing of historization of data in C ;) Thanks,
31 Mar 2011
,
|
![]() |
I've created four UDFs to handle data transformation from MAINFRAME source files. Originally the data type for all UDFs was to be fixed as VARCHAR, however after careful investigation of source data by one of my colleagues, two of the functions needed to be overloaded to accept both VARCHAR and VARBYTE, and the remaining two UDFs required both VARCHAR and DECIMAL. I'm running a DROP statement for all UDFs before running a REPLACE FUNCTION statement, however I encounter the following problem (extract from log file; have used <**> to mask database name):
07 Mar 2011
| 2 comments
,
|
![]() |
One of the biggest benefits of Query Banding is the ability to pass parameters into an SQL script. Establishing an associative security table lookup between a userid and allowable company codes may allow easy access to the base data tables.
05 Jan 2011
| 4 comments
,
|
![]() |
Is there an equivalent to user defined function (MS SQL) in teradata where I can write SQL that returns either a scaler or table which I can further use in a query. For example: SELECT sclfunctionName(param1, param2) OR SELECT * from tblfunctionName(param1, param2) Both sclfunctionName and tblfunctionName contain some SQL. I have tried it using a MACRO but don't know how I can use it in SELECT CREATE MACRO tstMacro (param1 VARCHAR(10)) like
07 Dec 2010
| 4 comments
,
|
![]() |
Hi all, Hope all is well. I wanted to know if we can pass each row of the syslib.MonitorSession(-1,'*',0) resultset to syslib.MonitorSQLCurrentStep so that I can get each session and its number of steps and its current active step.
28 Sep 2010
| 1 comment
,
|