Re: Use of the IFS

If your PC app - is it your own app, or a vendor app?

If it needs to get data from the i, use ODBC or OLE/DB to get it - direct access to the i physical file. Or better yet, have a stored procedure on the i that returns only what you need - that protects you from unwanted changes from the PC. Or use JDBC, if the app is written in Java.

That's the simplest answer - all this FTP stuff - sorry, it just doesn't work if you need real-time updates - for several reasons, one of which you already know.

Adam West wrote:

On the PC, the warehouse person currently runs a file transfer from the i, that adds records to a file on the PC, then he/she calls up each record on the PC keyed by Invoice number, enters or modifies some data pertaining to the package.
So there are 2 files one on the PC and one on the i. But they are the same file really. At the days end, they send the PC version back to the i for Accounting processing. It is used on various PC's this application.
What I am interested in doing is just have this file on the i with no tranfer.
Because sometimes updates occur to this file on the i, and that means that on the PC they are not in sync.



________________________________
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, January 1, 2009 2:53:10 PM
Subject: Re: Use of the IFS

Adam West wrote:

Yes that is what I am looking to do. But which machines run the code? Then you need a program on the PC to to the FTP so to speak or could it be run from the i? and if from the PC what type of Programming Language would be doing this?

Sorry, Adam, at this point we need very specific step-by-step business requirements. What does the PC application do? What kind of data does it generate? Is it in response to human data entry or some sort of automated process? What type of file is it? Where does it reside? What do you want to do with it on the i? How often does the transfer run?
As you can see, there are huge holes in the definition of the process. Typically before someone can advise you on "how" to do something, you need to define very carefully "what" you want to do. So step back and think about what you want to accomplish from a business sense, and then maybe someone can help you with some technical advice.

Joe