Handling NULL indicator in DB2 Unload.

[Binamra]

While unloading a table im Using two columns value and multiplying it and assigning to receiving table table columns which is decimal(15,2) not null.. but in the unload file it is adding one more byte in the last for null indicator.

So one byte is moving right and while loading the table using that file it fails.

Can some one help how to avoid this one byte for null indicator in the unload file

[ Post made via Android ]

[Anuj Dhawan]

Hi,

From memory, I recall that - once you unload the table, you should get a SYSPUNCH dataset. It should give you the 'load card' using in that. The unload dataset will have the data as per the 'definition' in SYSPUNCH dataset - with all this you should be good to go.

OR COALESCE should help you. Give that too a try.

[singhxmanish]

One way could be to use DFSORT to eliminate the null after the field (in unload file) and structuring the data as per table to be loaded. Since the null is placed after the field I assume you used DSNTIAUL and null would be stored as ? Or X’6F’

[Binamra]

One way could be to use DFSORT to eliminate the null after the field (in unload file) and structuring the data as per table to be loaded. Since the null is placed after the field I assume you used DSNTIAUL and null would be stored as ? Or X’6F’

Thanks but that will require one more step. I was looking for way which can be handled by DB2 itself.

[nicc]

I was looking for way which can be handled by DB2 itself.

Why did you not say so in the first place?

[Binamra]

I did not mean to say that it was required for me, I was just trying to make it clear that it would take one extra step.