JR52769: ADD A NEW ENVIRONMENT VARIABLE TO SUPPRESS SCIENTIFIC NOTATION IN UNSTRUCTURED DATA STAGE

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as suggestion for future release.

Error description

• Need to implement a new environment variable to suppress
  scientific notation when extracting any numeric values from
  Microsoft Excel cells using the Unstructured Data stage with RCP
  enabled.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• Provided a new environment variable
  CC_UNST_SUPPRESS_SCIENTIFIC_NOTATION. If it is set to 1 in the
  DataStage job, the Unstructured Data stage extracts any numeric
  cell values from Excel files and converts numeric values in the
  form of Scientific Notation to a conventional decimal form for
  the target DataStage columns with string type.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels