Sweet!!!
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Tyler, Matt
Sent: Thursday, March 27, 2014 1:35 PM
To: Rational Developer for IBM i / Websphere Development Studio Clientfor System i & iSeries
Subject: Re: [WDSCI-L] Database Development Perspective
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.
--
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
