We are doing migration from sybase to db2 9.7. There is a smallint col in sybase with default "0" . While taking unload for a null value there is no value present in the output instead only delimiter is coming. In Db2 for this null value it has inserted "0" instead of inserting value "NULL". I want the same "NULL" value inserted into DB2. Can anyone suggest me how to take unload for null value and insert the same null value in db2.
Pinned topic IDMT Null handling - problem
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2011-11-23T16:31:19Z at 2011-11-23T16:31:19Z by SystemAdmin
SystemAdmin 110000D4XK708 Posts
Re: IDMT Null handling - problem2011-11-23T16:31:19ZThis is the accepted answer. This is the accepted answer.
- Sivagamigurusamy 060000UTD3
Can you please drop the default constraint in DB2 and try load again?