Is there a command that copies data from a table to a flat file for
specified selection criteria?
IE akin to a copy but not dumping a whole file?
If I'm about to do a major change to data in a table, I'd like to be
able to keep a copy of the data before the change (I know I can
Begin...rollback should things go wrong).
Is there a command that I've missed? (Informix had an 'UNLOAD TO blah
SELECT blah..' type command which presumably was proprietary).