5 Replies Latest reply: Apr 1, 2016 5:37 AM by Purushotham M RSS

    resident and store into QVD statement

      Hi, I have 2 tables and the script is as such:

      table1:

      load *

      from [filepath]

      ((txt, codepage is 1252, embedded labels, delimiter is '|', msq);

      store table1 into table1.QVD;

      drop table table1;

       

      table2:

      load*

      resident table1 order by variablename desc;

      store table2 into table2.QVD;

      drop table table2;

       

       

      How can I store table2 as QVD also? I have error stating table1 not found when the program runs 'resident table1 order by variablename desc;'

       

      Thanks.