Hi,
Inside of ACS Run SQL scripts, there is an easy way to turn off the RUN SQL Scripts on Double-click:
Open Menu: Options, and uncheck the "Run Statement on Double-Click".
That little annoyance SOVLED! Problem Solved. <Big smile>
Now, if the double-click in the Debug Editor could be fixed for **free format code! Already open a PMR on that.
PS. 90% of the time, I use SquirrelSQL.org for my db2 SQL. But occasionally use the ACS Run SQL Scripts, because it is convenient inside of RDI 9.5.1.2.
-Ken Killian-
-----Original Message-----
From: Ken Killian
Sent: Sunday, July 9, 2017 5:01 PM
To: Rational Developer for IBM i / Websphere Development Studio Clientfor System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: RE: [WDSCI-L] RDI 9.5.1.2 double-click monitor express does not work with **free format.
Brian,
You are correct, my statements were overly harsh, but double-clicking works in NotePad, Notepad++, Word, Visual Studio, Eclipse, LPEX but not in RDI 9.5.1.2 debug editor using the **free format starting in column one, like other languages. <frown>
But, that Double-Click for the Debug-Editor can be set here:
******************************************************************
window > preference > Run/Debug > Compiled Debug > Debug Editors
******************************************************************
Activate the check box for "Double-click in Debugger Editor to add monitored expression"
So, using RDI 9.5.1.2 to select embedded SQL, I can select the SQL Statements. And then do > Edit > source > Launch SQL Scripts...
I want to change a Word in the SQL Statement. I usually double-click to select and then overwrite it. Instead, IBM runs selects the word, and then immediately select the whole SQL Statement and proceeds to EXECUTE IT! WTF???
At least in IBM Data-Studio, it has F5=Run (Run Selected) SQL Script, like Visual Studio! Cool! And I have the option to re-map the shortcut-key too!!!
<Joy Joy> So, using IBM Data-Studio, I can Double-Click to select a word! <Big Smile>
I guess some out there *might* like to be able to double-click to run the entire sql statement. I do NOT like it at all. It is very inconsistent!
Please Advise how I turn off that STUPID option to run the entire SQL statement on a double-click, which should select a word! NOT RUN the whole Statement!
<disappointment>
Strange in the ACS 5250 Emulator you can double-click a word in select it. But, not in ACS Run SQL Scripts? Where is the consistency?
So in LPEX you can double-click to select a word. But not in the Debug Editor in columns 1-5? Where is the consistency? I guess they HARD-CODED it for the 1950's Punch-Card format... <Frown>
-Ken Killian-
-----Original Message-----
From: Ken Killian
Subject: Re: [WDSCI-L] RDI 9.5.1.2 double-click monitor express does not work with **free format.
Hi,
Open PMR 05324,442,00 for this issue, here is some sample "dummy" code to demonstrate the error:
**free
dcl-s myvar int(10);
myvar = 1;
*inlr = *on;
return;
double-click on the variable "myvar" in the *LISTING debug inside of RDI 9.5.1.2. And it does not add the monitors...
(Need to turn on that option in the preferences)
If you shift all the code except for the **free to Punch-card-Column-08, and then the double-click works...
RDI does NOT fully support **free in debug mode. Unless you shift all your code over to Punch-card-Column-08.
=========================
I think the last comment is a little harsh, Ken. Yes, there are some inconsistencies in Debug between *SOURCE/*LISTING views when using **FREE.
Well spotted and well done for submitting a PMR.
However, whilst the double-click may not work (as you describe), it is still possible to mouse select/highlight the variable, then right--click and Monitor Expression. No need to reformat any source.
BTW, where did you find the "option in the Preferences"? Darned if I can find it.
Brian.
midrange.com
