Saving Queries from SQLWizard

Use the Save Query dialog to save the details of your query to file, or to copy the SQL expression to the Windows clipboard.

To save a query:

1    Click Save Query. The Save Query dialog is displayed.

2    If you want to save the SQL statement to a file, select Save SQL to file, and click the File Pictures/SQLWizardFileButton.gif button to select a location for the file. By default, SQL files are saved with an extension of .SQL.

3    If you want to save your natural language query, select Save reloadable query to file and click the File Pictures/SQLWizardFileButton.gif button to select a location for the file. By default, natural language queries are saved with an extension of .DBQ

4    Click OK to save the expression and close the dialog.

Notes

    To reload a saved query into SQLWizard, click Open Query.

    Use SQL files in the command line of views to control the data displayed.