search cancel

Replace existing INFOTEL unload tool

book

Article ID: 255495

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

Currently the Infotel tool is used for LOAD and UNLOAD.Infotel is used to unload data from views with delimiters. Can this be done by the CA DB2 tools in place of the Infotel tool to unload data from views with delimiters.

Environment

Release : 20.0

Resolution


Use the CA DB2 Tools component Fast Unload/Fast load for this.
To unload data from views with delimiters.

With parms like this.

UNLOAD
SQL-ACCESS     EXTENSION
SHRLEVEL       IGNORE
OUTDDN         SYSREC00
LOADDDN        SYSPUNCH
OUTPUT-FORMAT  COMMA-DELIMITED
COMMA          X'11'
DECIMAL-POINT  '.'
SELECT * FROM <VIEW NAME>;



Fast /Unload documentation