<div>
So there is no syntax to access it directly?
</div>


So there is no syntax to access it directly?

<div>
<br />
You could do an OvrDBf command before your select to point it at a certain member, but there is no way to access it directly in one shot.<br />
<br />
HTH,<br />
DaveSlash<br />

</div>



You could do an OvrDBf command before your select to point it at a certain member, but there is no way to access it directly in one shot.

HTH,
DaveSlash


<div>
Thanks very much, I've passed that on to the DB2 developer (who knows what you're talking about) and thats solved the problem.<br />
<br />

</div>


Thanks very much, I've passed that on to the DB2 developer (who knows what you're talking about) and thats solved the problem.



<div>
<div class="content wysiwyg-content">
I am accessing files through the iSeries IDBC driver like this:<br />
<br />
SELECT * FROM GQPL.F0901<br />
<br />
Does anyone know the ODBC SQL syntax for accessing a multi member file?<br />

</div>
</div>


I am accessing files through the iSeries IDBC driver like this:

SELECT * FROM GQPL.F0901

Does anyone know the ODBC SQL syntax for accessing a multi member file?


Accesing  a mutli member file through ODBC SQL

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.