Convert mainframe packed data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Tue Sep 25, 2007 4:12 am

Convert mainframe packed data

Post by gkata »

I'm new to TextPipe and I'd like to know if it can convert a file that contains both text (readable) and numeric packed data (dates and amounts - unreadable). The data originates on the mainframe and I need to load this data into an Oracle table.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support »

Hi Glenn,

You need to ensure your FTP the file off the mainframe in binary mode to preserve the packed decimal fields. Then, using Filters\Wizards\Mainframe copybook filter, you can paste in the copybook (file format), and also specify that it only converts numeric fields
Post Reply