7 Replies Latest reply: Apr 25, 2014 1:02 PM by Gysbert Wassenaar RSS

    Using Variables in Load Sentence

    Leonardo Lopez

      Hello Everyone, i have a problem, i want to use a variable into a load sentence.

       

      I declare my variable in this way:

       

      vProceso="31-01-2014";

       

      And I want to use it in the following sentence:

       

      LOAD

           vProceso as 'Fecha',

           Transacciones as Tran

      from

           xxxxx;

       

      Also I used $(vProceso) but I didn't get the result.

       

      The table that I will wish to get is:

       

      Fecha               Tran

      '31-01-2014'     12345

       

      Thanks for help me!!!!