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


  • Subject: RE: ODBC access to system catalog files
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Thu, 30 Mar 2000 17:06:59 -0500

I am a 'babe-in-the-woods' when it comes to ODBC and I've given 
you the extent of my knowledge.  Sorry.

My question on Ops Nav was how to see all databases on the 400 when 
I open the list and not just ones in my default library list.





dshaw@spartan.com on 03/30/2000 02:01:30 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: ODBC access to system catalog files

Comments in-line.

> -----Original Message-----
> From: Rob Berendt [mailto:rob@dekko.com]
> 
> Start
> Programs
> IBM AS/400 Client Access
> ODBC administration
> Select your AS/400
> Click on Configure
> Select the Performance Tab
> What do you have in OS/400 library view?

I've tried both "Default library list" and "All libraries on the system".  The
non-intuitive thing about "All libraries on the system" is that, although I get
a list of all the libraries when I browse for tables to query, if I select a
library that's not implicitly or explicitly in the "Default libraries" on the
Server tab, I can't see anything in it.  As a specific example, I can select
QSYS, and even with a profile with *ALLOBJ authority, I can't see a single file
in it.

Note: I'm testing using MS Query.  My co-worker is using MS Access.  I'm running
CA Express V4R4 with service pack SF60796 (current), he's running CA for
Win95/NT V3R1M3 with a recent service pack.  The /400 is V4R4 with cume C0049
installed, with HIPER and database group PTF's from about Feb 15th.
 
> Now, how do I fix this for Op's Nav database?

I don't understand your question.
 
> dshaw@spartan.com on 03/29/2000 05:06:19 PM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:   MIDRANGE-L@midrange.com@Internet
> cc:    
> Fax to:       
> Subject:      ODBC access to system catalog files
> 
> Hey, y'all!
> 
> I have a colleague here who would like to be able to view the 
> contents of the
> system catalog files in QSYS from MS Access.  We're finding 
> that we can't see
> any files in any library that's not in the user portion of 
> the ODBC library
> list, which is of course the *USRLIBL from the system value 
> plus any default
> libraries we put in the data source definition.  Any library 
> in the system
> portion of the library list can't be entered in the default 
> libraries, of
> course.  Is there any way around this?  I've looked for 
> documentation, but Info
> Center isn't playing nice and I haven't found anything 
> relevant yet in the
> Support Line Knowledge Base.  Any suggestions?  Thanks!
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.