Setting Quiet Mode Prerequisites

If you use Interactive SQL with the -q option (quiet mode), and if the data extraction commands (primarily setting the option TEMP_EXTRACT_NAME1 to an output file) are in a command file, you must first set and make permanent the Show all result sets option.

If you do not set this option, the data extraction output file is not created.
  1. Start Interactive SQL.
  2. In the Interactive SQL window, select Tools > Options. The Options window appears.
  3. Select SAP Sybase IQ in the left pane.
  4. Click the Results tab.
  5. In the Results Processing area, select Show all results sets.
  6. Click OK.
Parent topic: Interactive SQL Command Line Options