There are many options and a good answer can only be provided with a bit more info... What is the sqlcode from db2? fail is a bit too generic... What tools do you use? Import, load, direct insert / select with federated data source? If you use a file to transport the data, then how does the file represent the null?