Re: WDSCi v7 Data perspective vs. QuantumDB

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.