How to initialize a column with a specific value during a Fast Load execution

Products

• Fast Load for DB2 for z/OS

Issue/Introduction

Using 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?

Resolution

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:
column_name INITIAL(value)

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.