pls help me out on this. bit tricky one :)
1. Have a file similar to ".ini" format header and its sections. e.g. schema.ddl
2. Another file with list of keywords on each line. e.g table_list.txt
3. Need to read each line from table_list.txt and search it in schema.ddl and remove the entire table section and its associated index section as well.
Have attached both the files for your quick reference. pls unzip schema.zip file.
"S_PARTY" is the first keyword from the table_list.txt
table section can be found in schema.ddl between line # 317941
associated section can be found between 317962
basically for each keyword (table name) we need to repeat the process and remove relative entries using windows batch or powershell or vbscript reason, this will be executed on a windows machine. if any util that doesnt require installation and would easy this. we can use that util as well.
pls help and thx in advance.