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)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
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)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
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)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
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)
P rocess O ptions U tilities H elp
──────────────────────────────────────────────────────────────────────────────
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