Shell Programming and Scripting

I want to check the files if the below pattern is there or not. I have to scan thousands of files.

It should start search with "Group" (Case insensitive) and followed by first semicolon ";" . In between these two there should be "partition"(case insensitive).

File1.txt
a)

Code:

update benchmark_app.dropme4
from
(sel a.empid from
benchmark_app.dropme3 a
GROUP by 1
QUALIFY row_number() over (partition by a.empid order by a.managername desc) = 1) c
set empid4 = c.empid
where 
benchmark_app.dropme4.empid4 = c.empid
;

sel
 group by;

sel
partition 
;

b) file2.txt

Code:

sel
 group by;

sel
partition 
;

I should not get any output from file2.txt because my pattern is not there in between start and ending search criteria.

I am using the following command, but it is not giving me the expected output.

Code:

awk '/[Gg][Rr][Oo][Uu][Pp]/ {s=x} {s=s$0"\n"} /[Pp][Aa][Rr][Tt][Ii][Tt][Ii][Oo][Nn]/ {p=1} /;/ && p {print s;s=x;p=0}' file2.txt

What would data that does match look like?

---------- Post updated at 02:29 PM ---------- Previous update was at 02:26 PM ----------

I'd take a different approach. Use a record separator of ";" and a field separator of "\n" so you get a code block every loop. Then use a for-loop to look for GROUP and PARTITION in the lines. If you find GROUP and PARTITION in a row with nothing after, you know you got GROUP, PARTITION, and semicolon.