Read from a specific member of a physical file

Yes, there IS a trick you're missing: creating an SQL alias to point to the member BEFORE retrieving the data.

I always create the _alias name as a combination of the tableName and the memberName so it's easy to know where I'm pointing.

Here's an example:

 
aConnection = jdbcDriver.connect(tableUrl,
tableProperties);	

selectStmt = stmt;
sqlStmt = (java.sql.Statement)
getSqlStatement(aConnection);

String _sql = "CREATE ALIAS " + _alias + " FOR " +
_tableName + " (" + _memberName + ") ";
sqlStmt.execute(_sql);

resultSet = sqlStmt.executeQuery(selectStmt); 

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Check out this live Q&A with Dave Slater and Jim Mason, How to best get started with WebSphere Development Tools.