Re: RE: Plugins Similar to Prodata DBU

[David Kelly <okiebug1399@xxxxxxxxx>]

I located the properties Workbench>Capabilities and made sure that all
available were checked under Database. Exited the IDE and upon restart
double checked this property and processed to open the Data prospective and
right clicked on the Database Explorer in order to access the New Connection
option as outlined in the IBM Press An Introduction to IBM Rational
Application Developer ISBN 1-931182-22-1. The feature rich IDE is documented
to be able to "create a connection to your database, and then browse for
tables or views or run queries against it." The tutorial on page 93 then
goes on to state instructions for accessing MS SQL Server, DB2 etc.

On 10/10/05, Don Yantzi <yantzi@xxxxxxxxxx> wrote:
>
> Hi David,
>
> The data tools are available in the standard edition. Make sure you have
> the Database Developer capability enabled in the Workbench > Capabilities
> preference page.
>
> Don Yantzi
> Technical Release Lead
> WebSphere Development Studio &
> WebSphere Development Studio Client for iSeries
> IBM Toronto Lab
> Phone: (905) 413-4476
> IBM internal: IBMCA(yantzi) - Internet: yantzi@xxxxxxxxxx
>
>
>
>
> David Kelly <okiebug1399@xxxxxxxxx>
> Sent by: wdsci-l-bounces@xxxxxxxxxxxx
> 10/10/2005 02:18 PM
> Please respond to
> Websphere Development Studio Client for iSeries
>
>
> To
> Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
> cc
>
> Subject
> Re: [WDSCI-L] RE: Plugins Similar to Prodata DBU
>
>
>
>
>
>
> On the subject of DB support in WDSCi, would you know the answer to my
> Database Explorer inquiry? I do not want to pay for the AE, and I have
> been
> told by our salesman they cannot provide me with a demonstration copy to
> review prior to purchase.
>
> I am using the WDSCi IBM Rational Software Development Platform Version:
> 6.0.1 Build id: 20050725_1800 that is freely distributed with V5R3
> "5722-WDS
> new orders now have entitlement of the new V6.0 workstation tools, IBM
> WEBSPHERE DEVELOPMENT STUDIO CLIENT FOR ISERIES".
>
> I open the Data perspective, right click on the Database Explorer view
> located in the bottom left of the Data perspective and am NOT finding the
> New Connection menu option. Is this only available with the AE of the
> client? I could not find any clear documentation w/n the WDSCi Help
> library
> or at the
>
> http://www-306.ibm.com/software/awdtools/wdt400/library/WDSCiSeries.html#Specsheets
> .
> I would like to connect to one of our MSSQL Servers and explore/create
> stored procedures, tables.
>
> Thanks,
>
> David Kelly
>
>
> On 10/10/05, Bruce Guetzkow <bruceg@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
> >
> > Richard:
> >
> > <snip>
> > I am currently evaluating Prodata's GUI DBU database access utility for
> > use
> > by our other WDSc users. I would appreciate it if anyone could
> > recommend
> > similar plugins to compare it to.
> > </snip>
> >
> > There is a (free) product called Quantum DB which I believe is available
> > from www.SourceForge.net <http://www.SourceForge.net> <
> http://www.SourceForge.net>. Be sure to
> download
> > the version that
> > corresponds to your version of Eclipse (2.0/3.0). I used it under 2.0.
> > It establishes its own perspective and uses an SQL interface. Unlike
> > DBU (which I also have, green-screen and GUI) Quantum does not directly
> > support modifying data in the file. You would use the SQL Update
> > statement to change data.
> >
> > There is also a product called Frog for IBM iSeries DB2. This is NOT a
> > WDSc plugin, but is similar in function to Quantum.
> >
> > The only thing I don't like about the DBU GUI WDSc plugin is that all it
> > really does is provide a link to start up their GUI product (which is
> > stand-alone). The GUI does not create its own perspective or perform
> > anything within the WDSc framework. Having said that, I have used DBU
> > (green-screen) for many years and am very happy. The GUI is nice, but
> > not as intuitive as it could be.
> >
> > Hope that helps,
> > --Bruce Guetzkow
> >
> >
> > --
> > This is the Websphere Development Studio Client for 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 Websphere Development Studio Client for 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 Websphere Development Studio Client for 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.
>