“This was on an IBM mainframe and involved writing a script to extract all customers to a file, remove staff, contractors, their relatives etc, extract the random 1000 and create a database load file consisting of account ID, number of points and the date to be applied.”
Pardon me for not being a mainframe guy (I'm a bit too young for all that), but surely that's like 1 SQL query?