5 Replies Latest reply: Jul 27, 2012 10:27 AM by Marcos Ford RSS

    LOAD with SQL SELECT fails

      I have several problems when I load a table.

       

      The script is this:

       

      QUALIFY*;
      
      Movim:  
      LOAD
          FE_MOV,
          VOUCHER,
          CG_ASIEN,
           .
           .
           .  
          CAE_PRODUCCION,
          CAE_TESTING,
          MONEDA3;
      SQL SELECT * 
      FROM dbo_Movim;
      STORE * from dbo_Movim into $(QvdPath)Movim.qvd (qvd);
      
      

       

      Problems:

       

      1. The table is not named as "Movim" (so when I use STORE, use "from dbo_Movim")

      2. Unrecognized statement 'Qualify': it doesn´t work.

      3. Can´t STORE the table into qvd format.

       

      If I remove the STORE statement then load the table but unqualified.