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

image2021-3-10_22-18-30.png

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*