Q: If you run SQL over a DDM file, do all records get sent over the line and then selected? Or does the selection occur before the records are returned?

A: You cannot run SQL over DDM files. However, you can run SQL to remote relational databases (using the DRDA architecture). In that case, the SQL query is processed at the remote system and only the records that satisfy the query are returned to the local system.