Page 1 of 1

Load a packed decimal field from an EBCIDIC file

Posted: Wed Jan 15, 2014 11:19 pm
by samyamkrishna
Hi,

We have a requirement to load packed decimal fields from an EBCIDIC file into a colum with RAW datatype in ORACLE.

How do we do this using a datastage job.
Any help will be appreciated.

Regards,
Samyam

Posted: Thu Jan 16, 2014 8:23 am
by chulett
What have you tried so far? What issues have you faced? Are you using the CFF stage to read the file?

Posted: Thu Jan 16, 2014 12:58 pm
by rwierdsm
See this post that does an excellent job of summarizing the interaction between mainframes and DataStage.

viewtopic.php?t=143596

Posted: Thu Jan 16, 2014 1:03 pm
by rwierdsm
Oops, double post. Can you fix it Craig?

Thanks.

Posted: Thu Jan 16, 2014 1:48 pm
by chulett
Done. But keep in mind the fact that you can too - as long as a post hasn't been replied to yet, the original poster can delete it. FYI.