Download INFORMIX-Enterprise Command Center User Guide

Saving Returned Data as Text Files
Saving Returned Data as Text Files
You can save an SQL statement’s returned data as a text file. You can save
either the returned data displayed in an output page’s Returned Rows grid
(as a standard text file or as an HTML file in table format) or the data
displayed in the Cell Viewer window’s Cell Contents text box.
To save a Returned Rows grid as a text file
1.
In the SQL Editor, click the tab of an output page that contains data
you want to save.
The output page appears.
2.
Choose File➞Save As Data.
The Save As dialog box appears.
3.
Specify the full pathname and format of the file in the dialog box;
then click Save.
If you do not specify a filename or format, the grid is saved with a name
formed by the SQL statement text file’s name, the output page number, and
the .txt extension. For example, if the SQL statements that created this output
page were saved as trig_script.sql, and this is the output page labeled
Output4, the Returned Rows grid is saved as trig_script4.txt.
To save the Cell Contents text box as a text file
1.
In the Cell Viewer window, display the data you want to save.
For instructions, see “Viewing a Grid Cell” on page 8-23.
2.
Click the Save As Data button on the Cell Viewer window’s toolbar.
This button is shown in Figure 8-5 on page 8-24.
The Save As dialog box appears.
3.
Specify the full pathname of the file in the dialog box; then click Save.
If you do not specify a filename, the Cell Contents text box is saved
with a name formed by the SQL statement text file’s name, the output
page number, and the .txt extension. For example, if the SQL statements that created this grid cell were saved as trig_script.sql, and
this grid cell is shown in the output page labeled Output4, the Cell
Contents text box is saved as trig_script4.txt.
SQL Statement Management 8-27