DSXchange

Dear Friends,

I have a file with datatype EBCDIC, Packed decimal and ASCII. Actually this is the file in Abinitio.

I need to migrate this into DStage 8.x.

Do Datastage support EBCDIC, Packed decimal and ASCII datatype. i couldnt find it in Datastage. So kindly guide me how to handle this datatype or is there any equivalent thing available in datastage.

Thanks in Advance!

Senthil P

Senthil,
Try Complex File Stage. Datastage supports EBCDIC and Fixed length file formats. Explore and you will find EBCDIC option in dropdown.

You can also do this with the normal sequential file stage. Could you explain - does the file have both ASCII and EBCDIC columns?

Andrw,

In my case EBCDIC and Packed decimal types are used in a single file. Ascii is used in diff file.

ArindamBanerjee ,

Thanks for your Info.

SenthilP

In that case a sequential file stage will be easier to use.

Hi Andrw,

In seq file stage, do we get the EBCDIC, packed decimal formats in the data type drop down list? I dont find that in 7.5.2. Is 8X has those feautres? Time being i dont have 8x version with me to check this.

Could you please clear this.

Thanks,

Senthil P

For each column you can go to the details (click on the column name, right-mouse-click and "edit row" and from there you can specify whether the character column is "EBCDIC" or "ASCII". This is the same in versions 7 and 8.