I would like to get the unique values from a file field into an array the easiest way possible...
If I want to see the unique (each one only once) locations that are in a transaction file where the location can exist many times, I can do an SQL like this:
Select distinct location from myfile
From within an RPG, how can I get that resulting list of locations from the SQL and into an array?
(I'll do it the old-fashioned way in the meantime until someone suggests a niftier way to do this)