RE: SQL question

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>For traditional as400 library list searching, you need to use the
*SYSTEM
>naming convention 

And _please_ do that, do NOT do what the IBM examples all do and write
your select statements like "select ItemNo, Description from
library.item" 

You'll have one hell of a fun time when you have to use "testlib.item"
for testing and "prodlib.item" for production, and "mylib.item" for
development. All the external interfaces to SQL (JDBC, ODBC, OLEDB,
.NET) allow you to tell SQL to use the system naming convention in the
connection string.

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)