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
Hi,

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, b.date
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.

com.ibm.db.DataException: 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.