print file to XML on PC/UNIX



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

print file to XML on PC/UNIX

Postby smithsummit » Thu Oct 14, 2010 3:26 am

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
smithsummit
 
Posts: 3
Joined: Thu Oct 14, 2010 3:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: print file to XML on PC/UNIX

Postby dick scherrer » Thu Oct 14, 2010 8:03 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: print file to XML on PC/UNIX

Postby smithsummit » Thu Oct 14, 2010 11:56 pm

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
smithsummit
 
Posts: 3
Joined: Thu Oct 14, 2010 3:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: print file to XML on PC/UNIX

Postby dick scherrer » Fri Oct 15, 2010 12:33 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: print file to XML on PC/UNIX

Postby smithsummit » Fri Oct 15, 2010 1:32 am

Hi,

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

Thanks,

Rob
smithsummit
 
Posts: 3
Joined: Thu Oct 14, 2010 3:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: print file to XML on PC/UNIX

Postby dick scherrer » Fri Oct 15, 2010 2:40 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post