467,179 Members | 1,276 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

SQL Error in DB2 and MS Access


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
  • viewed: 1236

Post your reply

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

Similar topics

6 posts views Thread by Peter Frost | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.