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

View a Structured Display

To see a structured display of the data table columns, press PF12. The structured display lists each column from the Data Table display in left‑to‑right column order. The following screen shows the structured display of the columns in the previous screen.

      CA InterTest for CICS V9.1 - File DB2 Facility            
EXEC SQL                                                   Loc 00001           
SELECT * FROM DEVMPL.EMP
-------------------------------------------------------------------------
COL | COLUMN NAME                    | DATATYPE  | LENGTH | CODE | NULL |
----+--------------------------------+-----------+--------+------+------+
  1 | EMPNO                          | Char      |      6 |  452 |   No |
  2 | FIRSTNME                       | Char  Var |     12 |  448 |   No |
  3 | MIDINIT                        | Char      |      1 |  452 |   No |
  4 | LASTNAME                       | Char  Var |     15 |  448 |   No |
  5 | WORKDEPT                       | Char      |      3 |  453 |  Yes |
  6 | PHONENO                        | Char      |      4 |  453 |  Yes |  
  7 | HIREDATE                       | Date Type |     10 |  385 |  Yes |  
  8 | JOB                            | Char      |      8 |  453 |  Yes |  
  9 | EDLEVEL                        | Integer S |      2 |  501 |  Yes | 
 10 | SEX                            | Char      |      1 |  453 |  Yes | 
 11 | BIRTHDATE                      | Date Type |     10 |  385 |  Yes | 
 12 | SALARY                         | Decimal   |   9. 2 |  485 |  Yes | 
 13 | BONUS                          | Decimal   |   9. 2 |  485 |  Yes | 
 14 | COMM                           | Decimal   |   9. 2 |  485 |  Yes |
______________________________________________________________________________
1 Help       2 CMND list 3 END       4 Large CMND  5 Log On     6 DataType FC
7            8           9          10            11           12 Data Table

Each row of the Structured Display gives the following information about a column on the Data Table display:

• Relative (left‑to‑right) column number
• Name
• Data type (such as character and integer)
• Length
• Data type code
• Whether the field contains null characters

Press PF12 to redisplay the table display.

Select the starting column before redisplaying the Data Table in one of the following ways:

• Change the value in the LOC field to indicate a starting display position. To do this, enter nn, clear any remaining LOC field numbers, and press PF12.

Example

If you enter 22 in the LOC field, the display starts at position 22.

• Change the value in the LOC field to indicate a starting column number. To do this, enter #nn, clear any remaining LOC field numbers, and press PF12.

Example

If you enter #9 in the LOC field, the display starts with the first character in column 9.