× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.