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

Example

In the previous display, the Loc field indicates that the display begins with position 1; the Max Loc field indicates that the entire table display is 141 characters wide. To see the remaining columns, you must scroll the display. If you tab the cursor to the line preceding HIREDATE and press Enter, FILE displays the following screen:

                         CA InterTest   File DB2 Facility        î         
 EXEC SQL  # Rows 00032          # Cols 012   Max Loc 00141   Loc 00075 Page 002  
 SELECT * FROM DSN8210.EMP                                                      
                                                                                  
 7------------8---------9---------10---11-----------12------
 |*HIREDATE |*JOBCODE |*EDUCLVL |*SEX |*BRTHDATE   |*SALARY |               
 +----------+---------+---------+-----+----------+----------+
 | 19790411 | 52      | 17      | M   | 19530223 | 18270.00 |             
 | 19680829 | 55      | 18      | F   | 19480319 | 29840.00 |             
 | 19800930 | 56      | 16      | F   | 19530526 | 36170.00 |             
 | 19661121 | 53      | 14      | M   | 19350530 | 22180.00 |             
 | 19791205 | 55      | 17      | M   | 19540331 | 28760.00 |             
 | 19691030 | 52      | 15      | M   | 19391112 | 19180.00 |             
 | 19750911 | 52      | 16      | F   | 19361005 | 17250.00 |             
 | 19800930 | 55      | 15      | F   | 19530526 | 27380.00 |             
 | 19490817 | 58      | 16      | M   | 19250915 | 40175.00 |             
 | 19700815 | 55      | 16      | F   | 19410515 | 29750.00 |             
 | 19670324 | 54      | 17      | F   | 19360328 | 26250.00 |             
 | 19800530 | 42      | 12      | M   | 19460709 | 15340.00 |             
 | 19720619 | 48      | 14      | M   | 19361027 | 17750.00 |             
 | 19640912 | 43      | 12      | F   | 19310421 | 15900.00 |             
 _______________________________________________________________________________  
 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

Now you can view the other columns in the table.

Note: The Loc field now indicates that the display begins with position 75.