3 Replies Latest reply: Jun 10, 2014 11:06 AM by Michael Gardner RSS

    Trace # of New Rows added to Table in Load

    Michael Gardner

      I have a script that loads only new records from a Source table into a QVD.  I want to be able to state the # of new rows that are being loaded in a Trace Statement.  See below for an example.

       

       

      Sales:
      Load ID,*

      From QVD;

       

      TRACE New Rows being loaded;

       

      CONCATENATE (Sales)

      Sales:

      Load ID,*

      From Source

      WHERE NOT EXIST ID;

       

      TRACE "x" rows loaded into Sales;