Reload using and interval number of records

[#1]

hello,

i'm trying to import 40million records on windows server 2003 R2, but i was getting the OUT OF VIRTUAL MEMORY ERROR.

so i decided to reload each year alone using where conditions in the script and store then into qvd files then concatenate them.Unfortunately it is getting stuck somewhere and it seems because of the WHERE condition.

So i was thinking if there's any way to use something like the FIRST (1000000) Load *.... ,so i need to tell the script to reload for me records between for example 1million records and 2million records.means i want to begin loading on the 1million record.

can this be done????

[its_anandrjs]

Hi,

Yes it is right way to load certain records from all records and do analysis on that but if you load data yearly basis it is also correct but why you gettting error please check it.

If you want to load sertain records use script like

Load

...

...

From Data

Where Recno( ) <= 1000000;

Some thing like this in your code

Regards,

Anand

[#3]

I tried it and it works,but the probem is that when i reload the number of records i need the reload doesn't stop as if it is going through all the other next records that i don't need before it stops.

is there any way to stop it when i reach the desired number of records???