Handling spaces in Packed Decimal fields

[vrsraju]

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

[ArndW]

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.

[vrsraju]

Can you please advice me how to specify the default value attribute in the Complex Flat File?
Thanks
vrsraju

[ArndW]

In the CFF stage, right-mouse click on the column name and then choose the option "edit row", the rest follows from there.

[vrsraju]

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

[ray.wurlod]

I don't understand how spaces are even possible in packed decimal representation!

[ArndW]

Ray - as you rightly point out, spaces cannot be in a packed decimal field.

[landaghaar]

I have the same problem and yes those fields have ebcidic 40404040 value in there.

[landaghaar]

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.