How to output query results to a dataset in PRF.

book

Article ID: 50276

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Compile/PRF for CICS and TSO CA Report Facility CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Description:

What process is available in PRF to direct query results to a dataset?

Solution:

The PRF PRINT command will facilitate this. Also, you will need to change the online printing option in the System Profile from 'N' to 'Y' to avoid the PRF0747E message that will occur if the System Profile has 'N' set for online printing. Please review the CA Report Facility User Guide under the heading "Printing to a Dataset" for details on supplying the destination dataset information.

Environment

Release:
Component: BIPRF