Using CA Fast Load for DB2 for z/OS (PFL) how can a column value be initialized when there is no input data or where the input data is to be replaced by a new default value?
The INITIAL parameter can be used alone without DEFAULTIF or CNVERR in situations where there is either no input data or the input data is to be replaced by the new initial value.
The syntax format is as follows:
Note that there are no positional or NULLIF statements for this column name even if input data exists. The INITIAL statement without DEFAULTIF or CNVERR tells PFL to ignore the input data for this particular column.