DSXchange

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.

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

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

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 don't understand how spaces are even possible in packed decimal representation!

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

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

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.