View previous topic :: View next topic
|
Author |
Message |
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
I have a requirement in which I have to receive a file from jdbc and copy the contents of the file to a GDG.
Could some body tell me the best approach for this. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Write an interface to get the file and update the GDG? More importantly, since Excel formatted files are not readable on the mainframe, just what do you think you're going to accomplish by putting such a file into a GDG? Now if it were comma-delimited, I could see doing this (maybe) -- but not an Excel file. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Could some body tell me the best approach for this. |
Create a delimited text file on the remote system and transfer the text file to the mainframe for processing.
None of the proprietary Windows/"office" formats are easily usable on the mainframe. |
|
Back to top |
|
|
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
Thanks for the replys.
The major concern is how to get the file from jdbc to mainframes environment. The job will run for every 6 hours to capture the latest changes on JDBC side.
I am contemplating two ways for the above req:
1) to convert the EXCEL to a txt ( this will be done on JDBC) and then receive the txt file into mainframe. My doubt is whether we can receive a file in java server into mainframe using FTP job ?
2) To load the data into a DB2 table ( from JAVA side ) and access that table and create a report
Please suggest a better method if there is feasibility of above two options |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
From a Google search, there's free Java FTP classes available. Write an FTP to transfer data to JES on the mainframe so a job is submitted; this job can process your data and do whatever you need. Depending on the requirements you may want one FTP to upload the data, then another FTP to submit a job to process the data.
In a production environment, I would also be concerned about ensuring a failed transfer won't cause the same data to be picked up every 6 hours until the problem is fixed. |
|
Back to top |
|
|
tiruvathuruk Warnings : 1 New User
Joined: 30 Sep 2008 Posts: 6 Location: Pune
|
|
|
|
Hi Robert,
Thanks for your reply and i would be keep in mind the consequences of FTP fails.
Thanks once again. |
|
Back to top |
|
|
|