Unloads from DB2 (nullable fields) - How to manage this with Fastload?

UDA
Enthusiast

Unloads from DB2 (nullable fields) - How to manage this with Fastload?

When unloading nullable data from DB2,
you receive always two fields.
Field one = Value
Field 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?

1 REPLY
Enthusiast

Re: Unloads from DB2 (nullable fields) - How to manage this with Fastload?

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.