2 Replies Latest reply: Oct 24, 2012 2:35 PM by Celambarasan Adhimulam RSS

    Table fields and Variables

      In the load script, is it possible to use a field in a table after it has been created? Can I use that I field and assign it to a variable using LET?

      I think this would be better presented through an example...

       

      trans:

      SELECT tr_product,

          tr_invoice,

          tr_date as "cal_date"

      FROM transactions;

       

      LET vTDate = cal_date;                 

       

      --- after this some other load stuff follows ---

       

      I hope you get my problem. If there is a solution to this, could you please show me? 

      Appreciate your help!