× 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.


  1.  Home
  2. MIDRANGE-L
  3. July 2013

RE: iSeries Navigator woes

Tom,

Interesting; some see the >grey< issue and some don't.

Seems counter-productive to omit a filter just when it would be most useful ?

Anybody here from the IBM i team ?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Wednesday, July 31, 2013 9:57 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries Navigator woes

Gary-

I also do not have any "include" option on the list of tables in a schema (the include or F11 option is greyed out). I assumed it was due to the fact that the table list is not all there in local memory (which seems to be why it takes forever to scroll).

Many other JDBC interfaces I have used are able to give me the list of table very fast.

-Tom Stieger
IT Manager
California Fine Wire




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Wednesday, July 31, 2013 5:41 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries Navigator woes

Rob, two locations:
In the left pane expand Databases, select a Database, expand Schemas,
expand SchemaX, right-click Tables, click Customize this view
which opens sub-menu with four options, 2nd of which is
"Include... F11" >grey<

Also, with Tables selected as described above,
click View on Sys i Nav menu bar, click Customize this view,
"Include... F11" >grey<

Thanks!

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, July 31, 2013 5:26 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries Navigator woes

What were you clicked on in the left when you tried that? It gets greyed out when you are clicked on stuff you can't customize.
Drilling down...
MyIBMi - grey. This is not how you choose to show just "Basic Operations"
or "Work Management"
Databases - grey. Doesn't allow you to choose just to show the local database vs any you defined in WRKRDBDIRE.
MyIBMi again - grey. Doesn't allow you to choose between "Schemas", "Database Maintenance", etc Schemas - not grey. Can choose which schemas (libraries) to display.
Schema (library) name - grey. Cannot choose to show "All Objects", "Aliases", "Constraints", etc Tables - not grey. Pick and choose what tables you want to show.
clicking on any table in the right - not grey



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Gary Thompson <gthompson@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 07/30/2013 05:11 PM
Subject: RE: iSeries Navigator woes
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Thank you Buck,

Rob also helped with this and lo and behold: "Include" is >grey< on Tables/Customize this View (also on Menu bar/View/Customize this View)

My profile has *ALLOBJ,*IOSYSCFG,bla,bla - so I asked Sys Admin and he says he has not >blocked< any Sys i Nav options ?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Buck Calabro
Sent: Tuesday, July 30, 2013 12:47 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: iSeries Navigator woes

On 7/30/2013 1:46 PM, Gary Thompson wrote:
Hmm, sounds like a good lead, but I get lost . . .

I >think< I want to "Customize this view" at the Tables node under the
Schema which has the Tables I am interested in, but I have yet to see
a way to do this at any level below Schemas.

At Schemas in the Left Pane, I have a Databases tasks = "Select
schemas
to display"
and this does open a window with pretty good filter options . . . alas
nothing at a lower level has caught my eye . . .

Databases > Schemas > Tables
Right click Tables or press F11
On the General tab, select the radio button for 'Names that match'.
Under Condition, select 'Starts with'. Under Text, type the letters that your file names begin with.

I'm on 7.1

As an aside, I'm not really a GUI person. I like that completely empty green command line very much. Yet even I have managed to learn quite a few things from reading Rob's posts on iNav, and if I can - anyone can!
:-) I've found a plethora of very cool actions by right clicking pretty much anything and everything on the screen. I wish there was a tutorial on this stuff, but in the absence of that, thank you Rob!
--buck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
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.