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
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.
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. ...
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.
vrsraju
I just browsed through other posts and found my answer.
If anyone still has this issue, just add a default property to the decimal field and make it default to 0 or 999999999 or whatever you wish.