How to output query results to a dataset in PRF.

Products

• RC Compare for DB2 for z/OS
• Report Facility
• Database Analyzer for DB2 for z/OS
• Fast Unload for DB2 for z/OS
• Fast Check for DB2 for z/OS
• Fast Index for DB2 for z/OS
• 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