I am having a file like below , which has many SQL statements. I want to read a particular block of SQL whenever needed.
MyFile.SQL
#QUERY1
SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
SET VERIFY OFF
SET NUMFORMAT 99999999999999999
Select max(time_created) from test.table1 where cust=1;
EXIT;
#QUERY2
SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
SET VERIFY OFF
SET NUMFORMAT 99999999999999999
Select count(*) from test.table1 where cust=1;
EXIT;
#QUERY3
SET ECHO OFF NEWP 0 SPA 0 PAGES 0 FEED OFF HEAD OFF TRIMS ON TAB OFF
SET VERIFY OFF
SET NUMFORMAT 99999999999999999
Select count(*) from test.table12 where acct=1;
EXIT;
I am using below command
x=$(cat test.sql )
echo $x | awk -F'COUNT_QUERY' '{ print $0 }'
Could someone help with some good approach to this?
Could you please try following, written and tested with shown samples in GNU awk
.
awk '/^#QUERY2$/{found=1} found; /^EXIT/ && found{exit}' Input_file
Explanation: Adding detailed explanation for above.
awk ' ##Starting awk program from here.
/^#QUERY2/{ ##Checking condition if line starts with #QUERY2 then do following.
found=1 ##Setting found value as 1 here.
}
found; ##Checking condition if found is SET then print that line.
/^EXIT/ && found{ ##Checking condition if line starts with EXIT and found is SET then do following.
exit ##exit from program from here.
}
' Input_file ##Mentioning Input_file name here.