Simple Search query using SQL

[A. A. Smith]

Hi,

I want to do a simple search query using sql. My sql
statement is as follows:

SELECT DISTINCT
SHORT_TITLE, LINE_OF_BUSINESS, LOB_NAME, OPEN_DATE,
PORTFOLIO_MGR, REL_OFFICER, TAX_OFFICER,
ACCT_CLASS,CLASS_NAME, SWITCH_FROM_ACCT
FROM
GEMS.V_AMS_ACCOUNTS_II
WHERE
ACCOUNT_NUMBER ="12345678"

I tried using the menu items Query/SQL Specific/Data
Definition.

But it's not working. I'm connecting to a DB2 table. The
error message I'm getting is "could not find
file "gems.mdb" but that doesn't make any sense to me!

Please help.

Thanks

 

[Carl Williams]

I suppose that you are trying to make a pass through query. Are you sure
that you use the correct driver ? It looks as if Access is expecting another
Access database rather than ad DB2 database. Try to reconfigure the ODBC
connection to point to the right location.

Carl