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

    Issue calling stored procedure in IF ELSE statement

    Matthew Brenner

      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 *;

        SQL EXECUTE EV_TEST;

      else

        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:

      else


      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.