Load a packed decimal field from an EBCIDIC file

samyamkrishna · Post by **samyamkrishna** » Wed Jan 15, 2014 11:19 pm

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

chulett · Post by **chulett** » Thu Jan 16, 2014 8:23 am

What have you tried so far? What issues have you faced? Are you using the CFF stage to read the file?

rwierdsm · Post by **rwierdsm** » Thu Jan 16, 2014 12:58 pm

See this post that does an excellent job of summarizing the interaction between mainframes and DataStage.

viewtopic.php?t=143596

rwierdsm · Post by **rwierdsm** » Thu Jan 16, 2014 1:03 pm

Oops, double post. Can you fix it Craig?

Thanks.

chulett · Post by **chulett** » Thu Jan 16, 2014 1:48 pm

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.