Handling spaces in Packed Decimal fields
Moderators: chulett, rschirm, roy
Handling spaces in Packed Decimal fields
Hi
I am getting spaces in the packed decimal field. I have to convert to either NULL or Zero when I get spaces in that field. Data Type is PIC 9(7)V9(2) COMP-3. Is there any option which would handle that conversion in CFF stage. If not, is there any other place I can do that conversion.
Thanks and Rgds
vrsraju
I am getting spaces in the packed decimal field. I have to convert to either NULL or Zero when I get spaces in that field. Data Type is PIC 9(7)V9(2) COMP-3. Is there any option which would handle that conversion in CFF stage. If not, is there any other place I can do that conversion.
Thanks and Rgds
vrsraju
Have you tried the default value attribute - since spaces don't equate to a valid value it should use whatever setting you specify for the default value for that column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
In the CFF stage, right-mouse click on the column name and then choose the option "edit row", the rest follows from there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Thanks for your help. I can see lot of other options. But I didn't find any option to set a default value. Can you please give me the name of the option to set the default value. Thanks a lot for your help.ArndW wrote:In the CFF stage, right-mouse click on the column name and then choose the option "edit row", the rest follows from there. ...
vrsraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray - as you rightly point out, spaces cannot be in a packed decimal field.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada