odbc as/400

[ebarratt]

I am connection via an asp page and wanted to know if anyone knows a sql statement that will list all objects in a specific library. for instance:

strSql = "Select * from LibraryName" or something.

I know this isn't the correct forum for this but any help would be much appreciated.


Errol Barratt
work: 856-810-5712
home: 856-697-1593
*** If I post a question and you are bored then give me a call and share some off all that junk stored in your head, so that I may be a junkie too! 8)

 

[iSeriesCodePoet]

First all, moonleaf78, as a suggestion. Never post your phone #'s or email, unless you like lots of solisitors. They can seach google (or the like) and find your phone number.

2) I don't think this can be done via SQL. I know through java there are connectors that can easily get you this information. Mike Wills
AS400 Programmer

http://www.koldark.net

Please, if you find my post useful, let me know.