RE: ODBC to AS/400 using Visual Basic 4.0

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

<another sigh>
Unfortunately, V4R1 does not support the ALIAS keyword.

Donald R. Fisher, III
Project Manager
The Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@roomstoreeast.com
<clip>
There is no way to access multiple members via a 'SELECT' clause alone.
You'll have to use SQL to define an ALIAS for the member, like:
"CREATE ALIAS MyAlias FOR LIBRARY.TABLENAME(MEMBERNAME);"

And then use MyAlias to access that particular member.

You can pass this SQL via ODBC and CREATE/DROP aliases dynamically, or just
create them on the '400 and use them permanently.
<clip>