PI81983: MAP ORACLE DECFLOAT COLUMNS TO SUPPORTED DATATYPE IN IDAA

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Certain numeric columns are being returned via the Oracle DRDA
  Provider to the HLV server as DECFLOAT. DECFLOAT is not a
  supported datatype in IDAA.
  This enhancement will introduce a new HLV server parameter
  which will indicate to automatically MAP all DECFLOAT columns
  defined in HLV Virtual Tables to DOUBLE at run time.
  The Studio will also be enhanced to allow editing of these
  Virtual Tables to allow changing of DECFLOAT columns to
  specify another datatype if the default is not desired.
  In those cases data could be converted to DECIMAL(x,x) or
  CHAR/VARCHAR should it be desired. The SQLEngine will then
  do the necessary conversions and the Studio will generate
  the appropriate load jobs using supported IDAA datatypes.
  Therefore, if DECFLOAT, Studio will always generate DDL using
  a datatype of DOUBLE in IDAA, otherwise it will use the
  specified DATA Type.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
  *                 Loader for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Certain numeric columns are being       *
  *                      returned via the Oracle DRDA Provider   *
  *                      to the HLV server as DECFLOAT.          *
  *                      DECFLOAT is not a supported datatype    *
  *                      in IDAA. This enhancement will          *
  *                      introduce a new HLV server parameter    *
  *                      which will indicate to automatically    *
  *                      MAP all DECFLOAT columns defined in     *
  *                      HLV Virtual Tables to DOUBLE at run     *
  *                      time. The Studio will also be enhanced  *
  *                      to allow editing of these Virtual       *
  *                      Tables to allow changing of DECFLOAT    *
  *                      columns to specify another datatype if  *
  *                      the default is not desired. In those    *
  *                      cases data could be converted to        *
  *                      DECIMAL(x,x) or CHAR/VARCHAR should it  *
  *                      be desired. The SQLEngine will then     *
  *                      do the necessary conversions and the    *
  *                      Studio will generate the appropriate    *
  *                      load jobs using supported IDAA          *
  *                      datatypes. Therefore, if DECFLOAT,      *
  *                      Studio will always generate DDL using   *
  *                      a datatype of DOUBLE in IDAA,           *
  *                      otherwise it will use the specified     *
  *                      DATA Type.                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

•    HLVISIDM
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI49614

     UP17/08/23 P F708

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.