By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,750 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,750 IT Pros & Developers. It's quick & easy.

Query to DB2/UDB Tables

P: 1
A simple query, doing an inner join to one table and an outer join to 2 other tables with one variable input is taking forever.
I did some research and I saw that access had created 3 actual queries to DB2.
One outer join and 2 full scans using the keys from the first query.
If I take the SQL view of the request and paste it into DB2, the one query takes about 5 minutes. If I run this from access 2003, jet engine 4, with latest updates, on XP, the query takes about 4 hours.

Q: How can I stop access from creating 3 queries instead of just running the select that I can see in the SQL view.

Thanks,

Andet
Oct 23 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Access offers the possibility to define a Pass Through query. (One of the options of the Query menu).
Checkout the description in the helpfile (F1).

Basically it requires an SQL-text (in DB2 syntax) that's send to the DB2 database engine and just the result will be returned.

Nic;o)
Oct 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.