you can change the sublocation manually by using updateholdings one by one.
Or else send me the backup I will merge the sublocations using tool and return the updated backup
note: please stop the transactions untill you got the updated backup
1)I followed the procedure (updateholdings) but the problem was that in the O.P.A.C. the sublocation filter didn't work as it should.
For example I updated/changed a holding from "SUB1" to "SUB2" but in the WEBOPAC using the sublocation filter showed the updated holding in both sublocations.
After reindexing the record (using the "Technical Processing - Utilities - Reindex catalogue records") the problem in the webopac was solved and I was able to see the record/holding only in the correct sublocation.
2) Thank you for reminding me the RunIndexer.bat file. Very useful!
3)For future use, could you guide me on merging two sublocations using a routine/script or something, just to know how. I think I can do it.