When writing data to decimal fields with a parallel job the value is preceded by a space and ends with a '.'.
The second field is SQL Type: Decimal, Length: 3, Scale: 0
"B", 000.,"000"
What would cause this behavior?
Decimal fields with a space and a .
Moderators: chulett, rschirm, roy
It's important to know if this is how it's displayed in View Data or how it's stored in the file when browsed or edited in NotePad or another text editor.
The displayed number will have two positions reserved, one for the sign and one for the decimal. Check your output format in the table definition, and perhaps edit the number to remove the space and decimal.
The displayed number will have two positions reserved, one for the sign and one for the decimal. Check your output format in the table definition, and perhaps edit the number to remove the space and decimal.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872