To save a specific view in spreadsheet form, do the following:
Select CNAV Tools, Table Tool.
Use the provided drop-down list to select the view you wish to save.
Click Save View as Spreadsheet. CNAV displays the Table/View Information screen.
At the top of the Table/View Information screen, select the desired output file format. Your choices are Microsoft Excel spreadsheet format or comma-separated value (CSV) format.
Use the additional fields on this screen to enter a SELECT statement specifying the data you wish to save into the output file. Taken together, the initial Table Tool screen and the resulting Table/View Information screen allow you to specify a standard SELECT statement having the form:
SELECT view-name
FROM column-name1, column-name2, etc.
WHERE conditions listed apply.
On the initial Table Tool screen, you input the SELECT view-name portion of this command when you selected the target view from the provided drop-down list. To complete the rest of the command, enter the following information:
Select columns FROM drop-down: Use the provided drop-down list to complete the FROM clause of your SELECT statement. To select multiple columns, Control-Click.
Enter WHERE clause: Type in the WHERE conditions you wish to execute for this SELECT statement. Please note that the WHERE is provided by CNAV. Therefore, do NOT type WHERE in your entry. If you do type WHERE, CNAV will return a database error.
Save WHERE clause: Tick this checkbox to save the WHERE clause you entered for the duration of this Table Tool session. If you do not tick this checkbox, when you click Back to return to this screen after viewing the results of this SELECT statement, the WHERE clause entry field will be empty. Using this checkbox allows you to repeatedly return to a modify a complex WHERE statement with minimal typing.
NOTE:
Saving the WHERE clause has effect only for the duration of this Table Tool session. You cannot use this option to save a WHERE clause that you wish to reuse on a continuing basis. For example, if you wish to dump the data in a specific view each month, you cannot save the WHERE clause here to re-execute next month. In these cases, we suggest that you devise an internal policy for recording and saving the required SELECT statement to be re-input as needed.
Enter description if saving: Use this comment field to enter a short, but useful, description of the WHERE clause you are saving for this Table Tool session.
After entering all required information, click Select Columns to execute the completed SELECT statement.