OREPLACE FUNCTION FAILS: FUNCTION DOES NOT EXISTS

General
yam
Teradata Employee

OREPLACE FUNCTION FAILS: FUNCTION DOES NOT EXISTS

Hi Everyone,

I'm facing a trouble when firing two oreplace quries.

Queries are as follows:

SELECT OREPLACE('TD13.1 is the current version', '13.1'); - following error : Select failed 5589 : Function OREPLACE does not exist.

SELECT OREPLACE('TD13.1 is the current version', '13.1', '14.0'); - Works fine

anyone knows the issue?

also I tried firing the first one(the one that's having an error in our DEV BOX and it wokrs fine. Both queries works fine.)

This is in our QA box. Both boxes have the same version of TD.

Any help will be greatly appreciated. :)

2 REPLIES

Re: OREPLACE FUNCTION FAILS: FUNCTION DOES NOT EXISTS

Hi

I have one table which consists of 2 columns emp_no and emp_name but in the emp_name column the emp name is stored as R.A.M.A.

I need the output to be displayed as RAMA when i select from the table.

Can anyone please let me know how can i get the same.

N/A

Re: OREPLACE FUNCTION FAILS: FUNCTION DOES NOT EXISTS

@yam:

this works fine for me, what's your release?

@reethi.s:

oTRANSLATE(emp_name, '.', '')

Dieter