Re: WDSCi v7 Data perspective vs. QuantumDB

Didn't know about the Data perspective, I'm running WDSC v6 is there a
Data perspective in v6?

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bailey Paul
Sent: Thursday, March 19, 2009 12:03 PM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] WDSCi v7 Data perspective vs. QuantumDB


Hi,

In the Data Perspective, I use a Data Project to collect my various SQL
statements together. When I edit the SQL in the SQL Builder rather than
the SQL Editor, I have a diagram detailing the query and allowing me to
tick the fields I want to display, and link files together by
drag-n-drop. (I also get a sub-window to select sort order, sort type,
conditions, etc., and another sub-window that allows me to edit the SQL
as text.) Is this what you are looking for?

The default editor for SQL code is just a plain text editor, so you need
to right-click your SQL file to find the SQL Builder.


Best regards,
Paul

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Charles Wilt
Sent: 19 March 2009 15:06
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] WDSCi v7 Data perspective vs. QuantumDB

All,

Been exploring the WDSCi Data perspective along with QuantumDB as
possible replacements for STRSQL and iNav's Run SQL Scripts.

I've used Quantum in the past with v5 and v6 of WDSCi. One of the
things I like about Quantum is the ability to drag and drop field
names into the SQL Queries View. That comes in handy with long table
and fields names. However, Quantum doesn't provide a way to see the
labels for field which is a problem when you're dealing with older
tables with only 10 chars. In addition, Quantum doesn't provide a
good "generate DDL" function I can use to modify existing views.

So right now, I seem to be switching between the two often.

If the Data perspective had drag and drop functionality, I'd be happy
with it. Am I missing anything, or is does the Data perspective just
not support drag and drop?

Thanks,
Charles