Output from SPUFI
SPUFI formats and displays the output data set using the ISPF Browse program.
- The executed SQL statement, copied from the input data set
- The results of executing the SQL statement
- The formatted SQLCA, if an error occurs during statement execution
At the end of the data set are summary statistics that describe the processing of the input data set as a whole.
For SELECT statements that are executed with SPUFI, the message "SQLCODE IS 100" indicates an error-free result. If the message SQLCODE IS 100 is the only result, DB2 is unable to find any rows that satisfy the condition that is specified in the statement.
For all other types of SQL statements that are executed with SPUFI, the message "SQLCODE IS 0" indicates an error-free result.
Formatting rules for SELECT statement results in SPUFI:
- If numeric or character data of a column cannot be displayed completely:
- Character values and binary values that are too wide truncate on the right.
- Numeric values that are too wide display as asterisks (*).
- For columns other than LOB and XML columns, if truncation occurs, the output data set contains a warning message. Because LOB and XML columns are generally longer than the value you choose for field MAX CHAR FIELD on panel CURRENT SPUFI DEFAULTS, SPUFI displays no warning message when it truncates LOB or XML column output.
You can change the amount of data that is displayed for numeric and character columns by changing values on the CURRENT SPUFI DEFAULTS panel, as described in Changing SPUFI defaults.
- A null value is displayed as a series of hyphens (-).
- A ROWID, BLOB, BINARY, or VARBINARY column value is displayed in hexadecimal.
- A CLOB column value is displayed in the same way as a VARCHAR column value.
- A DBCLOB column value is displayed in the same way as a VARGRAPHIC column value.
- An XML column is displayed in the same way as a LOB column.
- A heading identifies each selected column, and is repeated at the top of each output page. The contents of the heading depend on the value that you specified in the COLUMN HEADING field of the CURRENT SPUFI DEFAULTS panel.
Content of the messages from SPUFI:
- The SQLCODE, if the statement executes successfully.
- The formatted SQLCA, if the statement executes unsuccessfully.
- What character positions of the input data set that SPUFI scanned to find SQL statements. This information helps you check the assumptions that SPUFI made about the location of line numbers (if any) in your input data set.
- Some overall statistics:
- Number of SQL statements that are processed
- Number of input records that are read (from the input data set)
- Number of output records that are written (to the output data set).
- The number of rows that DB2 processed,
that either:
- Your select operation retrieved
- Your update operation modified
- Your insert operation added to a table
- Your delete operation deleted from a table
- Which columns display truncated data because the data was too wide