Re: WDSCi v7 Data perspective vs. QuantumDB

OK,

I gave Data Design Project a go...

The SQL builder is pretty interesting, I can't decide if I like it or
not. It's a bit more than what I wanted. Seems to be easy to break
if you hand-type code in. One thing I notice, is that by uses the
project view, I lose the properties view that gave me the labels on
the short columns.

All I really was looking for the ability to drag a column name from
the Data Explorer into the SQL Editor in the same way that QuantumDB
allows.

It might be important to note that I'm doing ad-hoc querys and views
looking at various results. I'm not actively write code for a project
yet.

Charles

On Thu, Mar 19, 2009 at 12:03 PM, Bailey Paul <paul.bailey@xxxxxxxxx> wrote:

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