JR32447: WARNING MESSAGE WHEN UPDATING A NULL FROM INT8,INT16 INTO SMALLINT,BIGINT NETEZZA COLUMNS.

APAR status

• Closed as program error.

Error description

• Warning message when updating a NULL from
  int8,int16,int64,uint8,uint32,uint64 into a
  smallint,bigint,byteint Netezza columns.
  
  Netezza_Enterprise_3: When checking operator: When validating
  export schema: At field "SMALLINT_TEST": "null_field" length (1)
  must match field's fixed width (6).
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 8.0.1 FP1 , Netezza EE Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  WARNING MESSAGE WHEN UPDATING A NULL FROM INT8,INT16 INTO
  SMALLINT,BIGINT NETEZZA COLUMNS
  ****************************************************************
  RECOMMENDATION:
  Patch has to be installed.
  The fix has been included in the IS 8.1 FP1. Apply FP1 for IS
  8.1.
  ****************************************************************
  

Problem conclusion

• Code Fixed.
  

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

• NZEE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP