Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

FILE comparison option

Former Member

‎2008 Jul 03 5:53 AM

0 Likes
404

Hi all,

There is 2 files in application server. One contains more than 8000 records and other contains less records compared to the other.Both files are having same type and these files have to be compared based on 7 fields. And unmatched records have to be stored. Since the number of records in the files are more, comparing record by record will comsumes more time. Is there any other alternative for the file comparison other than read frm application server and taking to internal table and comparing 7 fields record by record?

Plz help

Hi all,

There is 2 files in application server. One contains more than 8000 records and other contains less records compared to the other.Both files are having same type and these files have to be compared based on 7 fields. And unmatched records have to be stored. Since the number of records in the files are more, comparing record by record will comsumes more time. Is there any other alternative for the file comparison other than read frm application server and taking to internal table and comparing 7 fields record by record?

Plz help

Reply
1 REPLY 1
Read only

Former Member

‎2008 Jul 03 6:19 AM

0 Likes
379

Hi Anu,

Try to use FOR ALL ENTRIES IN to fetch a record.

Ex:

SELECT xx

FROM t1

FOR ALL ENTRIES IN t2

INTO itab

WHERE x1 ne x2.

Where xx is the field of the record, t1 is the 1st table and t2 is the 2nd table which is to be compared with t1. itab cointains the resultant record.

Regards,

Sowmya