JR34982: Special characters # and $ not preserved in imported Oracle tabl e definition

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Table name contains a dollar character ($). The table is
  imported using Oracle OCI plug-in (ORAOCI9).
  The imported table name replaces the $ character with the
  __036__ sequence of characters.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DataStage users who are using Oracle OCI Plug-in (ORAOCI9) to
  import table definitions.
  ****************************************************************
  PROBLEM DESCRIPTION:
  The import of table definitions with Oracle OCI Plug-in
  (ORAOCI9) converts # and $ characters in Oracle table names to
  __035__ and __036__ sequences of characters, respectively. The
  same conversion happens for Oracle column
  names which contain # and $ special characters.
  
  The coversion happens even if the DataStage environment variable
  DS_ENABLE_RESERVED_CHAR_CONVERT is set to value False.
  
  ****************************************************************
  RECOMMENDATION:
  Install patch JR34982.
  ****************************************************************
  

Problem conclusion

• The fix was implemented in the plug-in to force it to behave in
  accordance with the value specified in the
  DS_ENABLE_RESERVED_CHAR_CONVERT environment variable.
  
  When this environment variable is set to False (the default
  setting), then the plug-in will not convert # and $ to __035__
  and __036__ when importing Oracle column names. Otherwise, when
  it is set to True, the plug-in will perform the conversion.
  
  Regardless of the DS_ENABLE_RESERVED_CHAR_CONVERT value, the
  plug-in will not convert # and $ characters in Oracle table
  names. To perform this conversion, it will be necessary to
  define a new special User-defined environment variable in the
  DataStage project. The name of this environment variable is
  DS_ENABLE_RESERVED_CHAR_CONVERT_TABLE. The type of the
  environment variable should be String.
  
  When DS_ENABLE_RESERVED_CHAR_CONVERT_TABLE is not defined (the
  default behavior) or defined but set to value 0 or False
  (case-sensitive), the plug-in will not convert # and $ in the
  imported Oracle table names. Otherwise, when defined and set to
  any value other than 0 or False, the plug-in will convert # and
  $ characters to __035__ and __036__ character sequences in the
  imported Oracle table names.
  

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

• R810 PSN

     UP