All Forums General
deepak.tanna 8 posts Joined 01/12
16 May 2014
OREPLACE gives an error, how to confirm its available

hi 

 

I get the below error when using OREPLACE() function

SELECT OREPLACE('123-456-7890','-','')

SELECT Failed.  [3706] Syntax error: expected something between '(' and the string '1'.

This is my database version, how do i confirm OREPLACE is available, or is it part of standard installation

select * from dbc.dbcinfo;

InfoKey                  InfoData
RELEASE                  13.10.03.02
VERSION                  13.10.03.06
LANGUAGE SUPPORT MODE    Standard

thanks
deepak

Raja_KT 1246 posts Joined 07/09
16 May 2014

Use select * from dbc.functionsV  .....
As far as I remember, oreplace was not there in 13.
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

drmkd17 54 posts Joined 10/12
04 Jun 2014

Hi,
 
Do we need to install these functions?
Or they are available with TD14?
 
 
thnaks

Santanu84 122 posts Joined 04/13
11 Jun 2014

Hi
oreplace function is part of td_sysfnlib database and it comes as part of TD 14.
Thanks
Santanu

You must sign in to leave a comment.