Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › Scroll Through the DB2 and SQL/DS Table Display

Scroll Through the DB2 and SQL/DS Table Display

FILE displays DB2 and SQL/DS table data horizontally in columns and vertically in rows.

• The columns represent the fields in the database
• The rows represent the records for each member in the table

The following screen shows an SQL table data display.

 CA InterTest for CICS V9.1 - File DB2 Facility                               
 EXEC SQL                        # Cols 012   Max Loc 00141   Loc 00001 Page 001  
 SELECT * FROM DSN8210.EMP                                                 
                                                                                  
 1-------2-------------3---------4----------------5----------6----------7------
  EMPNO  | FIRSTNME    | MIDINIT | LASTNAME       | WORKDEPT | *PHONENO | *HIRE  
 --------+-------------+---------+----------------+----------+----------+-----+   
  000210 | WILLIAM     | T       | JONES          | D11      | 0942     | 1979 
  000220 | JENNIFER    | K       | LUTZ           | D11      | 0672     | 1968 
  000070 | EVA         | D       | PULASKI        | D21      | 7831     | 1980 
  000230 | JAMES       | J       | JEFFERSON      | D21      | 4265     | 1966 
  000240 | SALVATORE   | M       | MARINO         | D21      | 3780     | 1979 
  000250 | DANIEL      | S       | SMITH          | D21      | 0961     | 1969 
  000260 | SYBIL       | V       | JOHNSON        | D21      | 8953     | 1975 
  000270 | MARIA       | L       | PEREZ          | D21      | 9001     | 1980 
  000050 | JOHN        | B       | GEYER          | E01      | 6789     | 1949 
  000090 | EILEEN      | W       | HENDERSON      | E11      | 5498     | 1970 
  000280 | ETHEL       | R       | SCHNEIDER      | E11      | 8997     | 1967 
  000290 | JOHN        | R       | PARKER         | E11      | 4502     | 1980 
  000300 | PHILIP      | X       | SMITH          | E11      | 2095     | 1972 

 1 Help       2 CMND list 3 END       4 Large CMND  5 Log On     6 DataType FC    
 7 Page bwd   8 Page fwd  9 Page 1   10 Scrl. -->  11 Scrl. <-- 12 Structure

In the previous screen, the column headings (EMPNO, FIRSTNME, MIDINIT, and so on) represent all fields in the table. A heading preceded by an asterisk indicates that the field contains null characters (for example, *PHONENO).

The vertical rows represent the members in the table. In this example, each member contains information for a different employee. If all the rows cannot display on one screen, press PF8 to page down through the table. Press PF7 to page up again.

FILE provides the following information above the screen display:

# Rows—specifies the total number of rows in the display. FILE displays this field only if you page down to the end of the table.

Cols—specifies the number of columns defined in the table.

Max Loc—specifies the horizontal width of the screen display.

Loc—specifies the position of the leftmost character on display.

Page—specifies the page you are currently viewing.