Re: SQL Connect to question

Using the iSeries Navigator, I can see this other database listed when I
expand the icon for Databases. One database is named the same as the
system. The other has a user defined name. The libraries associated with
this database are all created assigned to a separate ASP device. I see
that I can retrieve this information from job attributes. I can check to
see if the ASP information is different than *NONE and hope to use the
CONNECT TO.

Thanks for the reply and interest.

Nick

If that database is on the same system it will not work, as the database
is
the name of the system.

Perhaps if on another LPAR.

So, what do you mean with "database"? A library? That is called a
collection in AS/400 SQL.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 2-11-2006 at 13:54 nickmart@xxxxxxxxxxxxxxx wrote:

I am working on an application where I would like to be able to use the
SQL CONNECT TO (database name) if different than the default. The
database
is secured and assigned to its own storage pool.

My question is this. If the user job is already pointing at this
database,
do I need to use CONNECT TO :database USER:userprf USING :userpassword or
just CONNECT TO :database?

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.