RE: System iAccess for Windows- ODBC Setup Library List

When we use DTS, the libraries listed in the ODBC library list field are used for the "browse" dialog.
--
Sean Porterfield


-----Original Message-----
From: Birgitta Hauser
Sent: Sunday, August 12, 2012 12:27
To: 'Midrange Systems Technical Discussion'
Subject: AW: System iAccess for Windows- ODBC Setup Library List

Just for information:

Only with system naming the library list will be searched to find unqualified specified tables or views, but only if no default (or current
library) is set.
In other words, if a default or current library list is set only this library/schema will be searched to find unqualified tables or views, even though System Naming is used.

Other database objects such as stored procedures or user defined functions are searched in the SQL Path.
The SQL Path is a kind of a library list because multiple schemas/libraries can be listed and *LIBL is an allowed special value.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Porterfield, Sean
Gesendet: Friday, 10.8 2012 19:41
An: Midrange Systems Technical Discussion
Betreff: RE: System iAccess for Windows- ODBC Setup Library List

Gah, I meant *SQL.
--
Sean Porterfield


-----Original Message-----
From: Porterfield, Sean
Sent: Friday, August 10, 2012 13:40
To: 'Midrange Systems Technical Discussion'
Subject: RE: System iAccess for Windows- ODBC Setup Library List

Ours is set to *SYS and just uses spaces to separate the libraries.
--
Sean Porterfield


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vidal, Concepcion
Sent: Friday, August 10, 2012 13:24
To: Midrange Systems Technical Discussion
Subject: RE: System iAccess for Windows- ODBC Setup Library List

Pete:

I changed the naming convention option from *SQL to *SYS but did not work.
I removed the commas and it did not work either...

Peter Vidal

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Friday, August 10, 2012 1:03 PM
To: Midrange Systems Technical Discussion
Subject: Re: System iAccess for Windows- ODBC Setup Library List

I am working from weak memory here but it seems to me that there was a difference between the way the library list was used when *SYS naming was used vs *SQL.

Something about that rings a bell but it has been a while since I used ODBC.

Pete Helgren
Value Added Software, Inc
www.petesworkshop.com
GIAC Secure Software Programmer-Java
--


This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.