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

Document ID : KB000025229
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

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?

 

Answer:

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.