Database 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!

Mainframe flat file with packed decimal

107975May 10 2004 — edited Jul 21 2005

Hey guys!

I'm struggling to load a mainframe flat file with packed decimals. I was wondering if anyone has come across such a situation where all numeric columns in the file are packed (and off course non readable) and character columns fully readable in plain ASCII format. Is there a way to handle this without first unpacking the numeric fields.

I even tried to switch the character set to EBCDIC but it didn't help. Why would it help anyway since the records are partially ASCII and Packed decimal (EBCDIC? Not sure)

Any help will be greatly appreciated.

Thanks,
Rene

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2005

Added on May 10 2004

#data-warehousing, #warehouse-builder

5 comments

676 views