UNLOAD JCL to Unload a DB2 File to a Flat File

book

Article ID: 18258

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description:

Currently running jobs with File Aid DB2 to unload a DB2 file to a flat file. What facility is available in RC/Query to perform the samefunction? RC/Query has the UNLOAD line command.

Solution:

Request a T/L (Table / List) report and then issue the UNLOAD line command on the table that you want to unload.

Based on the setting in your RC/Query Profile, it will determine if the Fast Unload product is used or if the IBM Unload utility will be used.

The appropriate utility screen will display and you will just need to complete the information and then process the request.

Environment

Release:
Component: RCQ