RE: [WDSCI-L] RE: SQL tools

["Don Yantzi" <yantzi@xxxxxxxxxx>]

Scott,

I will look at updating the article for V5.0 and am also looking at 
creating a presentation on the database tools which we can post to the 
website.  I haven't played with the Quantum plug-in yet so I can't offer 
any comparison between it and the Database tooling in WDSc.  However I can 
provide some points on the functions in the Database tooling.  First to 
get started ...

- yes, the data perspective is the central user interface for the Database 
tooling
- yes, you need to create a Database connection to get started.  You do 
this by right clicking in the DB Servers view and selecting New 
Connection...
- yes, the correct path for the class location is 
C:\WDSC\iseries\eclipse\plugins\com.ibm.etools.iseries.toolbox_5.0.0\runtime\jt400.jar
- Make sure you specify a filter!!!  Schemas map to libraries on the 
iSeries so if you want to include a list of libraries just add them to the 
filter (make sure you change the operator to OR instead of AND.)  If you 
see nothing come back from creating the connection or the Workbench seems 
to hang it is likely because the filter is wrong.  By default the tool 
downloads metadata for the entire database which on the iSeries is quite 
big (hence why it looks like it hangs, come back in an hour or two and it 
will probably be finished.)

Now that you have your connection, right click on the connection and 
select "Import To Folder".  This imports the database metadata into a 
local workspace project so you can continue to use it without being 
connected to the database.  Obviously one part of the database tooling is 
to look at the data, but this is really only a small part of the tooling. 
By importing the database metadata into the workspace it can be used by 
other tools like:

- The graphical SQL editor to allow you write and test SQL statements 
(edit SQL graphically or manually)
- Use the database tooling to define new tables in the database
- Database Web pages wizard (uses the database information to create web 
pages to list, update, delete information from a database)
- EJB tooling (advanced edition of WDSc)
- XML tooling (generate an XML schema from a database definition, read 
records from a database into an XML document or write information from an 
XML doc to the database)
- ...

So in conclusion : )   The ability to look at the records in the database 
or to create an SQL statement is only a small part of the database tools. 
A much larger part is that other tools integrated into the Workbench use 
the information from the database tools to do other things.  It's all 
about integration : )

If anyone is still having problems getting connected and creating an SQL 
statement please post them.

Thanks.

Don Yantzi
WebSphere Development Studio Client for iSeries
IBM Toronto Lab
Phone: (905) 413-4476
IBM internal:  IBMCA(yantzi)  -  Internet: yantzi@xxxxxxxxxx





"Scott Johnson" <sjohnson@xxxxxxxxxxxxx>
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
29/05/2003 12:24 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: SQL tools

 


I kind of knew it was 4.0, but did not know if there had been any changes
with it for 5.0.  Maybe we can convince Phil to talk to the author and 
have
them update it for ver 5.0.

-- Scott

> -----Original Message-----
> From: wdsci-l-bounces@xxxxxxxxxxxx
> [mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Samuel J Lennon
> Sent: Thursday, May 29, 2003 11:06 AM
> To: wdsci-l@xxxxxxxxxxxx
> Subject: Re: [WDSCI-L] RE: SQL tools
>
>
>    This appears to be for version 4.  In version 5 I found that the
>    DBExplorer view is now named DBServers.  And to run the
> built SQL you had
>    to right click on it in the Outline pane.
>
>    I don't know how useful this will be.  I'll need to spend
> more time and I
>    need a 21" monitor to cope with all the windows...
>
>    Sam
>
>    >From: "Scott Johnson" <SJOHNSON@xxxxxxxxxxxxx>
>    >Reply-To: Websphere Development Studio Client for
>    iSeries<WDSCI-L@xxxxxxxxxxxx>
>    >To: "'Websphere Development Studio Client for iSeries'"
>    <WDSCI-L@xxxxxxxxxxxx>, <CODE400-L@xxxxxxxxxxxx>
>    >Subject: [WDSCI-L] RE: SQL tools
>    >Date: Thu, 29 May 2003 09:00:10 -0500
>    >
>    >
>    >Here is an article on setting up and using the Data Perspective:
>    >
>    >http://eservercomputing.com/iseries/archives/index.asp?a=1&id=489
>    >
>    >
>

_______________________________________________
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.