IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

Active User

Joined: 31 Mar 2010
Posts: 134
Location: India

PostPosted: Mon Feb 15, 2016 2:30 pm
Reply with quote


We are using FAST UNLOAD for unloading the data from tables. UNLOAD card is having OUTPUT-FORMAT DSNTIAUL. Could anybody please help us to know what should be the INPUT-FORMAT while using the FASTLOAD.

Out FASTLOADs are failing either with

1) Saying Column data type conversion issue
2) or Records are getting discarded.

It will be of great help fi anybody can share the inputs here
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator

Joined: 21 Sep 2010
Posts: 2573
Location: NYC,USA

PostPosted: Tue Feb 16, 2016 9:48 pm
Reply with quote

This is what it say's. Did you follow ?
PFL INPUT-FORMAT UNLOAD is compatible with CA Fast Unload for DB2 for z/OS (PFU) where OUTPUT-FORMAT LOAD was specified during the unload. If PFU was executed with a different OUTPUT-FORMAT then use INPUT-FORMAT SEQ on the PFL execution.

The source table OBID is written into the unload file during the PFU unload process when OUTPUT-FORMAT LOAD is specified.
To ensure data integrity, PFL verifies that the OBID in the input file is the same as the target table to be loaded. If the source and target tables do not have the same OBID, then the OBID parm may be used during the PFL execution to specify the source table OBID present in the input file.

The source and target table DDL must be identical, data conversion is not allowed with INPUT-FORMAT UNLOAD.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2


Similar Topics
Topic Forum Replies
No new posts Job is loading load modules several t... COBOL Programming 12
No new posts Unload Report in ARCHIVE from CA-Disp... CA Products 0
This topic is locked: you cannot edit posts or make replies. issue with Syntax error SYNCSORT 2
No new posts Issue while fetching a column(Nullabl... DB2 18
No new posts Need help on DB2 load in Mainframe DB2 5
Search our Forums:

Back to Top