Hi
Can we find whether the field is having all zeros/spaces?. I need to write default value if the field is with zeros/spaces.
All zeros
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
InLink.TheString = Convert("0", "", InLink.TheString)
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.
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
EBCDIC '0C' is packed decimal +0, a rather common thing in many mainframe data repositories. Data attributes that include an explicit sign often require +0 as the default value. This is true in Cobol standards (when they are followed).ray.wurlod wrote:A signed zero is a very unusual thing.
Of course, unsigned zeroes are often just undiscovered. The NBA is always looking for them. ("0" or "00" being a common number for centers.)
![Razz :P](./images/smilies/icon_razz.gif)
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