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_ext ernal, a.tk_serial_int ernal, b.ush_revenue, c.ush_revenue, b.date
from tk.import_ticke t as a inner join tk.turn_daily_d etail as b
on a.tk_serial_ext ernal = b.tk_serial
inner join tk.tck_sale_det ails as c
on a.tk_serial_int ernal = c.tk_serial
where b.ush_revenue <> c.ush_revenue
DBA2191E SQL execution error.
com.ibm.db.Data Exception: 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.
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_ext ernal, a.tk_serial_int ernal, b.ush_revenue, c.ush_revenue, b.date
from tk.import_ticke t as a inner join tk.turn_daily_d etail as b
on a.tk_serial_ext ernal = b.tk_serial
inner join tk.tck_sale_det ails as c
on a.tk_serial_int ernal = c.tk_serial
where b.ush_revenue <> c.ush_revenue
DBA2191E SQL execution error.
com.ibm.db.Data Exception: 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.