Maybe I wasn't clear
My idea is to create an SQL Script in IBM Data Studio with all of IDS's
content assist, execute etc. to support playing with the SELECT statement,
till it is doing what your want.
I am not in a position to duplicate what IDS has already done, their
strength is SQL and I am supplying the glue so that we can access that from
within SQLRPGLE



Regards,

Edmund (E.H.) Reinhardt
Technical Architect for Rational Developer for i



Phone: 1-905-413-3125 | Home: 1-905-854-6195
E-mail: edmund.reinhardt@xxxxxxxxxx
RDi YouTube: 8200 Warden Ave
www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON L6G 1C7
Find me on: Canada






From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 30/10/2014 04:23 PM
Subject: Re: [WDSCI-L] Running SQL scripts
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



Yeah, Edmund - I agree - but your idea here could include that - unless
you are forced to build it on top of Data Studio.

On 10/30/2014 2:41 PM, Edmund Reinhardt wrote:
Vern,
I don't see the IBM Data Studio, which is written by the common DB2
team
that does not know IBM i, ever supporting DDS objects.
From what I hear from Dan Cruickshank, it is a good idea to front end
DDS
PF with an SQL view and then you can modernize at your leisure.



Regards,

Edmund (E.H.) Reinhardt
Technical Architect for Rational Developer for i






Phone: 1-905-413-3125 | Home: 1-905-854-6195
E-mail: edmund.reinhardt@xxxxxxxxxx
RDi YouTube: 8200
Warden Ave
www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON
L6G 1C7
Find me on:
Canada







From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries
<wdsci-l@xxxxxxxxxxxx>
Date: 30/10/2014 03:14 PM
Subject: Re: [WDSCI-L] Running SQL scripts
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



This is very nice stuff to dream about - the Data perspective and Data
Studio were always kind of a fill-in to allow testing, but not connected
as you describe here - so they are not all that much better than
Navigator's tooling, to some of our eyes.

Would an RFE with many votes put this closer to the nearer term?

One of the other matters might include recognition of DDS-based objects
as valid to use in SQL - Data Studio doesn't see them, as I recall - I'm
not sure about the Data perspective. This question applies to the idea
of some good prompting.

Vern

On 10/30/2014 1:35 PM, Edmund Reinhardt wrote:
This is my current dream, which I do not have any resources to implement
in
the near term, so please don't have specific expectations, but you can
validate that my plan is on track.

When going from RDi editor to SQL editor, the developer is prompted for
each :variable to give a literal.
Comments will be inserted into the SQL editor, documenting the :variable
to
literal mapping.
When going back from the SQL editor to the RDi editor, the literals
would
be substituted by the mapped variable, for unmapped literals, the
developer will be prompted if they want to replace with more :variable
names



Regards,

Edmund (E.H.) Reinhardt
Technical Architect for Rational Developer for i

Phone: 1-905-413-3125 | Home: 1-905-854-6195
E-mail: edmund.reinhardt@xxxxxxxxxx
RDi YouTube: 8200
Warden Ave
www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON
L6G 1C7
Find me on:
Canada




From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: wdsci-l@xxxxxxxxxxxx
Date: 30/10/2014 02:30 PM
Subject: Re: [WDSCI-L] Running SQL scripts
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



On 10/30/2014 2:10 PM, Edmund Reinhardt wrote:
There is a small subset of IBM Data Studio which is shipped with RDi.
Now
that IBM Data Studio itself is free, you can get the full features of
the
product. The SQL running/editing/diagramming is relevant to IBM i.
The
query tuning is not since it is geared to LUW DBW (not IBM i).

I am thinking about developing better integration with RDi eventually,
so
I
am following this thread with interest.

So if there was an easy way to get embedded SQL into an SQL script
editor
in IBM Data Studio would this help write, test queries?
Mad utopian dreamer alert!

Given:
select SYSTEM_COLUMN_NAME, DATA_TYPE, "LENGTH", NUMERIC_SCALE,
COLUMN_TEXT, IS_NULLABLE, "CCSID", SYSTEM_TABLE_NAME,
SYSTEM_TABLE_SCHEMA, COLNO
from SYSCOLUMNS
where SYSTEM_TABLE_NAME = :REF_FILE and
SYSTEM_TABLE_SCHEMA = :REF_LIBR;

I would love to have the test/debug tool/IDE be able to 'declare'
variables :REF_FILE and :REF_LIBR as well as populate them with values
and then execute this code as-is. Once my SQL is working properly, I
could then cut / paste it back into my HLL as-is without having to
remove literals and replace them with host variables.

Similar to the ability SDA has to populate fields for testing (STRSDA
option 3).

--
--buck

'I had nothing to offer anybody except my own confusion' - Jack Kerouac
--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & 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 Rational Developer for IBM i / Websphere Development Studio
Client for System i & 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 Rational Developer for IBM i / Websphere Development Studio
Client for System i & 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.


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