Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to view Access SQL statements after ODBC to DB2

Status
Not open for further replies.
pheffley

pheffley

MIS
Jun 2, 2003
38
US
I am running an MS Access 2K front end that hits a DB2 db. I need to view the translated/formatted SQL that DB2 gets to do some performance tuning. I can't simply copy and paste the Access SQL into the DB2 analyzer. I could change the statement manually, but I have a ton of queries so this option isn't practical. I connect to DB2 V6 via DB2 Connect V8.

Thanks for the help!

Paul
 
Status
Not open for further replies.

Similar threads

Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
413
Rudraya
Rudraya
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
399
dcern
dcern
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
668
k5tm
k5tm
Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
140
Antonius222
Antonius222
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
377
acoronel
acoronel

Part and Inventory Search

Sponsor

Back
Top