Converting Numeric into Pic Comp3 data type

[Alagusakthivelan]

Hi,

we are having a migration program where we are getting some data from MAINFRAMES and we have to load it back to MAINFRAMES again.

here we have a requirement where we have to convert Comp3 datatype to Numeric and again Convert that numeric value to Comp3 datatype.

But in DataStage 7.1 we have option for Comp3 to Numeric type convertion, but reverse function is not available, could you help us in this regard..

Thanks in advance,
sakthi

[chulett]

You either need to look at the sdk routine you mentioned and write your own version that goes 'backwards' or use the CFF (Complex Flat File) stage to write out the file.

I'm guessing there will also be an EBCDIC requirement you'll need to handle and the CFF stage will do that as well, from what I recall.

[Alagusakthivelan]

Hi Chulett,

Thank you very much for ur suggestion.

But the CFF stage can be used for reading purpose only, it wont allow to write into it.

"DataTypePicComp3(%CobolString%)" this sdk routine converts Comp3 data type into a numeric value, what we need is reverse process, could you send me a suggestion on how to approach that process.

Thanks

Sakthi

[ArndW]

I'm not at a DataStage machine right now, but think that the SDK has such a routine in there or at some time did have one. Making a COMP-3 out of an integer is not difficult, just a couple of lines of code in BASIC and use of the OCONV function and the "MB" conversion.

[chulett]

But the CFF stage can be used for reading purpose only, it wont allow to write into it.

Really? Can you tell I don't use it?

That's too bad.

[dls]

I would opt to do the reformatting (i.e., packed decimal --> display decimal, and vice versa) on the mainframe platform.

Is that an option for you?