grep utility in shell script

I'm trying to overcome a limitation on our file structure. I want to grep a whole series of files in a known location. If I do a standard grep fro开发者_运维百科m command line

(grep -i searchpattern known_dir/s*.sql) 

I get the following error:

ksh: /usr/bin/grep: 0403-027 The parameter list is too long.

so I have a little for loop that looks like:

searchfor=$1
for i in /$ENV_VAR_DIR/s*.sql
do
  grep -i $searchfor $i
done

When I execute this I get a couple problems:

1. it gives me the line of code but no file name I need both
2. -l obviously gives me just the path/filename I want to trim the path off I am just executing from my home directory.

I would recommend the following:

$ find known_dir -name 's*.sql' -print0 | xargs -0 grep -i searchpattern

With xargs, you can vary the maximum number of files you pass to grep each time using the -n option.

The -print0 and -0 options is a defense against spaces in filenames.

You could even compute multiple grep commands in parallel on multiple cores using -P option.

As a hack you could also specify /dev/null to your grep command to get -l to list a file, however your method is going to be slow as it uses shell looping and starts a grep process per file. find and xargs are your friend here as already mentioned.

Perhaps you could use the findrepo script which seems to do as you require.

ls | read fname; do
    grep searchpattern $fname /dev/null
done

This does two things for you.

1. You don't need to expand all the files at once, it processes them one at a time.
2. By listing /dev/null as a second file it won't match anything but it will get grep to print the filename. Gnu grep has an option to force filename output but this will work on any unix.

The other traditional thing to do with this shell design pattern is to feed the loop with find.

find . -name "*.sql" | read fname; do
    grep searchpattern $fname /dev/null
done

You might also wants to make searchpattern be $1.

find ./known_dir/ -name "s*.sql"|xargs grep -i searchpattern

grep -H will force the filename to be prepended to each output line, the same as it would be if you were doing the original single command.

The easiest way to get just the filename, whether from -H or -l, is to have the directory be your current working directory when you run the command:

searchfor=$1
cd /$ENV_VAR_DIR
for i in s*.sql
do
  grep -Hi $searchfor $i
done

You want either ack or grin.

easy_install grin    
grin -I "*.sql" searchpattern

To only show file name

grin -I "*.sql" -l searchpattern