The Query Run tab allows you to specify the following options for running queries with SQLWizard. See also Query Tab.
| Execute | These options apply to the SQL Edit window and SQL Scripts. They do not affect the running of queries from the Query Design window. | |
| All Commands | Select if you want to run all commands that appear in the current SQL Edit window or SQL script when you begin a run. | |
| First Command | Select if you want to run only the first command in the current SQL Edit window or SQL script when you begin a run. | |
| Current Command | Select if you want to run the currently selected command in the current SQL Edit window when you begin a run. | |
| Edit Options | ||
| Allow Editing | Enables the ALLOW EDITING option on for any query you run. The ALLOW EDITING option lets you to enter and change data on the Results window. | |
| Check Unique Key | If checked, enables unique-key checking. When this option is set, SQLWizard automatically searches the SYSINDEX and SYSKEYS
tables during an edit-mode query, and adds unique key fields to the query, even if the user has not explicitly selected them.
Such action allows SQLWizard to generate the appropriate WHERE clause should the user subsequently choose to update any of the extracted data. On certain databases (e.g., large DB2 3.x locations without a shadow catalog), the search for unique key fields can result in extremely long query times. If your database has been designed so that a unique key is always selected, this option can be disabled to eliminate the search for unique keys, thereby improving performance. |
|
| Read-Only Alert | Enables a pop-up box warning when a query is not editable. Disables the result set "Allow Editing" feature for the SQL Window. | |
| Result Table | If checked, the default view for a Query Result window is the Result Table format. This format displays multiple records in a grid format that looks similar to a spreadsheet. | |
| Result Form | If checked, the default view for a Query Result window is the Result Form. This format displays one record at a time. | |
| NULL= | Select a color from the drop-down list to specify the color you want to use to represent null values. Once you have specified a color, you can toggle the colorization of null values on and off using the Highlight Nulls option on the Query menu when viewing an SQL window, and on the View menu when viewing a Result Table or Result Form window. | |
| Max Records to Retrieve | ||
| All | Enable this option if you want to retrieve all rows that meet the criteria of the query and displays them in a Result window. | |
| First n Records | Enable this option if you want to retrieve only the first nrows that meet the criteria of the query and displays them in a Result window. This allows you to limit the amount of data coming back and is very useful when testing a query. If you choose this option, be sure to enter the number of records you want to set as your limit. | |
| For Bit Data Display | ||
| Use Hex Format | If checked, columns that are defined as FOR BIT DATA will be displayed in hex in the result set browser. This allows SQLWizard to build a query with a where clause which uses the hex literals of FOR BIT DATA fields to identify the row you would like to delete or update in the result set browser. | |
| No Display | Will suppress the display of empty result sets. If running in interactive mode, a pop-up box will appear notifying you that no rows were retrieved. If running in interactive batch mode (running a batch SQL script from the menu by clicking Run Batch on the File menu) it will prevent the displaying of empty result windows without any warning. |