JR34323: ORACLE ENTERPRISE STAGE: UNEXPECTED SPACES PADDED WHEN SELECTING LITERAL STRING THEN PUTTING IT IN VARCHAR COLUMN

APAR status

• Closed as program error.

Error description

• When extracting constant string from Oracle, trailing spaces as
  many as the constant string are padded.
  
  For example, if we run the query
  select 'abcdefgh' Constant_string
  from tableX
  , and receive the result set in SQL Type VarChar and length
  20 column of Oracle Enterprise stage, the result becomes
  'abcdefgh........'
  (dot means space, i.e., the result is 'abcdefgh' plus 8 spaces)
  

Local fix

• Specify same column length to that of the constant literal
  string in Columns tab.
  
  This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  NLS users.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When extracting constant string from Oracle, trailing spaces
  (as many as the constant string) are padded.
  ****************************************************************
  RECOMMENDATION:
  apply patch provided.
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• The use_strings option causes column length to expand when the
  client character set has expansion factor > 1
  The resolution is to read the column as a variable length
  stringwhen the following conditions are satisfied.
  
         1.  Column's Oracle data type is CHAR
        2.  The -use_strings option is in use
       3.  The client character set has expansion factor > 1
  
  We will then be reading a CHAR(N) column as if it were
  VARCAR2(N) column.
  

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSN

     UP