PI07915: THE NULLIF CLAUSE IN THE LOAD STATEMENT SPECIFIES AN INCORRECT VALUE WHERE THE EXPECTED X'00' IS REPLACED BY X'0'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The NULL field value specified in the generated LOAD statement
  is incorrect if the value of the NULL indicator field requested
  for NULL values contains binary zeroes (i.e. x'00').
  
  In such a case the NULLIF clause in the LOAD statement specifies
  an incorrect value where the expected x'00' is replaced by X'0'.
  
  For example
  if OPTIONS NULL X'00' X'FF'  is specified ,
  the NULLIF clause in the LOAD statement is the following
    NULLIF(  nn ) = X'0'
    where  NULLIF(   nn ) = X'00' is expected.
  
  PB12095
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The NULL field value specified in the   *
  *                      generated LOAD statement is incorrect   *
  *                      if the value of the NULL indicator      *
  *                      field requested for NULL values         *
  *                      contains binary zeroes (i.e. x'00').    *
  *                      In such a case the NULLIF clause in     *
  *                      the LOAD statement specify  an          *
  *                      incorrect value where the expected      *
  *                      x'00' is replaced by X'0'.              *
  *                      For example, if OPTIONS NULL X'00'      *
  *                      X'FF'  is specified , the NULLIF        *
  *                      clause in the LOAD statement is         *
  *                      NULLIF(  nn ) = X'0' where              *
  *                      NULLIF(   nn ) = X'00' is expected.     *
  *                      PB 12095                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload module was fixed.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    INZTDSC  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UI14568

     UP14/02/01 P F401

• R420 PSY UI14569

     UP14/02/01 P F401

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.