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

    INSTR function and PDO for Teradata

    Sarunas Svegzda New Member

      Hello,

       

      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