- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- The table is not named as "Movim" (so when I use STORE, use "from dbo_Movim")
- Unrecognized statement 'Qualify': it doesn´t work.
- Can´t STORE the table into qvd format.
If I remove the STORE statement then load the table but unqualified.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Problem solved, was missing a comma after the definition of QvdPath
Thank you all.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);
Please close the thread by marking correct answer & give likes if you like the post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Problem solved, was missing a comma after the definition of QvdPath
Thank you all.