14 Replies Latest reply: Jul 22, 2015 8:44 AM by kushal chawda RSS

    Why don't SUBSTRING work in the LOAD

    Frank Rudolf

      I was under the assumption that regular SQL scripts could be used in the load scripts, but I'm struggling with getting this LOAD script to work.

       

      It seems like when I add a SUBSTRING to the script e.g.

      LOAD *;

      SQL SELECT substring(Name,2,4)

      from database ;

       

      do I get an error saying

       

      OLEDB read failed

      SQL SELECT substring(Name,2,4)

      from database

       

      Why is that ?

       

      /Frank