Go to the properties page for the connection. Select the Driver
Properties, in the section labeled Properties there is an Optional Tab.
Type in "naming" into the Property input and "system" into the Value
input, now click on Add. Restart the connection. You should be able to
query without the qualified library. You might or will have an issue
with dates; mine results are showing mm/mm/yy formatted dates.
Thanks, Matt
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gerald Kern
Sent: Thursday, March 27, 2014 11:14 AM
To: WDSCi
Subject: Re: [WDSCI-L] Database Development Perspective
Thanks Ken!
That seems to have fixed the problem and I also tested it without having
to qualify each field with it's library name and a dot preceding it!
What I did do is (as you suggested), was add /prodlib to the host name
and then for the heck of it I added the relational database name (as
seen when you start a green screen strsql session) for the schema value.
Not sure it that makes any difference but things seem to be working.
Thanks for a quick (and awesome) response.
--
Thanks, Jerry
Gerald Kern - Information Technology
Programming Supervisor
IBM Certified RPG IV Developer
Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623
Phone 419-479-5535
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
