2 Replies Latest reply: Jun 25, 2013 1:45 PM by Roel Sable RSS

    Setting the Maximum value of a field in the script

      Hi everyone!

       

      In the LOAD script, I have this...

       

      ---------------------------------------------------------------------

      transactions:

       

      transID,

      transNo,

      transCalendarDate,

      transFiscalDate;

       

      SQL SELECT

           trn_uid,

           trn_no,

           trn_calendarDate,

           trn_fiscalDate

      FROM transact;

      ---------------------------------------------------------------------

       

      Now, after loading everything to "transactions", what I wanted to do through script is to:

      1. assign the maximum transCalendarDate to a variable vMaxCal

      2. assign the maximum transFiscalDate to a variable vMaxFiscal

       

       

      Advance thank you for all of your replies!