3 Replies Latest reply: Jul 5, 2018 3:24 AM by Bala Bhaskar RSS

    Storing qvd in next month name

    Joshua Solomon

      Dear all,

       

      I am using the below to store my qvd in current month name but i want to store the current month qvd in next month name.

       

      LOAD LOAN_AC_NO,

      NAME,

      EMI_AMOUNT,

      OVERDUE,

      Month(LASTPROCESSDATE)&'_'&Year(LASTPROCESSDATE) as ReportingMonthYr

      LASTPROCESSDATE;

       

       

      [ODREPORT]:

      SELECT "LOAN_AC_NO",

      "NAME",

      "EMI_AMOUNT",

      "OVERDUE",

      "LASTPROCESSDATE"

      FROM "INT_USR"."ODREPORT";

       

       

      MonthYear:

      LOAD

      ReportingMonthYr as MonthYear

      Resident [ODREPORT];

       

       

      LET vYearmonthstoreBounce = Peek('MonthYear');

       

       

      STORE [ODREPORT] INTO [lib://TestQVDPATH /ODREPORT_Live_$(vYearmonthstoreBounce).QVD] (qvd);

       

      Drop table [ODREPORT];

      Drop table MonthYear;