Home > IT Answers > AS/400 > Use Data files on another iseries
Help

Question

  Asked: Jan 15 2008   4:34 PM GMT
  Asked by: LCB

Use Data files on another iseries


iSeries remote access, iSeries networking

I have a application in which I run from one iseries and need to over ride the data files to a different iseries database server. How do I reference and over ride the data base files to the remote server?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+3
Click to Vote:
  •   3
  •  0
Last Answered: Jan 16 2008  12:18 AM GMT  by Bvining




Check out Distributed Data Management (DDM) at http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/ddm/rbae5kickoff.htm?tocNode=int_214002

DDM can allow an application program to use a file on a remote system as if the file were local. There are various considerations related to how you are accessing the file (open/read/write/close vs SQL, commitment control, etc), but the above URL and related sub-topics should give you some good background on the subject.

Bruce Vining
www.brucevining.com
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Wpoulin  |   Jan 16 2008  2:33PM GMT

Also, within SQL you can identify a remote database and thru the connect statement access that database on your other iseries server. One restriction we have encountered is the inability to access both the local and remote databases at the same time.

Hope this helps,
Bill Poulin