Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reverse engineer packed decimal (EBCDIC) file format using ODI 11g (ODI 11.1.1.7)

srivatsan purushothamanJun 20 2013 — edited Jul 28 2013

Hi,

I am trying to load the data from a packed decimal file (EBCDIC) to tables in Oracle Database tables. These files have originated from IBM mainframe systems. In order to create the corresponding datastore for the source file, I am trying to reverse engineer the above flat file that I have got.  In ODI, I am not able to see any specific RKMs for this type of file.  The generic one available "RKM File" is also not capable of getting the definition.  I even tried the option "Reverse Engineer Cobol Copybook" but getting an error message "Not a valid cobol copy book".

If any one has done simillar things, can you please help me out on how to accomplish this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2013
Added on Jun 20 2013
3 comments
2,267 views