![]() |
I have a database table which has four columns and two of the columns are INT. The two INT columns' rows are sometimes empty.
14 Jul 2016
| 4 comments
,
|
![]() |
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
,
|
![]() |
If I type median in a Teradata query, the word becomes blue, but it does not become bold and blue.
20 May 2015
| 4 comments
,
|
![]() |
Hi,
11 Mar 2015
| 2 comments
,
|
![]() |
I've created a Java Function and imported it in TeraData
04 Feb 2015
,
|
![]() |
Hi,
28 Dec 2014
| 3 comments
,
|
![]() |
Hi,
26 Oct 2014
| 11 comments
,
|
![]() |
Hi Guys,
19 Mar 2014
,
|
![]() |
Hi,
23 Jan 2014
| 2 comments
,
|
![]() |
User-Defined Functions
This feature was introduced in Teradata Database V2R5.1.
10 Dec 2013
,
|
![]() |
Hi All,
03 May 2013
| 2 comments
,
|
![]() |
Hi. I am trying the built-in C functions for ARRAY handling in Teradata 14. Basically, I copied the code below from the FNC_GetArrayElementCount function in the manual TD 14 External Routine Programming:
17 Apr 2013
| 1 comment
,
|
![]() |
Hi,
21 Nov 2012
| 1 comment
,
|
![]() |
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
,
|
![]() |
Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has?
26 Sep 2012
| 2 comments
,
|
![]() |
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad). The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer. This article details the different modes in which Named pipes are opened and used by NPAM for data transfer activity.
25 Apr 2012
,
|
![]() |
What is the difference between FUNCTION and SPECIFIC FUNCTION? When do I use SHOW FUNCTION versus SHOW SPECIFIC FUNCTION? Or HELP FUNCTION versus HELP SPECIFIC FUNCTION? Thanks, Denmark
02 Mar 2012
| 1 comment
,
|
![]() |
I want to remove leading and trailing tabs in a column... I tried trim function and its not working... is there any other means we can remove the leading or trailing tabs...
08 Jan 2012
| 5 comments
,
|
![]() |
Hi I have a select satatement in stored procedure, Inthe where condition, i have b.dt2_month_end =( DATE :THIS_END_DATE - EXTRACT(DAY FROM :THIS_END_DATE))--------statement A if i give hard coded values like
12 Apr 2011
| 4 comments
,
|
![]() |
I need to rollup and report data by week, with the week being defined as Sun through Saturday and identified as the Saturday-date. Does Teradata SQL have any functions that could facilitate this?
22 Mar 2010
| 9 comments
,
|