Before you execute SQL statements in SPUFI, you can change
the default execution behavior, such as the SQL terminator and the
isolation level.
About this task
SPUFI provides default values the first time that you
use SPUFI for all options except the DB2® subsystem
name. Any changes that you make to these values remain in effect until
you change the values again.
Procedure
To change the SPUFI defaults:
On the SPUFI panel, specify YES in the CHANGE DEFAULTS
field.
Press Enter. The CURRENT SPUFI DEFAULTS panel
opens. The following figure shows the initial default values.
Specify any new values in the fields of this panel. All
fields must contain a value.
Press Enter. SPUFI saves your changes and one
of the following panels or data sets open:
The CURRENT SPUFI DEFAULTS - PANEL 2 panel. This panel opens if
you specified YES in the CHANGE PLAN NAMES field.
EDIT panel. This panel opens if you specified YES in the EDIT
INPUT field on the SPUFI panel.
Output data set. This data set opens if you specified NO in the
EDIT INPUT field on the SPUFI panel.
SPUFI panel. This panel opens if you specified NO for all of the
processing options on the SPUFI panel.
If you press the END key on the CURRENT SPUFI DEFAULTS panel,
the SPUFI panel is displayed, and you lose all the changes that you
made on the CURRENT SPUFI DEFAULTS panel.
If the CURRENT SPUFI DEFAULTS - PANEL 2 panel opens, specify
values for the fields on that panel and press Enter. All fields must
contain a value.
Important: If you specify
an invalid or incorrect plan name, SPUFI might experience operational
errors or your data might be contaminated.
SPUFI saves your changes
and one of the following panels or data sets open:
EDIT panel. This panel opens if you specified YES in the EDIT
INPUT field on the SPUFI panel.
Output data set. This data set opens if you specified NO in the
EDIT INPUT field on the SPUFI panel.
SPUFI panel. This panel opens if you specified NO for all of the
processing options on the SPUFI panel.
Results
Next, continue with one of the following tasks:
If you want to add SQL statements to the input data set or edit
the SQL statements in the input data set, enter SQL statements in
SPUFI.
Otherwise if the input data set already contains the SQL statements
that you want to execute, process SQL statements with SPUFI.