Datatype conversion error handling in LTM for MVS

LTM for MVS responds to datatype conversion errors differently depending on the values of several LTM for MVS configuration parameters. Table 2-3 describes the actions LTM for MVS performs depending on the types of datatype conversion errors and the values of specific LTM for MVS configuration parameters.

Table 2-3: Conversion errors and LTM for MVS parameters

Error converting:

LTM for MVS configuration parameter settings

date, time, or timestamp data

The system performs the following action, depending on the value specified for the LTM for MVS DateTime_conv_err configuration parameter:

  • DateTime_conv_err=Null Substitutes nulls in columns encountering errors. Make sure the affected columns allow nulls.

  • DateTime_conv_err=Default If LTM for MVS encounters an error in a date column, it supplies the value you specified for Date_conv_default.

  • DateTime_conv_err=Datetime If the LTM for MVS encounters an error in a date column, it supplies the value you specified for Date_conv_default and the value you specified for the Time_conv_default.