JR32340: ORACLE EE STAGE IS NOT IMPLICITLY CONVERTING COLUMNS NAMES WITH $

APAR status

• Closed as program error.

Error description

• The Oracle Enterprise stage is not implicitly converting
  the
  column names with dollar symbol into the internal name with
  __036
  literal.
  The Tables with the column names having $ symbol are not getting
  loaded.
  .
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  all users of 801 release
  ****************************************************************
  PROBLEM DESCRIPTION:
  Column names containing characters $ and # are not implicitly
  converted to valid PX identifiers
  ****************************************************************
  RECOMMENDATION:
  apply patch
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• there was a logic error in handling column names which assumed
  they are always legal px identifier. A $ or # in column name is
  a special case and we need to convert them. The conversion
  method is not being called.  This is rectified.
  

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:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP