Shell Programming and Scripting

Hi friends,

I have written script that will search & display the block of sql statement. Since there are many blocks of sql statement i am finding it difficult to distinguish between them. The below is the sed command & its result

exec sql
abc
abc
abc
aaaaaa;
exec sql
abc
abc
abc
aaaaaa;
eeeeeeeeeee
eeeeeeeeeee
exec sql
abc
abc
abc
aaaaaa;

using "exec sql" as begining & ";" as ending

sed -n "/exec sql/,/;/p" $srcCode


Result will be

exec sql
abc
abc
abc
aaaaaa;
exec sql
abc
abc
abc
aaaaaa;
exec sql
abc
abc
abc
aaaaaa;

I would like the result displayed as

exec sql
abc
abc
abc
aaaaaa;
---------------------
exec sql
abc
abc
abc
aaaaaa;
---------------------
exec sql
abc
abc
abc
aaaaaa;
---------------------

Kindly help me with this situation. Thanks.

Code:

sed '/;$/a\---------------------' infile

Edit:
I just realize that I answered a bit fast. Your sed statement gives and error when I use it. On your second output all lines with those multiple "e"s are gone.
From your description I didn't even see that you wanted to remove those lines.
If the statement above isn't what you want, best just print simple input and output.

In that case you can try this:

Code:

awk '/exec/{p=1}/;$/{;print;print "-----------";p=0}p' file

Regards