SQL

Use this panel to customized settings related to FTP SQL queries.

FTP enables you to submit a Structured Query Language (SQL) SELECT query to the DB2 subsystem and receive the results of the SQL query. FTP can perform this function as either the server or the client.

In order to perform the SQL SELECT query, the server requires that you define both the DB2 subsystem name and the DB2 plan name. The DB2 subsystem name is required since an MVS system can run several DB2 systems simultaneously. The plan name specifies the name of the specific DB2 system that you want to query. The DB2 plan name is the name of the plan built during the DB2 bind process. The plan specifies the access paths to the DB2 tables, checks the user's authority, and validates the SQL statements.

Before you begin, know the name of the DB2 subsystem and the DB2 plan for the database you want to query.

Steps

  1. Enter the name of the DB2 subsystem.
  2. Enter the name of the DB2 plan.
  3. Optionally, you may select the format for the SQL output and the column header names to be used.

You have completed this panel if you have entered a DB2 subsystem and plan names.

Fields

DB2 Subsystem Name

DB2 Plan Name

Output format

Client login mode (FILETYPE=SQL) (only available for FTP clients)

Push buttons
Click OK to complete the specification.
Click Cancel to negate any entries you have made on this page.
Click Help to understand more about this panel.