| Display Window | Select a window display style: 
 
                                
                                    
							 Single Window — display execution results in a single window, with
						  status details at the end. For a single statement with multiple results,
						  display result sets one after another in the same window. 
                                    Multiple Windows — display execution
						  status and each result for the current statement in a separate window.  | 
                    
                        | Display Mode | Select a results display mode: 
 
                                
                                    Text Mode — similar to  iSQL output when in
						  single-tab mode. 
						
                                    Grid Mode — similar to the Interactive SQL
						  window. 
						 | 
                    
                        | Show Column Headings | Show column headings in the results view. | 
                    
                        | Show Row Number | Show row numbers in results view. 
                                
                                    In text mode, this property
					 is always enabled.In grid mode, this property is selected by default. | 
                    
                        | Show Row Count Message | Show number of rows affected. 
                                
                                    In text mode, this property is
					 always enabled. Row count appears at the end of the results. 
In grid mode, this property is selected by default. Row count appears in the Status window. 
				  
 | 
                    
                        | Max Row Count | Enter the number of rows to retrieve from the result set. The default is 0
					 (retrieve all rows). Set a maximum to improve performance when testing queries
						and to avoid running out of memory when retrieving data from very large tables,
						for example, tables with a hundred million rows. 
					  | 
                    
                        | Max Display Row Count | Enter number of rows to display in the results view. To see all results, set 
						Maximum Rows to Retrieve to 0, and
						then save to a file. 
					  | 
                    
                        | Display Null Value As | Enter characters to display when the value is NULL.
					 Default is NULL. | 
                    
                        | Split All Messages Into Multiple Message Tabs | Split messages among more than one
					 tab. | 
                    
                        | Limit Tabs Number to | If you selected 
					 Multiple Windows for the 
					 Display Window preference, enter a
					 maximum number of tabs. | 
                    
                        | Limit Visible Tables Number to | If you selected 
					 Single Window for the 
					 Display Window preference, enter a
					 maximum number of visible tables. |