Shell Programming and Scripting

Hi,

From the pattern mentioned below remove lines based on pattern range.

Conditions

1 Look For all lines starting with ALTER TABLE and Ending with ; and contains the word MOVE.I wanto to remove these lines from the file sample below.

Note : The above pattern list could be found in a single line or in multiple lines.That is the first line may have Begin pattern that is ALTER TABLE and 10th line may have the end pattern that is ";" within this start and end range if it contains the word MOVE then i want the command to remove all the lines found between ALTER TABLE and ";". I have been trying this for 8 hrs now any help is appreciated.

Sample File

ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID MONITORING;
ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID STORAGE ( NEXT 3464K );
Prompt Table DQZ_ALTER_SCHEMA_ID;
ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID
MOVE LOB (MESSAGE)
STORE AS (
TABLESPACE CLEAN_DATA1
STORAGE (
INITIAL 256K
NEXT 1384K
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 1
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
));
ALTER TABLE DQZ.DQZ_ALTER_SCHEMA_ID
MODIFY LOB (MESSAGE)
(
PCTVERSION 10
);

REVOKE EXECUTE ON DQZ.DQZ_FORMS_VALIDATEX FROM CLEANDATAVNDR;
REVOKE EXECUTE ON DQZ.DQZ_FORMS_REQUIREDX FROM CLEANDATAVNDR;

Thanks and kind regards,
Rajan

Please respect the forum rules: No double or cross-posting.