DB2 Load doubt

IBM's flagship relational database management system

DB2 Load doubt

Postby Prasanna G » Thu May 23, 2013 6:49 pm


I need a small clarification.
There is a change to DB2 table structure to include 1 new column of decimal type at the end which can have the value zero.
If I try to use a load file which does not have the new column with all other column values intact, for loading, will the load job fail or will it be successful?
Please let me know if I am not clear with my query.

Note: BMC utility is used for loading the table

Prasanna G.
User avatar
Prasanna G
Posts: 71
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time

Re: DB2 Load doubt

Postby dick scherrer » Fri May 24, 2013 12:22 am


Suggest you run a test with your actual ta ble(s) and data. Then you will knkow what will specifically happen on your system.

If there are any surprises, post back here and someone should be here shortly.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post