Re: View QMQry Source in RDP

IBM Data Studio has been getting more investment from IBM over the last 2
years. But it is focused DB2 LUW (Linux, Unix, Windows). Of course 95% of
the SQL is the same, so IBM i support benefits from this investment. But
for IBM i unique things, there will be limitations. IBM Data Studio has
great features for query tuning, for example, but they do not work with IBM
i. The IBM i Navigator is still the way to go with that. But for working
with SQL queries there is a lot of value there and we have tested that IBM
Data Studio can be completely integrated with RD Power.

I haven't tested it myself, but I have heard others on this list mention
QUANTUM DB as a free plugin for SQL.



Regards,



Edmund (E.H.) Reinhardt
COBOL IDE on AIX, DDS, WebFacing, System i Application Development,
Rational Developer for Power



2D barcode Phone: 1-905-413-3125 | Phone: 1-905-854-6195 IBM
- encoded E-mail: edmund.reinhardt@xxxxxxxxxx
with AIX COBOL: 8200 Warden Ave
contact www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON L6G 1C7
information "In every thing give thanks: for this is the will of Canada
God in Christ Jesus concerning you." - 1
Thessalonians 5:18






From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>,
Date: 23/05/2013 09:56 PM
Subject: Re: [WDSCI-L] View QMQry Source in RDP
Sent by: wdsci-l-bounces@xxxxxxxxxxxx



I installed Data Studio, seemed better to put it into its own workspace,
in my initial playing around. But that's not conclusive, just a thought
to see what happens when you try it. I am also working with Turnover's
plugin, not sure if there're any issues there.

There is also a built-in data perspective, isn't there, Edmund? Again, I
was just dabbling while trying to find a nice editor for SQL stored
procedures.

I am using 8.5.1, and I am using DS 3.1.1, as i recall.

I looked at DS some time ago - I think it's received enhancements for
better IBM i support. Just my impression.

Vern

On 5/23/2013 3:13 PM, Edmund Reinhardt wrote:

I am not familiar with STRQM but if you want to just tweak SQL, you can
past it into an IBM Data Studio query. IBM Data Studio is free and
integrates with RD Power. For RDp 8.5, I think you would want to install
IBM Data Studio 3.1.1



Regards,



Edmund (E.H.) Reinhardt
COBOL IDE on AIX, DDS, WebFacing, System i Application Development,
Rational Developer for Power

2D barcode Phone: 1-905-413-3125 | Phone: 1-905-854-6195

IBM

- encoded E-mail: edmund.reinhardt@xxxxxxxxxx
with AIX COBOL:

8200 Warden Ave

contact www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501

Markham, ON L6G 1C7

information "In every thing give thanks: for this is the will of

Canada

God in Christ Jesus concerning you." - 1
Thessalonians 5:18

From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: wdsci-l@xxxxxxxxxxxx,
Date: 23/05/2013 02:34 PM
Subject: Re: [WDSCI-L] View QMQry Source in RDP
Sent by: wdsci-l-bounces@xxxxxxxxxxxx



On 5/23/2013 2:15 PM, Anderson, Kurt wrote:

Buck,

I guess I wasn't aware of CRTQMQRY. I am in fact using STRQM (and to

run

it in a CL - STRQMQRY).

STRQM creates two objects: a *QMQRY and a *QMFORM. The form holds
formatting instructions and the query holds the SQL. ish. You can
convert STRQM queries to source-based queries via RTVQMQRY. This will
result in two source files: QQMQRYSRC and QQMFORMSRC. The query part is
easy to understand and edit. The form part can be a challenge. Once
you've retrieved and edited the source you need to CRTQMFORM and

CRTQMQRY.

If you mostly change the SQL and rarely change the presentation, this
can work out OK. If you need to change the presentation (more columns,
etc) then you'll probably be best served by copying the SQL into the
STRQM session and using that editor to handle the formatting. After
getting it just so, RTVQMQRY again to get the source back out.

Lot of work for a small change until you get comfortable with QMFORMs.
--buck

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]

On Behalf Of Buck Calabro

Sent: Thursday, May 23, 2013 1:13 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] View QMQry Source in RDP

On 5/23/2013 1:28 PM, Kurt wrote:

Is there a way to work with QMQry source in RDP?

I would like to update some SQL and I was thinking it'd be nice if I

could do it in RDP. I know I can do it in RDP (or wherever) and copy

what

I want into QMQry, but I'd like to be able to directly modify the QMQry
source from RDP.

To be clear, I think you are not talking about editing QQMQRYSRC; the

place the source is stored for the CRTQMQRY command; the resulting object
executed via STRQMQRY. RDp works fine for this although there is no
prompting available.

I think you are talking about STRQM, which doesn't seem to have a source

file associated with it. The 'source' seems embedded in the *QMQRY

object.

Unless STRQM has a secret stash where it keeps the source, I don't think
any external editor is going to work with these.

--buck

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