JR44874: DECIMAL BECOME UNSIGNED AND PACKED DECIMAL AFTER IMPORTED VIA ORCHESTRATE

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• Decimal become unsigned and packed decimal, also prefix=2 for
  varchar field after imported via orchestrate in Table definition
  -> Layout -> Parallel
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Use of Orchestrate table definition importer in DataStage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Having imported an Orchestrate table definition into DataStage,
  when looking at the table definition properties layout page,
  with the Parallel view displayed, we see properties for "packed
  decimal" also "prefix=2" in the schema for some of the fields.
  ****************************************************************
  RECOMMENDATION:
  Install APAR JR44874
  ****************************************************************
  

Problem conclusion

• Install APAR JR44874
  

Temporary fix

• N/A
  

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

• R870 PSY

     UP