If you are interested in using either the iNav fat client or the 7.1TR?
web version http://youribmi:2001
, then you could use their 'export'
function. It does exactly that. It asks you for the table, allows you to
change the sql, and runs. What it does it creates a table in qtemp and
immediately runs CPYTOIMPF on that. Ok for a one off shot.