Convert mainframe packed data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Convert mainframe packed data

Post by gkata » Tue Sep 25, 2007 4:14 am

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: 2261
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support » Tue Sep 25, 2007 10:59 am

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

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests