|
Who invented SQL?
Now there's some irony.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Ken Killian
Sent: Friday, March 29, 2019 11:01 AM
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Step over a subroutine
Greg,
For most SQL client, just highlight and run the selected SQL. I use that all the time.
I use the following SQL Clients:
SquirrelSQL.org --> Highlight & Ctrl+Enter Run ACS Script --> Highlight & Ctrl+R (Run one statement at time.) IBM Data Studio --> Highlight & F5. Just like Microsoft! Their SQL Client is SUPERIOR. Code-Assist and EVERYTHING. I just wish it would work with DB2.
Our Microsoft Engineers laughed at the lack-luster Run ACS Scripts &
IBM Data-Studio. Compared to MS SSMS, it is garbage in comparison.
Hence, why we are stuck switching over to Microsoft SQL. <sad>
Replicate db2 to Microsoft SQL, where they have better tools. <sad>
Yup, they watch me manually type out the field names, and ask, doesn't
IBM have "code-Assist". I tell them NOPE, unless you want to set up a
complicate IBM Data-Studio Project. What a "joke" they say... Yeah, I
wish we had better tools like y'all do with Microsoft... <Sad>
Better tools, Happy Developers! <Just saying...> Keep it SIMPLE!
PS. At least Green Screen SQL has very simple prompting for field-names. I often using Green screen SQL, because it has prompting.
-Ken Killian-
-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon
Hamberg
Sent: Friday, March 29, 2019 10:44 AM
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Step over a subroutine
Greg
I saw teh post about run to location - I find that really useful and wish it were part of STRSQL, too.
Cheers
Vern
On 3/29/2019 7:42 AM, Greg Wilburn wrote:
Vern,--
That is what I was doing. But I was in an 20+ year old Order Entry bohemeth full of subroutines and indicators. I had to google CHGJOB SWS(10000100) and *U1, etc. I had never used those!
Anyway... the right-click and Run to Location is perfectly fine.
Another neat thing I found was the ability to copy the Monitor window contents (i.e. huge data structures full of variable data) to the clipboard. I could paste it into Notepad++ and compare the contents from the previous call.
Thanks everyone.
Greg
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf
Of Vernon Hamberg
Sent: Thursday, March 28, 2019 5:14 PM
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Step over a subroutine
Hi Greg
I just put a breakpoint on the line after the EXSR command. Not
pretty, but effective - also, gets ugly when there are so many of the
little beasties.
Ken's suggestion to put breakpoints on the ENDSR could be better if
there are many calls to the same subroutine.
Vern
On 3/28/2019 2:08 PM, Greg Wilburn wrote:
Is there a way to "step-over" a subroutine when going through a program? Something similar to how F6 behaves on a procedure (runs it but doesn't step through it).
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@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/wdsci-l.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
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@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/wdsci-l.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
