Use the User Defined Table Function SCHEMAS located in library QSYS2
Select *
From Table (Schemas()) x;
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 Steve Richter
Gesendet: Monday, 11.6 2012 15:58
An: Midrange Systems Technical Discussion
Betreff: what is the sql way to list the libraries/schemas on the system?
I am using ODBC to connect from windows to an as400 database. What is the
SQL way to get a list of all the libraries on the system?
This is the SQL statement I am currently running:
select char(table_schema,10) libname, count(*) objcx from qsys2.systables
where substr(table_schema,1,1) not in ('Q', '#') group by table_schema
thanks,
FYI. Apparantly, based on the little research I have done, ODBC is the way
to go when accessing SQL server from a windows native client.
OleDB is deprecated. The newest versions of the SQL server native client
provide good performance thru ODBC.
http://msdn.microsoft.com/en-us/sqlserver/ff658532.aspx
--
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.