Information Center

Receive Data from Host

To open the Receive Data from Host window from the session window of a 3270 Display session, 5250 Display session, or VT Display session, click Actions > Transfer Data > Receive Data from Host.

The Receive Data from Host window allows you to use and manage SQL statements. If your Host On-Demand client is configured to do so, you can perform the following actions:

The Saved SQL Statements area lists the names of SQL statements currently available, either within the current session or within your personal library. Within the Saved SQL Statements area:

Some of the options described below possibly do not appear on your Receive Data from Host window, depending on how your Host On-Demand administrator has configured your Host On-Demand client.

Open
Click Open to open the currently selected SQL statement:
Run
Click Run to run the currently selected SQL statement.
New
Click New to open the Configure SQL Statement window and create a new SQL statement.
Delete
Click Delete to delete the currently selected SQL statement from the current session or from your Personal Library. A message prompts, "Are you sure?"
Import
Click Import to read an SQL statement from a file and add it to the current session. The SQL statement is added to the list of SQL statements under Current Session. Follow these steps:
  1. Click Import.
  2. In the Import window, select a file containing an SQL statement, or type in the path and name of the file.
  3. Click Open.
Only one SQL statement is contained in a file. The default file extension is .sql.
Export
Click Export to store the selected SQL statement into a file. Only one SQL statement is stored per file. The default file extension is .sql.

Related topics: