I am connected to a remote SQL server through the connection called Myconnection. Using this remote connection I have created a remote view to access all the records from one table in SQL server(_4_claim_temp_header. Now when I transfer the data from the remote view called 'rv__4_claim_temp_header' to a local table called _4_claim_temp_header, it transfers only part of total data from remote view. I'm using the following code to do that.

close databases
open database pinnapp
use rv__4_CLAIM_TEMP_HEADER

SCAN
SCATTER MEMVAR
INSERT INTO _4_CLAIM_TEMP_HEADER FROM MEMVAR
ENDSCAN

there is more than 13000 records in the remote table but I can see only 944 records in the Local Table. Any help

Thanks
Bharat