RE: ODBC access to system catalog files

I'M AN IDIOT!!!

There are logicals in QIWS that are scoped over the system catalog files in
QSYS.  I put QIWS in the default libraries box and it works like a charm.  I
still don't understand why there's an option to display libraries that won't
show their contents, but for now we can do what we need to do.

Why am I an idiot?  I knew those logicals were there, but didn't realize that I
had never actually listed QIWS in the default libraries box in any of my tests.
Several documents said that QIWS is always in the *USRLIBL for the ODBC server
jobs whether it's specified or not, so I didn't even think about not being able
to see its contents unless it's specified explicitly.  Argghh...

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

P.S. Yes, Don Schenck, I know you already told me about the idiot thing.  Try
not to gloat too much, it's bad for your (mostly nonexistent) humility.

> -----Original Message-----
> From: Shaw, David 
> 
> 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
+---