In iSeris SQL you can do a CREATE ALIAS to a specific member in the file using the following code:
CREATE ALIAS QTEMP/alias_name FOR lib/file (member)
The alias name can be treated like a file such as doing a SELECT * from alias_name. It will be pulling data only from that member. When you are done using the alias, do a
DROP ALIAS alias_name
Don’t know, however, for sure if this will work in VB SQL.
An ALIAS is a SQL-specific way of accessing particular members. It is a SQL extension for DB2 on System i. You can also issue an OVRDBF command before issuing a SELECT (or DELETE, UPDATE or INSERT) to have the SELECT operate on a particular member. An override will remain in effect for the connection or until deleted and only affects that connection, while an ALIAS is a permanent object that’s available across the system.