Peter,
There is only one way to do this in Net.Data. The remote machine needs
to be set up in relational database directory which is what WRKRDBDIRE
is for. Once that's done, you use the name from the "Entry" column on
that screen to change the database you are connected to by setting the
DATABASE variable in your macro.
Matt
-----Original Message-----
From: web400-bounces+matt.haas=thomson.com@xxxxxxxxxxxx
[
mailto:web400-bounces+matt.haas=thomson.com@xxxxxxxxxxxx] On Behalf Of
Peter Vidal
Sent: Wednesday, May 16, 2007 12:22 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] SQLing data from a different iSeries
"You need to change the name of the database in the Net.Data macro.
Define a global variable called DATABASE and set it to the name of the
machine you want to connect to (this is the same name that's in
WRKRDBDIRE)"
Is this the only way of resolving this, without doing WRKRDBDIRE?
Peter Vidal
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com
"There is nothing so powerful as truth - and often nothing so strange."
Daniel Webster
midrange.com
