AS/400 Pass-Through Queries

[KJBaham]

I've created the pass-through query as suggested in the
topic below about too many indexes. Now I am receiving an
ODBC call fail message. The message reads: [IBM][Client
Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0104 -
Token [was not valid. Valid tokens: <IDENTIFIER>. (#-104)

I've tired several things:
1. I tried saving the password in the ODBC Connect Str
2. I've tried not saving the password in the ODBC Connect
Str
3. I've tried leaving the ODBC Connect Str blank so that
I am prompted for a connection
4. I've tried running another query from a table that I
was able to link through a pass-through query. This query
was unsuccessful this way, but successful when based on
the linked table.

Thanks for any help

 

[Brian Camire]

I don't know if this will help, but pass-through queries must use the SQL
dialect of the database you're running them against (DB2/400 in your case),
not Access SQL.

The message:

"Token [ was not valid..."

suggests that your pass-through query contains a "[" character, and that
DB2/400 does not recognize it. Did you create the query by cutting and
pasting the SQL from a similar query in Access that was based on a linked
table? In Access SQL, the "[" character (along with the "]" character)
delimits table or column names. I don't know what the equivalent delimiter
in DB2/400 SQL is (or even if there is one). You might try `, ", or
removing the delimiters altogether.

Hope this helps.