Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FAST UNLOAD and LOAD issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
GaganGarg

Active User


Joined: 31 Mar 2010
Posts: 132
Location: India

PostPosted: Mon Feb 15, 2016 2:30 pm    Post subject: FAST UNLOAD and LOAD issue
Reply with quote

Hi,

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

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

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

This is what it say's. Did you follow ?
Code:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us