<div>
It looks like you're using a &quot;naming convention&quot; of *SQL, so the database is looking for tables in a schema called NORMANR (which is probably you're user-id).<br />
<br />
The easiest and quickest solution would be to qualify the table-name with the schema (library) where the table lives.<br />
<br />
e.g.<br />
SELECT DISTINCT GMFUND from MySchema.GM200AP WHERE GMFYR = '14'<br />
<br />
(Of course, replace &quot;MySchema&quot; with the library-name on your system.)<br />
<br />
HTH,<br />
DaveSlash
</div>


It looks like you're using a "naming convention" of *SQL, so the database is looking for tables in a schema called NORMANR (which is probably you're user-id).

The easiest and quickest solution would be to qualify the table-name with the schema (library) where the table lives.

e.g.
SELECT DISTINCT GMFUND from MySchema.GM200AP WHERE GMFYR = '14'

(Of course, replace "MySchema" with the library-name on your system.)

HTH,
DaveSlash

<div>
This naming thing causes headaches for the vast majority of folks when they first start with ODBC/JDBC/OLEDB/ADO.NET database connectivity to IBM i DB2 - including me.
</div>


This naming thing causes headaches for the vast majority of folks when they first start with ODBC/JDBC/OLEDB/ADO.NET database connectivity to IBM i DB2 - including me.

<div>
<div class="content wysiwyg-content">
Running a vb script to create an Access database from AS/400 data and getting an err, yet the table is in the system:<br />
<br />
Screenshot with error, AS/400 screen and the script:<br />
<br />
<a href="http://www.screencast.com/t/Nk6ukzq9r" rel="ugc">http://www.screencast.com/t/Nk6ukzq9r</a><br />
<br />
I think the sql select statement is the point of failure.<br />
How am I supposed to write the select statement?<br />
Am I missing something/
</div>
</div>


Running a vb script to create an Access database from AS/400 data and getting an err, yet the table is in the system:

Screenshot with error, AS/400 screen and the script:

http://www.screencast.com/t/Nk6ukzq9r

I think the sql select statement is the point of failure.
How am I supposed to write the select statement?
Am I missing something/

AS/400 ODBC Connection

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.