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

SQL Error in DB2 and MS Access

P: 19

I am new to DB2. From the command center when I run this query I get the error given below the query :

Select a.tk_serial_external, a.tk_serial_internal, b.ush_revenue, c.ush_revenue,
from tk.import_ticket as a inner join tk.turn_daily_detail as b
on a.tk_serial_external = b.tk_serial
inner join tk.tck_sale_details as c
on a.tk_serial_internal = c.tk_serial
where b.ush_revenue <> c.ush_revenue

DBA2191E SQL execution error. A database manager error occurred. : [IBM][CLI Driver][DB2/6000] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014

Also, when I run that same query from MS Access, I get an 'ODBC Call Failed' error. I have created linked tables in accessfor the tables used in this query.

Anybody able to help me on this ?

Thanks in Advance.
Jul 19 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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