Iam loading 1 qvw file by using Binary load in that i have 4 tables A,B,C and D after loading the link was formed for B,Cand D tables now i want to add new 50 records to the C table how can i do that?

[#1]

Hi can any one plz share the answer

[#2]

Hi,

If you have already records just find out the last record recno() then use

Let vMaxRecno= peek('TableC',-1,'Recno()');

Tablec:

Load *

       from C where recno()> $(vMaxRecno);

[Gysbert_Wassenaar]

Use the concatenate keyword to specify that the data from the next load statement should be added to TableC.

Concatenate(TableC)

LOAD

     ....// 50 records

FROM ...somewhere...;