I have a wrapper-type class for some SQLCLI stuff. I call it FTPDatabase.
I have a constructor where you pass in a data source name, default library,
user & password. On our old Power7 systems we didn't have any iASPs at
all. We simply used *SYSBASE and the default database that came configured
with the system. I had coded in all of my programs for the data source
name to be "*LOCAL". Being new to the IBMi at the time, I probably got
"*LOCAL" from some web page or IBM manual.
Here is a snippet of code that connects to the database.
On our Power8 system, we're going to have iASPs and our data is going to be
separated from *SYSBASE. I had a sample program laying around that just
did a SELECT from a well-known table/file & spit the results out. This
library/schema exists on iASP "DATADEV". I compiled this program, which
still connected to *LOCAL on the new system, expecting it to fail because
(I thought) "*LOCAL" would connect to *SYSBASE.
Can anyone shed some light? I cannot find a difference between
This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact