That would be pretty damn cool.
Right now I copy the SQL out, paste it into STRSQL. Which sometimes leads to wrapping. Sometimes there aren't enough lines so it requires multiple pastes (one set of lines on screen in STRSQL). Then there is taking out the host variables and placing literals as you suggest.
With your dream tool, would we be able to alter the SQL after it was "imported' or whatever from embedded sql? I suppose "alter" with an option of saving. Saving isn't a big deal for me. Especially if it gave a way to copy the statement to the clipboard so it could be easily pasted into RDi (possibly with a "block paste"). Saving sounds like it could get complicated since host variables are going to be converted to literals.
Kurt Anderson
Sr. Programmer/Analyst - Application Development, Service Delivery Platform
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Edmund Reinhardt
Sent: Thursday, October 30, 2014 2:36 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Running SQL scripts
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.
midrange.com
