× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I am trying to edit DDS members in LPEX and the RDP client keeps locking up for 5 or 10 seconds at a time as I am working and changing the source members.
So I decided to try to work locally on my workstation using a Project. I have downloaded my source members and editing locally and I am still getting the delays.
So I closed the connection to the Power 7. Now as I am working RDP is trying to connect to the Power 7 as I make changes. The login window pops up and I close it and it pops up again (5 or 6 times) before I can continue.
How do I tell RDP to stop talking to the IBM i while I am working with DDS?

Some notes:
1. This is RDP 8.5.0
2. This RDP behavior is not evident when editing RPG, CBL or CL.
3. We recently started using a co-location so my connection to the Power 7 is remote and the delay in the connection to machine is a new situation
4. Yes, I know I should be using DDL, but the current environment dictates DDS

Thanks folks,

Paul

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Killian
Sent: Friday, May 24, 2013 9: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@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] 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 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:
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-r
pg-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-


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Anderson, Kurt
Sent: Friday, May 24, 2013 9:36 AM
To: Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries
Subject: Re: [WDSCI-L] View QMQry Source in RDP

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@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx] 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 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.
--
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:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.