0 Replies Latest reply on Dec 7, 2017 4:27 AM by Sarunas Svegzda

    INSTR function and PDO for Teradata

    Sarunas Svegzda New Member



      I have a INSTR function to find 2nd or 3rd occurrence of a defined string.


      INSTR('My String','a',3)


      Full push down optimization is enabled and i get an error:


      expression [INSTR] with [3] parameters cannot be pushed to the database.


      Is INSTR function with optional parameters supported?


      If I use default INSTR function without any optional parameters push down works. INSTR('My String','a')


      Informatica v10.2
      Teradata v15.10