DataType

senthilt1 · Post by **senthilt1** » Thu Apr 24, 2008 3:01 am

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

ArindamBanerjee · Post by **ArindamBanerjee** » Thu Apr 24, 2008 4:45 am

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

ArndW · Post by **ArndW** » Thu Apr 24, 2008 5:11 am

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

senthilt1 · Post by **senthilt1** » Thu Apr 24, 2008 5:19 am

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

ArndW · Post by **ArndW** » Thu Apr 24, 2008 5:29 am

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

senthilt1 · Post by **senthilt1** » Fri Apr 25, 2008 12:20 am

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

ArndW · Post by **ArndW** » Fri Apr 25, 2008 3:09 am

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.