But in a real world example that I included SQL would be faster. Using
RPG I am chaining the entire units record in, then I am chaining in
the TRANSFER_CONTROL table and then checking the dates to see if they
are in range and then chaining in the UNITS_TRANSFERRED record to see
if it already there.