SQL Command Manager Utility function

This section describes the SQL (structured query language) Command Manager utility, which allows you to execute SPUFI or SQL without leaving File-AID for Db2.

SPUFI

When you select option 5 from the Utility Selection Menu, File-AID for Db2 accesses IBM SPUFI in Db2, and the SPUFI screen appears (see the following figure).

SPUFI screen

SPUFI                                                      SSID: DSN ===>

Enter the input dataset name:       (Can be sequential or partitioned)
  1 DATASET NAME ... ===> SHOW.SQL(SHOWSQL)
  2 VOLUME SERIAL ... ===>          (Enter if not cataloged)
  3 DATASET PASSWORD ===>           (Enter if password protected)

Enter the output dataset name:      (Must be a sequential dataset)
  4 DATASET NAME ... ===> SQLOUT

Specify processing options:
  5 CHANGE DEFAULTS    ===> YES   (Y/N - Display SPUFI defaults panel?)
  6 EDIT INPUT ...... ===> YES   (Y/N - Enter SQL statements?)
  7 EXECUTE .......... ===> YES   (Y/N - Execute SQL statements?)
  8 AUTOCOMMIT ....... ===> YES   (Y/N - Commit after successful run?)
  9 BROWSE OUTPUT .... ===> YES   (Y/N - Browse output dataset?)

For remote SQL processing:
10 CONNECT LOCATION    ===>

PRESS: ENTER to process     END to exit     HELP for more information

1 DATASET NAME

Name of the data set to contain the SQL statements; it must have been previously allocated.

2 VOLUME SERIAL

Serial number of the volume where the input data set resides (if it is not cataloged).

3 DATASET PASSWORD

Password, if any, for the input data set.

4 DATASET NAME

Name of a data set to contain the results of processing, which includes a copy of each SQL statement and any output it generated.

5 CHANGE DEFAULTS

Indicates whether you want the CURRENT SPUFI DEFAULTS screen shown before the first processing step. This screen lets you change certain characteristics of the SPUFI processing run and its output.

6 EDIT INPUT

Indicates whether you want to edit the input data set before processing.

7 EXECUTE

Indicates whether the SQL statements in the input data set should be processed.

8 AUTOCOMMIT

Indicates whether changes made to the database by the SQL statements processed should be automatically committed.

9 BROWSE OUTPUT

Indicates whether you want to browse the output data set after the SQL statements in the input data set have been processed.

10 CONNECT LOCATION

Indicates application server to which SPUFI will issue a SQL connect. All SQL statements you submit will then be executed by this server.