CFF conversion issue

dsrules · Post by **dsrules** » Mon Jan 17, 2005 2:22 pm

Hi,
I am using CFF stage to view data downloaded from mainframe. Everything looks right except the decimal columns have .. rather than a single . separating the scale and number.
Any help is appreciated.
Thanks
dsrules

ArndW · Post by **ArndW** » Mon Jan 17, 2005 2:39 pm

dsrules - what is the Cobol PICture for the column?

dsrules · Post by **dsrules** » Mon Jan 17, 2005 3:56 pm

ArndW,
I fixed it :D . The error was the Meta data was s9(10)v99 but in the mainframe they were explicitly signed. I got them onto DataStage using pic x(12) then loaded them into sequential file as decimal. This works fine. Please let me know if I am doing a right thing.
Thanks
dsrules

ray.wurlod · Post by **ray.wurlod** » Mon Jan 17, 2005 8:38 pm

Murphy's fourth postulate:

If it's stupid but it works, it's not stupid.

Your technique is entirely valid in server jobs, because the Engine does not use data types - everything is a string with implicit conversion governed by context (for example arithmetic). This helps DataStage to be tolerant of data type mismatches.