>Nick,
>just simply want to merge new data into existing table. When new data is moved in..a temp table is created(same format) and I need to add this new information to the end of the existing table.... This is the code I've been trying to make work.
>
>INSERT INTO cfile(Orig_lata, Term_lata, Bill_dur);
> VALUE (temp.Orig_lata, temp.Term_lata,temp.Bill_dur)
>appreciate any advise you have...thanks
>Kelly

Then it should work. Do you SCAN... ENDSCAN through the temp table? You also can try SCATTER MEMVAR and INSERT INTO temp FROM MEMVAR