Convert mainframe packed data

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Convert mainframe packed data

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

Postby 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

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider], Yahoo [Bot] and 1 guest