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

DB2 UNLOAD and LOAD for changed table


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

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Tue May 28, 2013 9:31 pm
Reply with quote

Hi All-

I have table A which has changed in structure(columns added etc).

Now I take a old image copy of A and need to have the data loaded. When I try to do UNLOAD(to have the imagecopy structuredinto the table format) it gives me an error saying the structure doesnt match. Any suggestions on this? Unless I have the data structured I cant run a LOAD.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue May 28, 2013 11:33 pm
Reply with quote

Hello,

Quote:
it gives me an error saying the structure doesnt match
Because they don't.

You need to have the "old" definition available . . .
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 Error while fetching the record from ... COBOL Programming 3
No new posts compare two file to find position/dat... SYNCSORT 2
No new posts Need to read duplicate rows from tabl... DB2 3
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
Search our Forums:

Back to Top