All Forums UDA
Koentje 23 posts Joined 09/04
02 Jun 2006
Unloads from DB2 (nullable fields) - How to manage this with Fastload?

When unloading nullable data from DB2,you receive always two fields.Field one = ValueField two = Indicator if the field is null or not.Can you use fastload (eg. decimals) without creating two fields in your table?Can you load immediately as a nullable field by using nullif?For character fields you can write in the define statement things like ,ZA0102_ASFV_DT (CHAR(10), nullif='00000000000000000000'xc)How to do this for integer of decimal types?

Jim Chapman 449 posts Joined 09/04
05 Jun 2006

The NULLIF method doesn't work for numeric data types. To capture null values properly, you will need to convert your data to the kTeradata indicator format.

You must sign in to leave a comment.