gmane.editors.websphere.iseries

Re: View QMQry Source in RDP

Gary Thompson — 2013-05-24T14:53:32

Appreciate the extra info.

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Ken Killian
Sent: Friday, May 24, 2013 8:49 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

I have been using the Squirrel SQL for quite some time, and I have grown to love it!

Maybe this link might be better for the set-up:
http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-graphical-tool-that-you-can-use-for-all-your-databases.html

It takes a little bit of work to set it up the first time. You have to install the driver, and configure an alias...

I also like Squirrel, that I can easily export my results to XLS too!

If you stick with it, you might like it! I must admit that the IBM scripts flags the error better however...

-Ken Killian-
(423) 510-3129

-----Original Message-----
From: wdsci-l-bou

Re: View QMQry Source in RDP

Ken Killian — 2013-05-24T14:48:46

I have been using the Squirrel SQL for quite some time, and I have grown to love it!

Maybe this link might be better for the set-up:
http://www.mcpressonline.com/programming/sql/an-open-source-db2-sql-graphical-tool-that-you-can-use-for-all-your-databases.html

It takes a little bit of work to set it up the first time. You have to install the driver, and configure an alias...

I also like Squirrel, that I can easily export my results to XLS too!

If you stick with it, you might like it! I must admit that the IBM scripts flags the error better however...


-Ken Killian-
(423) 510-3129


-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Gary Thompson
Sent: Friday, May 24, 2013 10:33 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

Thanks for the links!
Unfortunately, even after logging on iPro, none

Re: View QMQry Source in RDP

Gary Thompson — 2013-05-24T14:33:07

Thanks for the links!
Unfortunately, even after logging on iPro, none of the figure links worked (?),
but this, and a break in due dates, gets me going to start using Squirrel
in place of Run SQL Scripts.

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Ken Killian
Sent: Friday, May 24, 2013 7:49 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

To test my SQL Scripts inside of RDP, I create a User-Action:

I call it "Run SQL Statements"
RUNSQLSTM SRCFILE(&L/&F) SRCMBR(&N) COMMIT(*CHG) NAMING(*SQL) ERRLVL(21) DFTRDBCOL(&O)

We write Customize SQL Scripts to convert our DDS over DDL, and that is how we promote our changes...

We use SoftLanding/Turnover, which runs the SQL-Statement to promote our conversions from DDS to DDL/SQL.

For my SQL Development, I happen to use SQL Squirrel. Which gives me

Re: View QMQry Source in RDP

Ken Killian — 2013-05-24T14:30:19

ALT+Z to paste... <typo>

-Ken Killian-
(423) 510-3129


-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Ken Killian
Sent: Friday, May 24, 2013 10:04 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

Yup, I do all that and more... Just a few "Fossil Programmer" "Hold-Outs"... 
<snicker snicker>

Just a tip worth repeating for Newbies. 
To cut & paste a block of code inside RDP:
1.) Use Alt+R to select a Rectangle
2.) Use Alatza to Paste (OVERLAY)

-Ken Killian-
(423) 510-3129


-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Vernon Hamberg
Sent: Friday, May 24, 2013 9:57 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [

Re: View QMQry Source in RDP

Ken Killian — 2013-05-24T14:04:01

Yup, I do all that and more... Just a few "Fossil Programmer" "Hold-Outs"... 
<snicker snicker>

Just a tip worth repeating for Newbies. 
To cut & paste a block of code inside RDP:
1.) Use Alt+R to select a Rectangle
2.) Use Alatza to Paste (OVERLAY)

-Ken Killian-
(423) 510-3129


-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Vernon Hamberg
Sent: Friday, May 24, 2013 9:57 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

Even better - copy-paste in SEU! It's part of PC5250.

And turn on the feature to make F-keys into buttons!

Also double-click in an empty spot to do an Enter

Also double-click on text to put it at the cursor - hey it's all a green gooey!

But it is good - even PC5250 had tricks for us today!

Just make a keyboard mapping that gives you Ctrl-X|C|V - I have one that I can send

Re: View QMQry Source in RDP

Vernon Hamberg — 2013-05-24T13:56:33

Even better - copy-paste in SEU! It's part of PC5250.

And turn on the feature to make F-keys into buttons!

Also double-click in an empty spot to do an Enter

Also double-click on text to put it at the cursor - hey it's all a green 
gooey!

But it is good - even PC5250 had tricks for us today!

Just make a keyboard mapping that gives you Ctrl-X|C|V - I have one that 
I can send to anyone - contact me privately. Also a feature-rich toolbar 
- more macro options, all that.

Vern

On 5/24/2013 8:48 AM, Ken Killian wrote:

Re: View QMQry Source in RDP

Ken Killian — 2013-05-24T13:48:57

To test my SQL Scripts inside of RDP, I create a User-Action:

I call it "Run SQL Statements"
RUNSQLSTM SRCFILE(&L/&F) SRCMBR(&N) COMMIT(*CHG) NAMING(*SQL) ERRLVL(21) DFTRDBCOL(&O)

We write Customize SQL Scripts to convert our DDS over DDL, and that is how we promote our changes...

We use SoftLanding/Turnover, which runs the SQL-Statement to promote our conversions from DDS to DDL/SQL.

For my SQL Development, I happen to use SQL Squirrel. Which gives me Color Syntax, and it remembers my last 100 SQL Statements! Very Handy! And I have programmed commonly used SQL Statement into "Bookmarks", to instantly call them...

http://iprodeveloper.com/database/dig-data-squirrel-sql
http://www.mcpressonline.com/programming/sql/use-squirrel-sql-during-rpg-development-with-embedded-sql.html

Use the tools that you like!

It still amazes that "Fossil Programmers" are "AMAZED" when you do the magic of "CUT & PASTE"...
<Evil Smirk>

Of course, they stick to SEU, because anything new is EVIL...
<LOL>

-Ken Killian-


-----

Re: View QMQry Source in RDP

Anderson, Kurt — 2013-05-24T13:35:36

While it may only offer color-coding, which may be all I want, the sql parser in LPEX works great for me when modifying SQL we have stored in source members (functions, stored procedures, DDL, etc).

-Kurt

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Vernon Hamberg
Sent: Thursday, May 23, 2013 8:56 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

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

Re: View QMQry Source in RDP

Edmund Reinhardt — 2013-05-24T12:04:15

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

Re: View QMQry Source in RDP

Vernon Hamberg — 2013-05-24T02:15:54

Buck mentioned that RUNSQL doesn't do a SELECT. It also doesn't have 
substitution variables, either. You have to put values into dynamic 
statement strings.

The generic SQL processors that Buck and I and others have written all 
use only substitution variables in a QMQRY, and those also need you to 
construct the statement, concatenating values into the statement. This 
makes it about the same as the new RUNSQL from IBM, with the benefit of 
being able to use STRSQL. I've done a presentation on this at COMMON and 
at a couple user groups.

Vern

On 5/23/2013 1:30 PM, Anderson, Kurt wrote:

Re: View QMQry Source in RDP

Vernon Hamberg — 2013-05-24T02:12:39

Hi Buck

Just to level-set, I've learned a lot from your EXCSQL stuff - not sure 
if that's the exact name, of course.

So I'm adding a bit here (standing on your shoulders, so to speak) that 
might help clarify things a bit.

STRQM is Query Manager - the interface for working with QM objects, as 
you describe.

We don't HAVE to create *QMFORMs, but they do need ultimately to have a 
*QMQRY as data source. But there is a system default form that can be used.

I have a feeling - not based on being told, of course - that all QMQRYs 
are kind of source-based. Maybe there's an internal source, maybe just 
in memory, that STRQM uses. Doesn't matter to me much though.

RTVQMQRY doesn't retrieve source for QMFORMs - have to use RTVQMFORM for 
that. This brings up a thought - Query/400 queries combine data and 
presentation in one object, QM separates them. And the RTVQM* commands 
can be used to get QM source from QRYDFNs - pretty cool!

I find that STRQM is most beneficial in working with forms - as you 
suggest,

Re: View QMQry Source in RDP

Vernon Hamberg — 2013-05-24T01:55:47

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:

Re: View QMQry Source in RDP

2013-05-24T00:51:11

There is one product I've used in the past--although I haven't used it in 
years.  It's called FROG.  It's a free utility.  A quick Internet search 
found it at: www.innovativesys.net/?page_id=4

I think you have to launch it as an external editor.  Like I said, I 
haven't used it in years and I don't remember how well it worked, but I 
was able to open and edit QM objects in a graphical PC editor.

Michael Quigley
Computer Services
The Way International
www.TheWay.org

Re: View QMQry Source in RDP

DeLong, Eric — 2013-05-23T20:47:51

I thought I had heard of a RSE plugin for that, but I couldn't find any reference...  

However, I seem to recall that F.R.O.G. for IBM i supports QMQRY objects...  It does NOT integrate into RSE, but it is a fairly useful tool despite this...
http://www.innovativesys.net/?page_id=4

hth,
-Eric DeLong

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Anderson, Kurt
Sent: Thursday, May 23, 2013 12:29 PM
To: 'Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (wdsci-l-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org)'
Subject: [WDSCI-L] View QMQry Source in RDP

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.

Thanks,

Kurt Anderson

Re: RSE Extensions...Compare not working

Edmund Reinhardt — 2013-05-23T20:16:00

OK, in that case, you have shown that the DLLs should be there.  So I will
leave it with Doug.



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-G1DYhSM1WHTQT0dZR+AlfA< at >public.gmane.org                                          
 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 c

Re: View QMQry Source in RDP

Edmund Reinhardt — 2013-05-23T20:13:57

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-G1DYhSM1WHTQT0dZR+AlfA< at >public.gmane.org                                          
 with        AIX COBOL:                                                   8200 Warden Ave 
 contact     www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501    Markh

Re: View QMQry Source in RDP

Buck Calabro — 2013-05-23T18:41:31


That's EXACTLY what I use QQMQRYSRC for!
RUNSQL doesn't do SELECT, so that won't help.
We should take this to Midrange-L if there's more you want to discuss.
  --buck

Re: View QMQry Source in RDP

Anderson, Kurt — 2013-05-23T18:30:36

We use QM in order to run SQL from CL because it handles variables unlike RUNSQLSTM.   We're not actually using it for presentation, so we don't touch the forms aspect.
We should be getting the latest Technology Refresh soon so maybe we'll be able to use CL's RUNSQL instead of QM.

Thanks,
Kurt

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Buck Calabro
Sent: Thursday, May 23, 2013 1:27 PM
To: wdsci-l-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org
Subject: Re: [WDSCI-L] View QMQry Source in RDP

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

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 retriev

Re: View QMQry Source in RDP

Buck Calabro — 2013-05-23T18:27:17

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

Re: View QMQry Source in RDP

Anderson, Kurt — 2013-05-23T18:15:11

Buck,

I guess I wasn't aware of CRTQMQRY.  I am in fact using STRQM (and to run it in a CL - STRQMQRY).

Thanks,
Kurt

-----Original Message-----
From: wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org [mailto:wdsci-l-bounces-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org] On Behalf Of Buck Calabro
Sent: Thursday, May 23, 2013 1:13 PM
To: wdsci-l-Zwy7GipZuJhWk0Htik3J/w< at >public.gmane.org
Subject: Re: [WDSCI-L] View QMQry Source in RDP

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


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

Re: View QMQry Source in RDP

Buck Calabro — 2013-05-23T18:12:47


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