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 example, on the following table display panel, the Tables, Views, and Aliases (ADB21T) panel, suppose that you issue the BROWSE primary command:
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.
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.