Hi,
We are using RCP and schema files in our etl jobs. I am extracting data from table and loading in file. I am facing 2 issues
1) space is prefixed for decimal values, when i tried to load in file.
Ex: if value is 10.1 in source then " 10.1 in file, one space before value 10.
2) if source data type is number (6,2) and value is 4.2 then output file having files prefix with zero's and appending with zeros
0004.20
Space prefix in decimal value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
Both of those are examples of How It Works with numeric values in a flat file. The space is a place holder for the sign (i.e. where the minus sign would go if it was negative) and the leading zeroes are not significant. I know it's not how you want it to look but neither one should be causing a problem when the file is consumed. Are they actually causing a problem?
Using RCP complicates this as normally one would need to target a string and explicitly reformat the decimal output to your liking.
Using RCP complicates this as normally one would need to target a string and explicitly reformat the decimal output to your liking.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The data ARE the same as in the database. Decimal numbers are stored in some kind of binary or packed decimal format.
It's the presentation layers that are different.
It's the presentation layers that are different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.