Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 2 cro records in one qvd but i want load this qvd for multiple times in the way
first 1cro in one table and next 1 cro in another table ? how?
May be like:
Qvd1:
First 10000000 Load * From <qvd>;
Store Qvd1 Into <>;
Drop table Qvd1;
Qvd2:
Load * From <qvd> where RecNo()>10000000;
Store Qvd2 into <>;
Drop Table Qvd2;
May be like:
Qvd1:
First 10000000 Load * From <qvd>;
Store Qvd1 Into <>;
Drop table Qvd1;
Qvd2:
Load * From <qvd> where RecNo()>10000000;
Store Qvd2 into <>;
Drop Table Qvd2;
hi
try according to this
FIRST 10000000 LOAD * from test.qvd (qvd);