Query Results

To open the Query Results window, follow these steps:

1. In a 3270 Display session, 5250 Display session, or VT Display session, click Actions > Transfer Data > Receive Data from Host.
2. Select an existing SQL statement.
3. Click Run.

The Query Results window allows you to view and save the results of an SQL query. An SQL query is an SQL statement with the type Select.

In the interior of the Query Results window, Host On-Demand displays the contents of those rows in the remote database that match the SQL query.

• The columns are displayed in the same order in which they are specified in the SQL statement (on the Columns tab of the SQL Wizard).
• The numeral in the leftmost column (1, 2, 3, and so on) is not part of the contents of the row, but rather is included only to indicate the order in which the row result was returned.

Copy to clipboard

Click Copy to clipboard to copy the results of the SQL Select statement to the system clipboard. Host On-Demand copies the results to the system clipboard in several text formats (such as Text, Unicode Text, Locale, and OEM text).

Save SQL

Click Save SQL to store inside the current session definition the SQL statement that produced the displayed results. The saved SQL statement appears in the Saved SQL Statements area of the Receive Data from Host window.

Save Results

Click Save Results to save the displayed results to a file. You can specify:

• The file path and name.
• The format of the data. Supported formats are:
  • ASCII Text (*.txt)
  • Comma-separated values (*.csv)
  • Lotus 1-2-3 (*.wk1)
  • Microsoft Excel - BIFF3 (*.xls)
  • Microsoft Excel - BIFF4 (*.xls)
  • HTML (*.html)
  • XML (*.xml)

Related topics:

• Receive Data from Host
• Configure SQL Statement
• SQLQuery action (<sqlquery> element) Macro Programming Guide
• Send Data to Host
• Data Transfer Defaults
• Overview of database access