Recently I built a Datastage job using Unstructured stage to read data from an Excel file into a Database table.
I read all columns as Varchar. Excel automatically puts large numeric values into scientific notation.
The Unstructured stage read these values as it is with the E+ Notation. To resolve this, we had to set an Environment variable CC_UNST_SUPPRESS_SCIENTIFIC_NOTATION to 1.
Value in Output - 159255666445850
Tags
Datastage
Interesting. Did not think of this scenario. Thank you for posting.
ReplyDeleteI am very new to datastage could you elaborate more on how to add that environment variable? It does not automatically appear in the list of environment variables
ReplyDeleteTry to add it directly to job parameters by just typing the environment variable name and set its value.
DeleteYou can just type in $CC_UNST_SUPPRESS_SCIENTIFIC_NOTATION and put its value as 1.
Delete