Previous Topic: Sample Problem - 2Next Topic: Generated DSV Output


Generated Report

Report generated:

MUF_NAME DATE DBID PHYS_IO LOGIC_IO ________ __________ ______ ____________ _________________________________ MUFS 2006-06-21 0 12058 30387 MUFS 2006-06-21 1 69 5243 MUFS 2006-06-21 2 205160 1427715 MUFS 2006-06-21 6 0 28 MUFS 2006-06-21 15 2250 9847 MUFS 2006-06-21 17 0 6 MUFS 2006-06-21 1000 0 0 MUFS 2006-06-21 1006 4 4 MUFS 2006-06-21 1019 72 2217 MUFS 2006-06-21 1020 4 4 MUFS 2006-06-21 9999 219617 1475451 MUFS 2006-06-22 0 11838 28470 MUFS 2006-06-22 1 74 5646 MUFS 2006-06-22 2 173086 1583870 MUFS 2006-06-22 6 0 19 MUFS 2006-06-22 15 640 1898 MUFS 2006-06-22 17 0 6 …. …. …. MUFS 2006-06-28 15 1119 4080 MUFS 2006-06-28 17 0 33 MUFS 2006-06-28 1000 0 0 MUFS 2006-06-28 1006 4 4 MUFS 2006-06-28 1019 33 1398 MUFS 2006-06-28 1020 137 15453 MUFS 2006-06-28 9999 5984 39301 ___ 43 rows returned ___

Using DBSQLPR with DSV output parameters to re-execute the query to generate a DSV file.

STDOUT directed to DSN  (//STDOUT DD DSN=seq.file,DISP=(NEW,CATLG),…

Processing Options
       
AUTHID=SYSADM              
AUTHID=SYSADM              
SQLMODE=DATACOM            
WORKSPACE=128              
PRTWIDTH=1500        
NOECHO                     
NOFORMFEED                 
PAGELEN=999999999          
NOTYPE                     
DATASEPARATOR=;