DB2 Browse Result Table (5.5.4)

Related Tpoics

The DB2 Browse Result Table screen (5.5.4) lets you browse the Db2 table selected on the DB2-Table-View-List-5-5-1 screen, or created by the EASY QUERY.

The displayed column headings are column names in the result table. Numeric data is right-justified with the column; character data is left-justified. The width of the display for each column is either the column name or the maximum number of bytes required to display the data, whichever is greater. Each column is separated by one blank. Nonprinting characters are displayed as periods (.). Null columns display the maximum number of null display characters that are required to display the contents of the field.

Access this screen by using the S (Select) line command to select a table on the DB2-Table-View-List-5-5-1 screen, or by using the SHOW RESULT command on the DB2-Build-SQL-Easy-Query-5-5-2 screen or the DB2 Browse Generated SQL Call (5.5.3) screen.

DB2 Browse Result Table Screen (5.5.4)

-------------------------- DB2 BROWSE RESULT TABLE (5.5.4) ----------------C024
COMMAND ===>                                                   SCROLL ===> CSR
MODULE:          CSECT:
VALID COMMANDS: CANCEL   FIND   LOCATE   END

CREATOR: CWX0030 TABLE: COMPOSITE_TABLE                    ROW     1 OF 8
                                                       POSITION     1 OF 226
   LINE COMMANDS: D (Delete) I (Insert) R (Replicate) S (Select)

  DATE_FIELD TIME_FIELD      TIMESTAMP_FIELD
* ---------- ---------- -------------------------- ----------------------------
_ 1990-06-25 12.00.00   1990-01-02-18.12.41.059239 0123456789
_ 1990-01-31 00.52.33   1990-01-31-10.52.33.393491 1234567890123456789012345678
_ 1990-02-27 18.12.41   1990-01-02-18.12.41.059239 0123456789
_ 1990-03-01 18.12.41   1990-01-02-18.12.41.059239 0123456789
_ 1990-02-16 12.51.54   1990-02-16-12.51.54.307068 THIS ROW WAS INSERTED TODAY.
_ 1990-03-01 18.12.41   1990-01-02-18.12.41.059239 0123456789
_ 1990-02-21 18.58.37   1990-02-21-18.58.37.286103 DUMMY DATA
_ 1990-02-21 19.23.47   1990-02-21-19.23.47.657381
  *********************************** BOTTOM **********************************

Input Field

In the event that Db2 authorization prohibits you from modifying any data in the table, you cannot use line commands.

* (asterisk)

Line command entry field. Valid entries are:

D (Delete): Deletes the row from the table.
I (Insert): Inserts a row into the table. If a column in the row inserted may be NULL, it is set to NULL. If a column has been defined as NOT NULL, the following default initialization values, as described in DB2-Edit-Result-Table-Row-5-5-5 are used:
- SMALLINT, INTEGER, DECIMAL, FLOAT, LONGFLT are set to zero.
- FIXED CHAR and GRAPHIC are set to blanks.
- VARCHAR and GRAPHIC are set to length zero.
- TIME, DATE, AND TIMESTAMP are set to current value.
R (Replicate): Replicates the contents of the current row to allow insertion as a new row. You must update your key fields in the newly inserted row before you attempt to update the table by using the END command.
S (Select): Selects the row for editing on the DB2 Edit Result Table Row (5.5.5) screen.

Output Fields

CREATOR

Name of the creator of the Db2 table which is being displayed.

TABLE

Name of the Db2 table which is being displayed.

ROW xxxxx OF yyyyy

Displays the current top row (xxxxx) within the total rows (yyyyy) of columns from the table that are available for display on this screen. The yyyyy value is the number of rows in the result table and may be limited by the MAXIMUM ROWS TO SELECT parameter on the DB2 Setup screen (5.5.0).

POSITION xxxxx OF yyyyy

Displays the current leftmost position of data within the row being displayed.