BROWSE and VIEW panels

BROWSE and VIEW panels contain details about Db2 objects.

From any table display panel, you can issue BROWSE and VIEW commands as follows:

The BROWSE (or BR) primary command and the BR line command open an ISPF BROWSE session. In a BROWSE session, you cannot edit the data.
The VIEW (or VI) primary command and the VI line command open an ISPF VIEW session. In a VIEW session, you can edit the data in a data set by using ISPF commands.

For both BROWSE and VIEW, the primary commands display information about the entire panel, and the line commands display information about only the selected object.

For example, on the following table display panel, the Tables, Views, and Aliases (ADB21T) panel, suppose that you issue the BROWSE primary command:

Figure 1. BROWSE command on the Tables, Views, and Aliases (ADB21T) panel

DB2 Admin ----------- DB2X Tables, Views, and Aliases ---------- Row 32 of 160 
Command ===> BROWSE                                           Scroll ===> PAGE 
                                                                               
Commands: GRANT  MIG                                                           
Line commands:				                                                        
 C - Columns  A - Auth  L - List  X - Indexes  S - Table space  D - Database   
 V - Views  T - Tables  P - Plans  Y - Synonyms  SEL - Select prototyping      
 ? - Show all line commands                                                    
                                                                               
Sel   Name               Owner    T DB Name  TS Name    Cols        Rows Checks
      *                  *        * *        *             *           *      *
----- ------------------ -------- - -------- -------- ------ ----------- ------
      EACT               DSN8810  T DSN8D81A DSN8S81R      5          -1      0
      EPROJACT           DSN8810  T DSN8D81A DSN8S81R      7          -1      0
      EEPA               DSN8810  T DSN8D81A DSN8S81R      8          -1      0
      VPHONE             DSN8810  V DSN8D81A DSN8S81E      7          -1      0
      VEMPLP             DSN8810  V DSN8D81A DSN8S81E      2          -1      0

The following output is generated in an ISPF BROWSE session. The first line is a header with column names from the Db2 catalog. To display the remaining columns, scroll to the right.

Figure 2. Output from the BROWSE command

 DB2 Admin ----- DB2X Browse Result of SQL Select ---- Line 00000000 Col 001 080
 Command ===>                                                  Scroll ===> PAGE 
                                                                                
********************************* Top of Data **********************************
 NAME               CREATOR  TYPE DBNAME   TSNAME     DBID   OBID COLCOUNT EDPRO
 ------------------ -------- ---- -------- -------- ------ ------ -------- -----
 DSNRLST01          SYSIBM   T    DSNRLST  DSNRLS01    256      3       11      
 DSN_REGISTER_APPL  DSNRGCOL T    DSNRGFDB DSNRGFTS    257      3        9      
 DSN_REGISTER_OBJT  DSNRGCOL T    DSNRGFDB DSNRGFTS    257      6       11      
 DEPT               DSN8810  T    DSN8D81A DSN8S81D    258     11        5      
 VDEPT              DSN8810  V    DSN8D81A DSN8S81D      0      0        4

Tip: When you use BROWSE or VIEW, all columns for that Db2 catalog table are displayed, even those columns that are considered "not used" by Db2. [To determine which columns are "not used," see the documentation for the catalog table in Db2 catalog tables (Db2 13 for z/OS).] If you do not want these columns displayed, use the I (Interpret) line command on the table panel instead of the BROWSE or VIEW command.

Db2 Admin Tool can also display data in tables that contain binary large objects (BLOBs), character large objects (CLOBs), double-byte character large objects (DBCLOBs), and ROWID columns:

For BLOBs, Db2 Admin Tool retrieves up to 128 bytes per column and displays the data in hexadecimal format.
For CLOBs, Db2 Admin Tool retrieves up to 256 bytes per column and displays the data in character format.
For DBCLOBs, Db2 Admin Tool retrieves up to 128 bytes per column and displays the data in hexadecimal format.
ROWIDs are displayed in hexadecimal format.