hi all
i have two files in unix
1.table.name
2.all.tables
i need to check the availability of all data of table.name in all.tables.both the table contains n number of data.i need a script which will check one by one whether the data exist in table.name or not.I want this in SH.
While an excerpt of your files posted inside code tags would have helped a bit more, here a guess:
grep -f table.name all.tables
It will print out all matches from 1st file against the 2nd file. If the output has the same number of lines like the 1st file, all lines were found inside the 2nd file. You can check the number of lines of a file with
grep -f table.name all.tables| wc -l
# and
wc -l < table.name