Monday, 2 September 2013

DB2 Interfaces

A variety of ways to interface with DB2 are available, such as with programs using TSO, CAF, CICS, and so on. Two of the most common interfaces provided with the DB2 product are DB2 Interactive (DB2I) and Sequential Processing Using File Input (SPUFI).
DB2 Interactive
The interactive program DB2I can be used to run application programs and to perform many DB2 operations by entering values on panels. DB2I runs under TSO, using ISPF (Interactive System Productivity Facility) services. To use DB2I, follow the local procedures for logging on to TSO, and enter ISPF. Each operation is controlled by entering the parameters that describe it on the panels provided. DB2 also provides help panels to
SPUFI (Sequential Processing Using File Input)

SPUFI is a DB2I menu option that allows you to execute SQL statements interactively with DB2. The options on the main menu are as follows.

  • Input data set name is the data set that contains one or more SQL statements that are to be executed. The data set needs to exist before SPUFI can be used.
  • Output data set name is the data set that will receive the output from the SQL statement that is executed. This data set does not have to exist before execution.
  • Change defaults allows for changing control values and characteristics of the output data set and the format of SPUFI settings.
  • Edit input a llows for editing the SQL statements.
  • Execute indicates whether to execute the SQL statement in the input file.
  • Autocommit tells DB2 whether to make the changes to the data permanent.
  • Browse output allows for browsing of the query output.
  • Connect location specifies the name of the application server to receive the queries.
SPUFI allows you to have multiple queries in one input data set member for execution. The queries can be stacked by using a between the statements. Without an explicit COMMIT statement, all the SQL statements are considered a unit of work.

Created with Artisteer

No comments:

Post a comment