Net.Data and DATABASE

["Peter Vidal" <Peter_Vidal@xxxxxxxx>]

Hi list!

I have two iSeries and I am moving a group of CGIs from one box to the 
other.  On these ones, the DATABASE is hardcoded "MY_BOX", meaning the 
local iSeries.  I thought just at the time we place all the CGI sources on 
"THEIR_BOX", to change the DATABASE value to be "THEIR_BOX" but here is 
the challenge (at least for me).  We want to automatically refer to the 
default relational database, so if the source is in the local machine, 
DATABASE will be reading MY_BOX and if the source runs in the second box, 
it will read from "THEIR_BOX".     Does it make any sense?

Then, I start digging for information and found this in the book":
"OS/400 operating system: This variable is optional. Net.Data, by default, 
specifies DATABASE="*LOCAL"; the DTW_SQL language environment uses the 
local relational database directory entry."

Does this means that I do not need to specify this statement on the CGIs 
and I will be able to use this source on both machines without specifying 
anything in the code?

Any help will be appreciated.  Best regards and great weekend...


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

"Only he who can see the invisible can do the impossible."
-Anonymous-