JR37597: DB2 ENTERPRISE STAGE GIVES ERROR FATAL: MAIN_PROGRAM: REAL : THIS TYPE IS NOT SUPPORTED.

APAR status

• Closed as program error.

Error description

• DB2 Enterprise stage gives error
  Fatal:  main_program: REAL    : this type is not supported
  when writing a column type REAL to a DPF DB2 table.
  

Local fix

• Use column type DOUBLE
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 Enterprise Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2 Enterprise Stage job returns "REAL: this type is not
  supported"  error when target DB2 database is DPF and REAL data
  type is defined as a partitioning key.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch for JR37597.
  ****************************************************************
  

Problem conclusion

• Checking REAL data type was missing from DB2 partitioner. It
  should be mapped to SQL_TYP_FLOAT during partitioning key
  processing.
  

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

• PXDB2
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP