|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/15/2008 9:47:49 AM
Posts: 8,
Visits: 10
|
|
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?
AXA Belgium
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 7:10:35 PM
Posts: 224,
Visits: 527
|
|
|
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.
|
|
|
|