If you specify the SELECT function with the OUTPUT=PRINTER parameter, the number of rows selected is displayed on the console as shown in Figure 132.
Figure 132. Console Messages for SELECT with the OUTPUT=PRINTER Parameter
XTS9-143 CONTROL DBAPW=******** DBNAME=dbname
XTS9-143 SELECT TNAME=CUSTOMER CREATOR=SQLDBA
XTS9-100 Data Restore feature VERSION 7.1.0
XTS9-309 Processing DB2 Server for VSE & VM version 7
XTS9-152 3 ROWS SELECTED
XTS9-007 PROCESSING SUCCESSFULLY COMPLETED
Data Restore displays the result on SYSPRINT/SYSLST. Question marks (?) represent NULL columns as shown in Figure 133.
Figure 133. Report for SELECT with OUTPUT=PRINTER Parameter
TNAME=CUSTOMERS
COLNO 001 CNAME "CUST_NO"
COLNO 002 CNAME "CUST_NAME"
COLNO 003 CNAME "CUST_ADDRESS"
COLNO 004 CNAME "CUST_POSTCODE"
COLNO 005 CNAME "CUST_TEL"
**********************************************************************************
1 * 2 * 3 * 4 * 5
**********************************************************************************
105725*DUPONT PIERRE *33 AV DES CHAMPS ELYSEES *75008*44-40-41-42
309001*MARTIN PAUL *1 RUE DE LA PAIX *93001*37-37-10-12
25018 *DURAND JACQUES *???????????????????????????????????*75009*40-32-10-24
**********************************************************************************
After a SELECT function with the OUTPUT=TAPE or the OUTPUT=DASD parameter, the number of rows selected is displayed on the console as shown in Figure 134.
Figure 134. Console Messages for SELECT with OUTPUT=DASD Parameter
XTS9-143 OPTIONS OUTPUT=DASD XTS9-143 CONTROL DBAPW=******** DBNAME=dbname XTS9-143 SELECT TNAME=CUSTOMER CREATOR=SQLDBA XTS9-143 /* XTS9-100 Data Restore feature VERSION 7.1.0 XTS9-309 Processing DB2 Server for VSE & VM version 7 XTS9-152 3 ROWS SELECTED XTS9-007 PROCESSING SUCCESSFULLY COMPLETED |
Data Restore writes the data to tape or DASD and displays the column's position on the PRINTER as shown in Figure 135.
Figure 135. List Displayed for SELECT with OUTPUT=DASD Parameter
"CUST_NO" 007-010 FIXED
"CUST_NAME" 013-032 CHARACTER
"CUST_ADDRESS" 035-066 NULL IF POS(33)=255 CHARACTER
"CUST_POSTCODE" 069-073 NULL IF POS(67)=255 CHARACTER
"CUST_TEL" 076-085 NULL IF POS(74)=255 CHARACTER