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