JR31223: ECASE 101629 FIX HAS CHANGED DEFAULT BEHAVIOUR (CORRECTLY), HOWEVER CUSTOMER WAS RELYING ON THIS, REGRESSION ON UPGRADE

APAR status

• Closed as program error.

Error description

• Customer has upgraded from 7.5.1A to 8.01, default behaviour of
  Teradata Multiload stage on parallel canvas when loading char(n)
  values which contain less than n chars has changed due to Ecase
  101629. At 7.5.1A such values were padded with spaces at 8.0.1
  they are now correctly padded with $APT_STRING_PADCHAR which has
  a default of od 0x00.
  
  This change has had a significant impact after upgrade, was
  missed by their regression testing as such affected their go
  live date. They require a change such that the old behaviour can
  be obtained by the use of an envirnment variable.
  

Local fix

• Set $APT_STRING_PADCHAR to 0x20
  

Problem summary

• ****************************************************************
  
  
  USERS AFFECTED:
  ALL
  ****************************************************************
  PROBLEM DESCRIPTION:
  Actual length of CHAR column is given through DSCAPIOP as per
  specific customer request based on the environment variable
  PRESERVE_CHARDATA_LENGTH
  ****************************************************************
  RECOMMENDATION:
  Patch is provided for this customer.
  ****************************************************************
  

Problem conclusion

• The difference of behavior in DSCAsStr()  from 7.5.1 to 8.0.1 is
  due to the
  fix done for ecase 101629 to match with the behavior on server
  canvas.
  As the customer wants back the buggy behavior we have suggested
  an environment variable (but not sure what happens to the
  scenario mentioned in ecase 101629).
  Presently this particular customer needs to turn on the
  environment variable PRESERVE_CHARDATA_LENGTH to TRUE
  and the default behavior will take effect.
  

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 PSY

     UP