JR58272: SUPPORT UNIVARCHAR/UNICHAR DATATYPES FOR SYBASE ASE IN SYBASE ENTERPRISE STAGE.

APAR status

• Closed as program error.

Error description

• In Sybase Enterprise stage add support to read/write to Sybase
  ASE containing univarchar/unichar datatype.
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using Sybase Operator to read/write from Sybase ASE using
  datatype unichar / univarchar
  ****************************************************************
  PROBLEM DESCRIPTION:
  Support for use of unichar / univarchar datatypes in Sybase
  Operator for Sybase ASE
  ****************************************************************
  RECOMMENDATION:
  Apply the patch to use the tables containing unichar /
  univarchar in Sybase ASE.
  
  ****************************************************************
  

Problem conclusion

• No new datatypes have been added to stage properties.
  
  When there are unichar/univarchar columns, they need to be
  mapped to either char with Unicode, NChar, Varchar with Unicode,
  NVarchar.
  
   ASERead -->
   1.sybase datatype unichar can be mapped to Char with Unicode or
  NChar
   2.sybase datatype univarchar can be mapped to Varchar with
  Unicode or NVarchar
  
   ASEWrite -->
   1. sybase datatype unichar can be mapped to Char with Unicode
  or NChar
   2. sybase datatype univarchar can be mapped to Varchar with
  Unicode or NVarchar
  
   ASEUpsert -->
   1. sybase datatype unichar can be mapped to char and length
  shouldn't be specified
   2. sybase datatype univarchar can be mapped to varchar and
  length shouldn't be specified
  
   Unicode characters can be read from and inserted to tables
  containing unichar/univarchar datatypes. However we cannot
  create new tables from Sybase EE with unichar/univarchar
  columns.
  
   In case of ASE Upsert, the Unicode characters can only be
  inserted based on the Sybase server charset and locale that is
  available.
   For example, Japanese characters can be inserted from Sybase EE
  stage only if the corresponding charset is available on the
  Sybase server.
  

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

• RB31 PSY

     UP

• RB50 PSY

     UP