Issue while handling Decimal Fields in CFF Stage

[DSFreddie]

Hi All,

I have a CFF stage as Target for my DataStage Parallel Job.
We create this file, transmit it to MF system to do a comparison.

However, when the files are NDM'd to the Source MF system, the '.' symbol of the decimal values are getting truncated due to which the comparison fails.

For e.g: a decimal field 100.01 when it goes to MF system changes to 10001.

We are using Generic UNIX script to NDM the files from UNIX system to MF system.

Any help will be appreciated.

Thanks,
Freddie

[ray.wurlod]

Could it be that the mainframe expects "masked decimals" in which the metadata (for example PIC 9999V99) tells it where the decimal placeholder needs to be?

[DSFreddie]

Hi Ray,

Thanks for your response.

To answer your point, mainframe is not expecting "masked decimals".

Let me put it this way,

We have a field A with datatype PIC -9(15).99.While it goes to MF system, the '.' gets truncated.

We have defined this field as CHAR(19). Is there anyother way we can define this field ?
I am trying the various options in the column metadata like Sign Indicator/Sign Option etc.

Any guidance will be much appreciated.

Thanks,
Freddie

[FranklinE]

Freddie,

What is the table definition for your "Field A" in each stage up to and including CFF? Is it numeric, decimal or something else?

In general, a PIC 9() field is decimal in DataStage, and if you want to move it as a display field you might be missing a DecimalToString() transform. That might make the decimal point character disappear.

I might be asking the wrong question, but it's the only one that comes to mind.

[ds_teg]

if you have the copy books ..import those table definitions and see if you have given it correctly in CFF