Q: How do I save the results of an SQL query to an output file? I'm using interactive SQL to do queries, and I need to be able to save the results into a table.

A: When you are in interactive SQL, press F13. Select option 1-Change Session Attributes. Change the SELECT output parameter to 3 (which means that output goes to a file). You will be asked for a name and library for the output file. You can also choose whether or not to create the file or whether to append to an existing file.

- Brian Singleton