Shell Programming and Scripting

sed -n "/$firstword(/,/[dD]elimiter\|DELIMITER/p" onlyproc1.sql | ...

cat views.sql
DROP VIEW IF EXISTS View11;
        CREATE VIEW View11
        AS
           SELECT User.id AS userId,
                  User.userCDIId AS userCDIId,
                          Button.id AS buttonId,
                  includeInCallHistory,
                  data AS pOCData,
                  Button.pointOfContactId AS pointOfContactId
            FROM User, UserCDI, Button, PointOfContact
            WHERE User.userCDIId = UserCDI.id
                  AND Button.parentUserCDIId = UserCDI.id
                  AND Button.pointOfContactId = PointOfContact.id
                  AND buttonType = 'PointOfContact';
 
        DROP VIEW IF EXISTS View22;
        CREATE VIEW View22
        AS
           SELECT User.id AS userId,
                  User.userCDIId AS userCDIId,
                  data AS personalPOCData,
                  Button.personalPointOfContactId AS personalPointOfContactId
            FROM User, UserCDI, Button,PersonalPointOfContact
            WHERE User.userCDIId = UserCDI.id
                  AND Button.parentUserCDIId = UserCDI.id
                  AND Button.personalPointOfContactId = PersonalPointOfContact.id
                  AND buttonType = 'PersonalPointOfContact';

firstword="CREATE VIEW View11"
 
 sed -n "/$firstword\$/,/;/p" views.sql | awk '!x[$1]++' > procextract.sql 
#the above commands extracts that prticular view and paste to procextract.sql
 
echo "`sed "/$firstword\$/,/;/d" views.sql `" > views.sql 
#the above command deletes that particular view from the views.sql file

cat procextract.sql
        CREATE VIEW View11
        AS
           SELECT User.id AS userId,
                  User.userCDIId AS userCDIId,
                          Button.id AS buttonId,
                  includeInCallHistory,
                  data AS pOCData,
                  Button.pointOfContactId AS pointOfContactId
            FROM User, UserCDI, Button, PointOfContact
            WHERE User.userCDIId = UserCDI.id
                  AND Button.parentUserCDIId = UserCDI.id

AND Button.pointOfContactId = PointOfContact.id
AND buttonType = 'PointOfContact';

$ awk '/CREATE VIEW View11/,/;$/ {print}' views.sql
CREATE VIEW View11
AS
   SELECT User.id AS userId,
          User.userCDIId AS userCDIId,
          Button.id AS buttonId,
          includeInCallHistory,
          data AS pOCData,
          Button.pointOfContactId AS pointOfContactId
    FROM User, UserCDI, Button, PointOfContact
    WHERE User.userCDIId = UserCDI.id
          AND Button.parentUserCDIId = UserCDI.id
          AND Button.pointOfContactId = PointOfContact.id
          AND buttonType = 'PointOfContact';

 firstword="CREATE VIEW View11"
[root@dunkin-ds-dev-103 vivek]# awk "/$firstword/,/;$/ {print}" tble2 | awk '!x[$1]++' > procextract2.sql
[root@dunkin-ds-dev-103 vivek]# cat procextract2.sql
        CREATE VIEW View11
        AS
           SELECT User.id AS userId,
                  User.userCDIId AS userCDIId,
                          Button.id AS buttonId,
                  includeInCallHistory,
                  data AS pOCData,
                  Button.pointOfContactId AS pointOfContactId
            FROM User, UserCDI, Button, PointOfContact
            WHERE User.userCDIId = UserCDI.id
                  AND Button.parentUserCDIId = UserCDI.id
[root@dunkin-ds-dev-103 vivek]#

$ awk 'BEGIN{ IGNORECASE=1 } /CREATE PROCEDURE/,/delimiter/' "$file1" > onlyproc1.sql