LOAD with SQL SELECT fails

[#1]

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.

[MayilVahanan]

HI

     Try like this,

Movim: 

LOAD

    FE_MOV,

    VOUCHER,

    CG_ASIEN,

     .

     .

     . 

    CAE_PRODUCCION,

    CAE_TESTING,

    MONEDA3;

SQL SELECT *

FROM dbo_Movim;

Then reload it , and see the result..

Store Movim into Testing.qvd(qvd);

[nagaiank]

Try the following:

QUALIFY *;

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

[#4]

It still does not work.

When the script is the next, I get the table but unqualified:

**************************************************************************

QUALIFY *;

Movim: 

LOAD

    FE_MOV,

    VOUCHER,

    CG_ASIEN,

     .

     .

     . 

    CAE_PRODUCCION,

    CAE_TESTING,

    MONEDA3;

SQL SELECT *

FROM dbo_Movim;

**************************************************************************

And if I add the STORE clause (STORE Movim into $(QvdPath)Movim.qvd (qvd);), the script doesn not run.

[#5]

First  all field names in load statement should  be  upper , and then  check if any field is repeating.in second case there is a chance to reload fail.

[#6 · Accepted solution]

Problem solved, was missing a comma after the definition of QvdPath

Thank you all.