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

Loading the TABLE


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

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Mon Sep 08, 2008 4:08 pm
Reply with quote

Hi,
I have added a new column[DECIMAL(10,2) , NOT NULL] to a table.
Now i have to load the table using the unload file. The unload file doesn't have the data for the newly added column. Since the newly added column happens to be a not null. The data is not getting loaded into the TABLE.

Iam using FASTLOAD to load the table.

Is there a way to add a constant value like 7 to the newly added column while loading the table for all the records.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Mon Sep 08, 2008 5:52 pm
Reply with quote

Sushanth,
You can check this out.

ibmmainframes.com/about27012.html
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 Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top