Hey. There is a multi-member physical data file. Is there a “simple” way to remove from all its members records that satisfy a certain condition? For example, you must delete all records for which the DATA symbol field contains the text "delete". If there was one member in the file, then I would use something like this SQL expression:
But in my case there are several members and this expression must be applied to each of them.
Code:
delete from FILE where DATA like '%delete%'
Comment