2 Replies Latest reply: Apr 12, 2017 4:08 AM by Mark Van Der Berg RSS

    Comparing Incremental and Full load QVD's

    Mark Van Der Berg

      I am comparing Incrementally generated QVD's in one folder to Full load QVD's in another folder.

      The problem I have is that I can run the below evaluation script for each folder individually without issue, however running them successively creates a problem. The first script always interferes with the second one. So I run them individually and store the results which are then loaded for analysis.

       

      • How can I prevent the first evaluation affecting the second evaluation?
      • Are EXT and FILE stored as variables?

       

      //***Incremental QVD's

      //Build a list of all the Incremental Extract QVD's and their respective characteristics

       

      FOR Each EXT in 'qvd'

      FOR Each FILE in filelist ('$(vIncrementalExtractQVDLocation)'&'*.'&Ext)

      FILE:

      Load '$(FILE)' as Name,

        FileSize( '$(FILE)' ) as Size,

        FileTime( '$(FILE)' ) as FileTime,

        QvdNoOfFields( '$(FILE)' ) as NoOfFields,

        QvdNoOfRecords( '$(FILE)' )  as NoOfRecords,

        RowNo() as ID

      autogenerate 1;

      next FILE

      next EXT

       

      QUALIFY *;

      UNQUALIFY QVDName;

      I:

      load ID,

        subfield(subfield(Name,'\',-1),'.',1) as QVDName,

        Name,

        NoOfRecords,

        NoOfFields,

        Size,

        FileTime

      Resident FILE;

      UNQUALIFY *;

       

      Store I into TableList_Incremental.qvd (qvd);

      Drop Tables FILE, I;

       

      //***Full QVD's

      //Build a list of all the Full extract QVD's and their respective characteristics

      FOR Each EXT in 'qvd'

      FOR Each FILE in filelist ('$(vFullExtractQVDLocation)'&'*.'&Ext)

      FILE:

      Load '$(FILE)' as Name,

        FileSize( '$(FILE)' ) as Size,

        FileTime( '$(FILE)' ) as FileTime,

        QvdNoOfFields( '$(FILE)' ) as NoOfFields,

        QvdNoOfRecords( '$(FILE)' )  as NoOfRecords,

        RowNo() as ID

      autogenerate 1;

      next FILE

      next EXT

       

      QUALIFY *;

      UNQUALIFY QVDName;

      F:

      load ID,

        subfield(subfield(Name,'\',-1),'.',1) as QVDName,

        Name,

        NoOfRecords,

        NoOfFields,

        Size,

        FileTime

      Resident FILE;

      UNQUALIFY *;

       

      Store F into TableList_Full.qvd (qvd);

      Drop Tables FILE, F;