how to limit record load from qvd file

[gerrycastellino]

I have a simple load statement that is loading records from a ".qvd" file that has millions of records.

How do I limit my record load to say 1000 records.

Gerry

[JonnyPoole]

Use the First command:

First 1000

Load

     *

from <QVD file>;

[its_anandrjs]

Hi,

Then try to load like

Load * From a.qvd where

RowNo() <= 1000;  //This loads only 1000 records

Regards

Anand