Teradata 14 and REGEXP_INSTR

Database
Enthusiast

Teradata 14 and REGEXP_INSTR

Hi,

I am trying to call for REGEXP_INSTR , but despite being on :

InfoKey,InfoData

RELEASE,14.00.04.08

LANGUAGE SUPPORT MODE,Standard

VERSION,14.00.04.07

I am getting 5589 error telling that REGEXP_INSTR function does not exist?

fyi, REGEXP_SUBSTR is calle without trouble.

Any help or explanation?

2 REPLIES
Enthusiast

Re: Teradata 14 and REGEXP_INSTR

ok, interesting REGEXP_INSTR to work can only take two params like:

regexp_instr(tekst,'\.([[:alpha:]]){0,}$')

when you give

regexp_instr(tekst,'\.([[:alpha:]]){0,}$',1,1) it returns error that function doesnt exist

thou documentation says otherwise

Regards,

Piotr

Junior Contributor

Re: Teradata 14 and REGEXP_INSTR

Hi Piotr,

you can use only two or all six params.

Dieter