I have a database table which has four columns and two of the columns are INT. The two INT columns' rows are sometimes empty. When I try to cast them as DECIMAL(18,3) and then use the Median function I am getting the Error: An unknown character string translation was requested.  

Hello,   I have a query using OREPLACE that runs in one environment, but fails in another with:   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.  

If I type median in a Teradata query, the word becomes blue, but it does not become bold and blue. So, I suspect what's going on is that median is not, in fact, a function in Teradata, but the word is reserved and cannot, for example, be assigned to a user written function. Is this correct?

Hi,   The following SQL function works:  REPLACE FUNCTION dl_stg.mmtest ( a VARCHAR(1) , b INT , C INT )RETURNS INTLANGUAGE SQL CONTAINS SQLDETERMINISTIC

I've created a Java Function and imported it in TeraData But after few thousand executions, the function becomes too slow. You can find below output from TOP command. USER       PR   NI VIRT    RES  SHR  S %CPU %MEM    TIME+     COMMAND tdatuser  23   8  815m  33m 1976 S  200   1.4          1835:21  udfsectsk  

Hi,   I'm trying to do something like below, but its giving me syntax error, can anyone please tell me what is the issue and how to fix this.   with cte0(ID,int_col1) as(     select row_number() over (order by (select 1)) AS ID,int_col1 from shuffletest ) update cte0 set int_col1=ID;  

Hi, I want to write SQL UDF with Multiple Lines: 1. Declare variables. 2. Set those variables with select into statement. 3. some if conditions on Variables 4. return some value.   What is the syntax to write this. I'm using teradata Version 14.00.03.02.   Parth

Hi Guys,   I need to create a function that reads its result from a table, so I need to use a SELECT statement to read the output. Something like that:

Hi, I have the following data; Account_id   Date           Flag_1 123             012006        ? 123             022006        1 234             012007        1 234             022007        1