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

Extract records from DB2 and upload to another server


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vijendra.23

New User


Joined: 06 Apr 2007
Posts: 3
Location: bangalore

PostPosted: Sun May 20, 2007 9:25 pm
Reply with quote

Can anyone tell me how to extract records from DB2 and upload to another server?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue May 22, 2007 3:53 am
Reply with quote

Hello,

Is the "other server" another IBM mainframe? If not, you need to create records that have no comp or comp-3 fields by expanding them to edited-decimal data (include an explicit decimal point and the minus sign (for negative values).

Transfer the file and import ito on the target by whatever method you have chosen on the target.
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 -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
Search our Forums:

Back to Top