DSXchange

Hi Guys,


I have a requirement to convert decimal values to comp3 and send them to mainframes, i browsed through and couldnt find the solution any where there are previous topics on this but nothing got resolved in them ,

Can anyone please help me if they have done the same thing earlier it would me very helpful to me.


Thanks
Raj

Hi Guys,

Can anyone share their experience in this issue.



Thanks
Raj

If you just pass the decimal into comp-3 field in the mainframe table, what error does it give?

Hi,

In my case i just need to give a feed to mainframes in a sequential file from our datawarehouse.So i need to convert this from a decimal to comp3 and give that value in a sequential file.


Thanks
Raj

Krazykoolrohit wrote:If you just pass the decimal into comp-3 field in the mainframe table, what error does it give?

can you post an example for the conversion? your decimal value and the corresponding COMP3 value you expect it to get.

Typical flat file interfaces don't put the onus of COMP-3 creation on the file creator. If I was in your shoes I'd push back on the requirement, insist on sending everything in 'display' format and put the burden of the COMP-3 conversion back on the target system where it is fairly trivial for them to do.

I agree that you should push back.
But if you do have to create COMP-3, it's not really that bad (I've done it).

Let us know.

Carter

Hi Carter,

Thanks a lot for your reply, Can you please help me out in this .I am desperatley looking for this solution,your response is highly appreciated.


Thanks
Raj.

clshore wrote:I agree that you should push back.
But if you do have to create COMP-3, it's not really that bad (I've done it).

Let us know.

Carter

Hi

You may start with the DataTypePicComp3 routine in routine/sdk/data type.
It convert comp-3 to integer but it will be a start.

I have a requirement to create COMP3 fields in a DataStage Server job. The files need to be sent to the mainframe for processing.

Is there a way to create a COMP3 field in a server job, then transmit it to the mainframe? It sounds like its possible base on the dsxchange entry but I cant figure how its done.

These decimal fields, are they signed. I mean, do you need to convert them to PicS9 or just comp3?

Hi
Do you try to write in a CFF stage ?
I don't do it myself but maybe it will transfrom your data to the copybook format.

I tried this but the CFF stage does not support Stream Input links. It appears that is only accepts output links (reads data ).

Does anyone have any other suggestions, other than creating mainframe programs to pack data.

You can probably write a routine. But is it just comp3 or signed decimal (PicS9)?

I will need to convert several numeric data types. My target is the mainframe. I will be creating files using DataStage server for use on an IBM mainframe.

That means I would need the ability to conver numbers to:
PIC S9(9)V99.
PIC S9(9)V99 COMP3.

And others possibly.

In the end the file needs to be in EBCDIC so the ASCII to EBCDIC translation will need to happen on the DataStage server also.