I am running Hibernate 2.1.7. I am attaching to an existing database schema on an iSeries (AS/400). I have a physical file on the iSeries that has multiple members. How to I tell Hibernate to grab a specific member in a physical file that has multiple members?

OK, I found the answer to my question. Just in case anyone else has this issue.

You use a CREATE ALIAS. Here is an example

If you have a physical file name SALES that has a member for each month and you want to get JANUARY, here is the SQL command

CREATE ALIAS MYLIB/SALES_JANUARY FOR MYLIB/SALES(JANUARY)

Then you can use a select statement like...

SELECT * FROM SALES_JANUARY.

My only question here is, is there a way in Hibernate to dynamically map a table? With this type if issue, I will not always know the table name by which I am pulling the data. In my situation, the multiple members have a dynamic name (by seq number). I really would like to use HQL if at all possible.

Thanks