MichaelQuigley | 28 Jan 13:48 2015

Re: RDi 9.1.1 Database Development: Show System-Name and/or Alias name

I think we're adding to poor Ken's frustration here. When he says "System 
Name", he's using SQL terminology. He's referring to the 10-character 
field name used by native (and/or SQL) to refer to a field--NOT to the 
name of the system to which he's connected.

(Jon, I'm replying to your post, but we've all been off on Ken's issue.)

"WDSCI-L" <wdsci-l-bounces <at> midrange.com> wrote on 01/27/2015 05:35:58 PM:
> ----- Message from Jon Paris <jon.paris <at> partner400.com> on Tue, 27 
> Jan 2015 15:20:20 -0500 -----
> 
> To:
> 
> Wdsci-L <wdsci-l <at> midrange.com>
> 
> Subject:
> 
> Re: [WDSCI-L] RDi 9.1.1 Database Development: Show System-Name and/
> or Alias name
> 
> Right click on the connection and select Properties.
> 
> From the list you can select Schema and Table filters.  By default 
> they are turned off but deselecting the check box allows you to 
> specify filter strings.
> 
> Still will probably not give you what you want but …
> 
> I _think_ there are some JDBC connection string properties that can 
> be set to change the behaviours but right now I can’t for the life 
(Continue reading)

MichaelQuigley | 28 Jan 13:44 2015

Re: Outline View

I think the find dialog sequence was fixed provided you turn off 
"Incremental find" in preferences. With it off, the tab sequence flows as 
most people would expect. With "Incremental find" turned on, the tab will 
skip from the "Find" string box to the check boxes--blowing right past the 
"Replace" box. (Pardon me if my names aren't correct, I don't have access 
to RDi right now.

Michael

"WDSCI-L" <wdsci-l-bounces@...> wrote on 01/27/2015
05:35:58 PM:
> ----- Message from Mike Hockings <hockings@...> on Tue, 27 
> Jan 2015 17:35:07 -0500 -----
> 
> To:
> 
> Rational Developer for IBM i / Websphere Development Studio Client 
> for System i & iSeries <wdsci-l@...>
> 
> Subject:
> 
> Re: [WDSCI-L] Outline View
> 
> 
> Hey Kurt,
> 
> I believe you are right as I remembered that too.  I searched and found:
> APAR SE59296 - RDI 9.1.0 LPEX EDITOR FIND DIALOG TAB TRAVERSAL ORDER IS
> INCORRECT
> Which shows as  fixed for 9.1.1 but it seems to be one of those things 
(Continue reading)

darren | 27 Jan 22:58 2015

reinstalling 9.1 and can't find 9.1.1


I had to blow away 9.1.1 and reinstall because I needed to downgrade
Installation Manager to 1.7.3.  The reason I had to do all this was because
of an issue with our proxy server at 1.8.0 and up.  Anyway, IM can't find
the update to 9.1.1 from 9.1, so, wasn't that available as an update
through IM?

--

-- 
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@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

Buck Calabro | 27 Jan 21:39 2015
Picon

Re: RDi 9.1.1--> More issues on outline view/Code Assist. Sometimes it works, sometime it does NOT. (Go back to PREVIOUS VERSION!)

On 1/27/2015 2:41 PM, Bob Schuch wrote:
> Thank you for your input, Kurt. I am the "Co-worker" referenced in Ken's post.

Welcome to the list!

> The actual situation is that I'm trying to code a call to that subprocedure in another section of the
program. Code assist has been flaky at best for me, so I thought I could position the outline view so I could
see the subprocedure name while I was typing it. Besides the fact that I'm typing in another section of
code, there also won't be a reference to it because I'm in the process of CREATING the reference!

I've been struggling to remember to use the Outline view, mostly because
I have more than a decade of muscle memory using Code / WDSC / RDi
without it!  So I follow Outline View threads with great interest.
Thanks for posting!

Anyway, in my ignorance, I tend to use Ctrl-2.  So to synthesise my old
habits with the Outline View, here's what I did to create a new
subprocedure call:

Outline View, filter the list so I don't have to scroll through a
hundred subprocedures :-)
Outline View, click the subprocedure I want to use.
F12 to edit
Ctrl-Shift-Right to select the subprocedure name
Ctrl-C to copy the name.  I'll be using it very soon :-)
Ctrl-T to move to the top
Ctrl-2 to open a new editor pane
(right editor has focus)
Scroll/find/locate bookmark/locate TODO
Put in the new block of code that's going to use the subprocedure.
(Continue reading)

Ken Killian | 27 Jan 18:39 2015

RDi 9.1.1 Database Development: Show System-Name and/or Alias name

Hi,

In RDi 9.1.1 in the Database development view...

Is there a way to do a filter by the system-name like you can do in iNavigator.

Of course we have tons of files, and I need to filter to the file by the system name. And apparently Database
view has no way, that I can find how this is done... <frown>

Just wondering if I am missing something. Or iNavigator is my only solution. It would be "nice" to stay in a
single package.

It seems to work the same in Data Studio 4.1, unable to find or filter by the system name.

Oh well, at least it works in iNavigator.

PS. We have modernized many files, but not all. RPGLE programs can use the old-system name. And new Embedded
SQL can use the friendly longer/alias name. 

-Ken Killian-
--

-- 
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@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

(Continue reading)

MichaelQuigley | 27 Jan 04:25 2015

Re: Long SQL statements (was: Outline View)

Vern,

Yes, I would hope there's still work being done on it. If you just type 
one big long line in (going past column 80), that's fixed in 9.1.1. 
There's a setting to enable it. Follow the trail Windows, Preferences, 
Remote Systems, Remote Systems LPEX Editor, IBM i Parsers, ILE RPG, and 
finally Free-form SQL Formatting. There's now a checkbox for "Treat  text 
beyond 80 characters as SQL code to be auto-formatted". I just tested that 
this morning and it works.

However if you paste in your SQL statement from a series of shorter lines, 
it still has problems with the text before column 7 or so. (Maybe it's the 
first 5 columns like you said. Anyway the results are seriously ugly--so 
you'll probably still need to go through TextPad or something. Doing what 
you talk about (adding 7 blanks at the head of each line) works. I was 
just looking at some code and I still get a yellow triangle telling me 
there's an unexpected token. The statement looks clean to me and runs fine 
in STRSQL (or SQL Scripts, if you prefer). I don't see anything wrong , 
but I can't spent much time on it today.

Michael

"WDSCI-L" <wdsci-l-bounces@...> wrote on 01/25/2015
12:16:47 AM:
> ----- Message from Vernon Hamberg <vhamberg@...> on Sat,
> 24 Jan 2015 23:15:47 -0600 -----
> 
> To:
> 
> Rational Developer for IBM i / Websphere Development Studio Client 
(Continue reading)

Buck Calabro | 26 Jan 22:50 2015
Picon

Re: CTRL-C issue

On 1/26/2015 3:34 PM, Greg Wilburn wrote:
> Buck,
> I know I can "get around" this, but to me it's an issue.  I shouldn't have to be that exacting when selecting
rows for a copy.  CTRL-C should be CTRL-C no matter where the cursor is positioned within the source member.

I agree.  My reply wasn't intended to convince you to change your muscle
memory.  After learning that Ctrl-Insert performs the copy all the time,
I figured I'd share that information in case someone were motivated to
tinker the keyboard shortcuts in the hopes of finding which (if?) of the
many 'When:' states is covered by the prefix area.
Preferences > General > Keys

Alternately, what about dropping the troublesome prefix area altogether?
 I myself don't use the line numbers for much of anything except during
debugging.

Escape (to get to the command line) set prefixArea off

Again, to be clear, I'm not suggesting that my way is better.  I'm
replying to you of course, but I'm also thinking of the archives and the
lurkers who might be following this thread.

-- 
  --buck

'I had nothing to offer anybody except my own confusion' - Jack Kerouac
Vanity, thy name is programmer!
--

-- 
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries 
(WDSCI-L) mailing list
(Continue reading)

Buck Calabro | 26 Jan 21:31 2015
Picon

Re: CTRL-C issue

On 1/26/2015 3:01 PM, Greg Wilburn wrote:

> I use mouse to select several lines of source code by click-n-drag... usually like this, and I'm usually
copying from a blank row to another blank row (i.e. a block of code):
> 
> 
>          if shpr_nbr <> *blanks;
>            shpr_nbr = %xlate(lower:upper:shpr_nbr);
>            shpr_nbr = Txt_Scrb(shpr_nbr:digits + upper);
>          endif;
> 
> If during the click-n-drag, you release the "click" with the mouse cursor over the line sequence numbers
(or very close to them), upon release you can see the cursor blinking to the left of the source line (with the
text highlighted).  If this is the case, CTRL-C will not copy.

9.1.1 behaviour confirmed.

Use Ctrl-Insert and the copy works.  I couldn't suss out how to modify
the key binding to use Ctrl-C instead.

Right clicking the mouse and choosing Copy also performs the copy.

-- 
  --buck

'I had nothing to offer anybody except my own confusion' - Jack Kerouac
--

-- 
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@...
(Continue reading)

Buck Calabro | 26 Jan 20:51 2015
Picon

Re: CTRL-C issue

On 1/26/2015 1:44 PM, Greg Wilburn wrote:
> CTRL-C does not seem to function for copying selected text if (after the text has been selected) the cursor
is positioned before the source line number.  Is this a known issue in 9.1.0?  Is it fixed in 9.1.1?

I'm on 9.1.1 and will test this but I confess I don't understand the
steps.  I pretty much use the cursor keys to select text, and when doing
that I can't move to the prefix area and keep the text selected.

Could you post the steps you're taking so I can try it myself?

-- 
  --buck

'I had nothing to offer anybody except my own confusion' - Jack Kerouac
--

-- 
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@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

Greg Wilburn | 26 Jan 19:44 2015

CTRL-C issue

CTRL-C does not seem to function for copying selected text if (after the text has been selected) the cursor
is positioned before the source line number.  Is this a known issue in 9.1.0?  Is it fixed in 9.1.1?
--

-- 
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@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.

Buck Calabro | 26 Jan 18:03 2015
Picon

Installation Manager

> Normally, I just download the trial, and install
> the license key. Haven't used that repository
> stuff myself before...

Well...

The trial contains IBM Installation Manager which has embedded within it
the repository URL for the version of software you are installing.  IM
installs several different pieces of IBM / Rational software; it's not
just for RDi.  Anyway, you've _always_ used IM and repositories to
install RDi and it was under the covers so to speak.

Start > All Programs > IBM Installation Manager  I usually right click
and Run as Administrator because of the Windows 7 'security' features.
Once running, the first thing to check is the version of IM.  IM always
wants to upgrade itself to the latest version.  Help > About tells me
that my IM is at 1.8.1.

File > Preferences shows the list of repositories that IM knows about.
My list includes RDi 7.0, 8.5, 9.0, 9.1 as well as Data Studio 3.6 and
4.2  For 9.0, I see
https://www.ibm.com/software/repositorymanager/com.ibm.rational.developer.ibmi.v90
https://www.ibm.com/software/repositorymanager/com.ibm.offering.rdpower.v90

...and they are both unchecked and greyed out.  When I check them and
click on the 'Test Connections' button, I get a verification that all
the selected repositories are connected.  Apply, then OK and you should
be able to Install the 'new' 9.0 (it'll be new to your machine, I guess).

--

-- 
(Continue reading)


Gmane