Changing SPUFI defaults

Before you execute SQL statements in SPUFI, you can change the default execution behavior, such as the SQL terminator and the isolation level.

To change the SPUFI defaults:

1. On the SPUFI panel, specify YES in the CHANGE DEFAULTS field.
2. Press Enter.
   The CURRENT SPUFI DEFAULTS panel opens. The following figure shows the initial default values.

   DSNESP02                 CURRENT SPUFI DEFAULTS                SSID: DSN
   ===>
   Enter the following to control your SPUFI session:
    1  SQL TERMINATOR .. ===> ;      (SQL Statement Terminator)
    2  ISOLATION LEVEL   ===> RR     (RR=Repeatable Read, CS=Cursor Stability)
                                      UR=Uncommitted Read)
    3  MAX SELECT LINES  ===> 250    (Maximum lines to be returned from a SELECT)
    4  ALLOW SQL WARNINGS===> NO     (Continue fetching after SQL warning)
    5  CHANGE PLAN NAMES ===> NO     (Change the plan names used by SPUFI)
    6  SQL FORMAT ...... ===> SQL    (SQL, SQLCOMNT, or SQLPL)
   Output data set characteristics:
    7  SPACE UNIT ...... ===> TRK    (TRK or CYL)
    8  PRIMARY SPACE ... ===> 5      (Primary space allocation 1-999)
    9  SECONDARY SPACE . ===> 6      (Secondary space allocation 0-999) 
   10  RECORD LENGTH ... ===> 4092   (LRECL= logical record length)
   11  BLOCKSIZE ....... ===> 4096   (Size of one block)
   12  RECORD FORMAT.... ===> VB     (RECFM= F, FB, FBA, V, VB, or VB)
   13  DEVICE TYPE...... ===> SYSDA  (Must be a DASD unit name)
   Output format characteristics:
   14  MAX NUMERIC FIELD ===> 33     (Maximum width for numeric field)
   15  MAX CHAR FIELD .. ===> 80     (Maximum width for character field)
   16  COLUMN HEADING .. ===> NAMES  (NAMES, LABELS, ANY, or BOTH)
    
    
    
   PRESS: ENTER to process     END to exit    HELP for more information
   

3. Specify any new values in the fields of this panel. All fields must contain a value.
4. 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.

5. 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.