Printing rows from a Db2® table

To print rows from a Db2® table, use:
  • The RD (Record Dump) primary command to print the data in dump format
  • The RP (Record Print) primary command to print the data in character format

Examples

Here is an example of RD output when the display format is SNGL:
Figure 1. Sample printed output from RD primary command (SNGL display format)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Print Browse            SHRIKE2.FMN.LIST                          Top of 64    
 Command ===>                                                       Scroll CSR 
                                    Record AT TOP    Col 2          Format CHAR 
 ---+----10---+----2----+----3----+----4----+----5----+----6----+----7----+----8
****  Top of data  ****                                                         
IBM® File Manager for z/OS®  Db2 Component                                         
Key    Column       Data                                                        
--------------------------------------------------------------------------------
Printed record number - 1                                                       
                                                                                
PUN    EMPNO        000010                                                      
                    FFFFFF
                    000010                                                      
                                                                                
  N    FIRSTNME     CHRISTINE<                                                  
                    CCDCEECDC                                                   
                    389923955                                                   
                                                                                
       MIDINIT      I                                                           
  F1=Help    F2=Split   F3=Exit    F4=Print   F5=RFind   F6=Purge   F7=Up
  F8=Down    F9=Swap   F10=Left   F11=Right  F12=Cancel
  
Here is an example of RD output when the display format is TABL:
Figure 2. Sample printed output from RD primary command (TABL display format)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Print Browse            SHRIKE2.FMN.LIST                           Top of 8    
 Command ===>                                                       Scroll CSR 
                                    Record AT TOP    Col 2          Format CHAR 
 ---+----10---+----2----+----3----+----4----+----5----+----6----+----7----+----8
****  Top of data  ****                                                         
IBM® File Manager for z/OS®  Db2 Component                                                                                  
EMPNO  FIRSTNME     MIDINIT LASTNAME        WORKDEPT PHONENO HIREDATE   JOB     
CH(6)  VARCHAR(12)  CH(1)   VARCHAR(15)     CH(3)    CH(4)   DATE       CH(8)   
PUN-+> <-N-+----1-> -       <-N-+----1----> <-N      <-->    <---+----> <---+-->
000010 CHRISTINE<   I       HAAS<           A00      3978    1965-01-01 PRES    
FFFFFF CCDCEECDC    C       CCCE            CFF      FFFF    FFFF6FF6FF DDCE4444
000010 389923955    9       8112            100      3978    1965001001 79520000
                                                                                
****  End of data  ****







  F1=Help    F2=Split   F3=Exit    F4=Print   F5=RFind   F6=Purge   F7=Up
  F8=Down    F9=Swap   F10=Left   F11=Right  F12=Cancel
Here is an example of RP output when the display format is SNGL:
Figure 3. Sample printed output from RP primary command (SNGL display format)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Print Browse            SHRIKE2.FMN.LIST                          Top of 24    
 Command ===>                                                       Scroll SCR 
                                    Record AT TOP    Col 2          Format CHAR 
 ---+----10---+----2----+----3----+----4----+----5----+----6----+----7----+----8
****  Top of data  ****                                                         
IBM® File Manager for z/OS®  Db2 Component                                                                                  
Key    Column       Data                                                        
--------------------------------------------------------------------------------
Printed record number - 1                                                   
                                                                            
PUN    EMPNO        000010                                                  
  N    FIRSTNME     CHRISTINE<                                              
       MIDINIT      I                                                       
  N    LASTNAME     HAAS<                                                   
  N    WORKDEPT     A00                                                     
       PHONENO      3978                                                    
       HIREDATE     1965-01-01                                              
       JOB          PRES                                                    
       EDLEVEL          18                                                  
  F1=Help    F2=Split   F3=Exit    F4=Print   F5=RFind   F6=Purge   F7=Up
  F8=Down    F9=Swap   F10=Left   F11=Right  F12=Cancel
Here is an example of RP output when the display format is TABL:
Figure 4. Sample printed output from RP primary command (TABL display format)
  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 Print Browse            SHRIKE2.FMN.LIST                           Top of 5    
 Command ===>                                                       Scroll CSR 
                                    Record AT TOP    Col 2          Format CHAR 
 ---+----10---+----2----+----3----+----4----+----5----+----6----+----7----+----8
****  Top of data  ****                                                         
IBM® File Manager for z/OS®  Db2 Component                                                                                  
EMPNO  FIRSTNME     MIDINIT LASTNAME        WORKDEPT PHONENO HIREDATE   JOB     
CH(6)  VARCHAR(12)  CH(1)   VARCHAR(15)     CH(3)    CH(4)   DATE       CH(8)   
PUN-+> <-N-+----1-> -       <-N-+----1----> <-N      <-->    <---+----> <---+-->
000010 CHRISTINE<   I       HAAS<           A00      3978    1965-01-01 PRES    
****  End of data  ****  










  F1=Help    F2=Split   F3=Exit    F4=Print   F5=RFind   F6=Purge   F7=Up
  F8=Down    F9=Swap   F10=Left   F11=Right  F12=Cancel

Related references