UNLOAD JCL to Unload a DB2 File to a Flat File

book

Article ID: 18258

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 Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector 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