If you use dbisql 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.
Setting quiet mode prerequisites
Start Interactive SQL.
In the Interactive SQL window, select Tools | Options. The Options window appears.
Select Sybase IQ in the left pane.
Click the Results tab.
In the Results Processing area, select Show all results sets.
Click OK.
