7 Replies Latest reply: Mar 10, 2016 8:29 AM by Gysbert Wassenaar RSS

    Issue calling stored procedure in IF ELSE statement

      Hello everyone,

      I'm working on our load script and I'm running into a problem. We're implementing incremental load and I've got to call a stored procedure in SQL, but I'm having problems putting the call into an IF ELSE. Here's the code


      if $(FirstReload) = true then

        LOAD *;



        LOAD *;

        SQL EXECUTE EV_TEST '$(vExecTime)';

      end if


      So what I'm seeing is when I run this:


      The following error occurred:

      Script line error:

      The error occurred here:


      So I'm not sure if I'm doing something incorrectly with my call to load the stored procedure, or if I have some syntax wrong with my IF ELSE.