topic Re: FILE comparison option in Application Development and Automation Discussions

FILE comparison option

Former Member — Thu, 03 Jul 2008 04:53:51 GMT

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

Re: FILE comparison option

Former Member — Thu, 03 Jul 2008 05:19:52 GMT

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