Re: 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