On the As400, it is possible to create different members for a single file (multi-member). When using SQL, it is only possible to access the first member of that file. The data for the other members for all practical purposes becomes invisible to SQL.
We are moving away from multi member driven files, but we still have a few applications using them.
In order to SQL a specific member, I have found in IBM documentation that it is possible to create an ALIAS while pointing to specific member and then base your SQL file selection on that ALIAS.
The ALIAS approach necessitates 3 statements as follows:

"CREATE ALIAS QTEMP/SOURCETEMP FOR library/file (membername)
"SELECT SRCDTA FROM QTEMP/SOURCETEMP"
"DROP ALIAS QTEMP/SOURCETEMP"

This approach would work, but would be rather cumbersome.
Using WebFOCUS, is it possible to gain direct access to specific members without the use of an ALIAS? Does the As400 Adapter offer flexibility for this? Examples anyone?

This message has been edited. Last edited by: Kerry,

Hi MicA,

From our technicals: In order to access Physical files that contain multiple members, you should add the DB Heritage Files adapter.
When you go to add an adapter go to the Sequential and Indexed category, then expand DB Heritage Files then click the DB Heritage Files then configure.
That is all that is needed for this adapter, then you can right click on it and click "Create Synonym" there you can enter the library where they reside and/or filter further.

If additional help is needed, please open a case with Customer Support Services for assistance. You may either call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

I'll look into the DB Heritage Files Adapter. Thanks Kerry.