IBM Mainframe Forum

Hi,

I am new to IBM mainframe. We are receiving print files from an outside source and I need to load the information contained in them to an Oracle database on AIX. Does there exist a program that will parse the print file and output, say, XML?

Thanks!

Best Regards,


Rob

Hello and welcome to the forum,

Is there some reason why this data is not received directly on the Unix system?

If the selected/reformatted data is to be loaded into a database, suggest you consider creating a delimited file to be used as input to an Oracle load.

Hi,

The print files are FTP'd to me as is from an outside source. So far this appears to be the only way data can be supplied, though I am continuing to ask for delimited text or XML...

Regards,


Rob

Hello,

While the "sender" may not be willing to create the files differently, it is fairly easy to read a "report" and generate a delimited file from the report. This could either be done on the mainframe or on the unix system if the data can be sent directly there.

Hi,

How do you read a "report" file in a UNIX env?

Thanks,

Rob

Hello,

As they told me when i first started working with unix - "Everything is a file"

That the content is a formatted report does not matter - it is all just data when read by code.

Whether from the mainframe or from the report creator, the ftp process will put the file onto some directory on the unix system. Suggest you talk with the unix admins to learn where this data should be stored. How the directories are managed on that system are completely site-dependent. SOmetimes, there are separate directories for inbound ftp transmissions. Sometimes, these are put in a "project" directory. Sometimes, in a user directory. Your support people will be able to provide guidance.