Page 1 of 1

Read Hexadecimnal Values in DaTAstage

Posted: Wed Jan 04, 2012 10:36 am
by manishmaheshwari2608
HI Guys,

Can anyone help me out in reading Hexadecimal Values coming from Mainframe in Datastage .

I am trying to read from Sequential file but for certain data which is in Hexadecimal are not readed properly.

Thanks

Re: Read Hexadecimnal Values in DaTAstage

Posted: Wed Jan 04, 2012 11:00 am
by e1994264
Hi,
If Someone have expertse in Mainframe. They can change the hexadecimal data into ASCII format.
So you cannot read the hexadecimal from Sequential file . It need to be converted in Mainframe itself .

Posted: Wed Jan 04, 2012 1:02 pm
by pandeesh
I believe you can do the same conversion in unix also.

Posted: Wed Jan 04, 2012 1:06 pm
by dsusersaj
I have used complex flat file to read EBCDIC files (which are files created in Mainframes).

Posted: Wed Jan 04, 2012 2:25 pm
by chulett
What 'certain data' exactly? Are these COMP-3 / PACKED DECIMAL fields?

Posted: Wed Jan 04, 2012 3:56 pm
by FranklinE
Look in this FAQ: viewtopic.php?t=143596

If I haven't covered it for you there, it may serve to help you state your question in a different way.

Posted: Wed Jan 04, 2012 4:20 pm
by qt_ky
FranklinE wrote:Look in this FAQ:
"Sorry, but only users granted special access can read topics in this forum."

I would love to get a copy of the FAQ for this. Thanks!

Posted: Thu Jan 05, 2012 11:04 am
by FranklinE
qt_ky wrote:Sorry, but only users granted special access can read topics in this forum."

I would love to get a copy of the FAQ for this. Thanks!
Craig?

Posted: Thu Jan 05, 2012 6:18 pm
by chulett
I've tried to help Eric several times but my cries seem to be falling on deaf ears... that is some sort of setup issue/error and needs to be resolved by the site owner / webmaster. Sorry. :(

Posted: Thu Jan 05, 2012 8:50 pm
by qt_ky
Thanks, Craig. I know you've tried to help out! I've also tried emailing directly, but maybe someone is on extended vacation or something. It hasn't worked since I joined.