Manage Learn to apply best practices and optimize your operations.

Access external data from the iSeries

I work with several applications that are user account maintenance intensive. I would like to build Client Access macros that could be run interactively. Essentially, I want to build a script that I can kick off and allow to run to a certain point in my data entry screens, at which point I need to enter specific data, after which, I want to have the macro take off again after I hit the Field Exit key.xc

I'd like help building an application that could read data from a Microsoft Access file on my workstation, and either modify a file on the iSeries directly, or use scripting and the iSeries applications' data entry screens, read a record from the PC file and populate the file on the iSeries. Can you point me in the right direction?

It is possible to access external data from the iSeries using JDBC. If the access has a pure JDBC driver, then you may do the following:

* Install the driver.
* Write a small Java program to read the access file.

The Java program can be wrapped in a user-defined table function as described very nicely .HC0YczOokol.4@.6aea26b5>here.


Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

The Best Web Links: Tips, tutorials and more.

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

Dig Deeper on Data backup, storage and retrieval on iSeries

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.