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

Error In SQL Statement

P: n/a
My Visual Studio 2005 Query Window reports the following error when
this query runs. Any idea what might be causing it? Thanks for any
help. I have tried subsitituing for the parameter a fixed number and
same error. I also have established it does connect and close properly
with my connection string.

[DB2/LINUX] SQL0952N Processing was cancelled due to an interrupt.
SQLSTATE=57014
SELECT F4211.SDITWT as grs_wgt, F5549110.BLDOCO as order_no,
F5549110.BLSRTX as prod_code,
F5549110.BLLOT1 as run_num, F5549110.BLLOTN as skid_num,
F5549110.BLZ55BSWT as bs_wgt,
F564108.IOZ55USR08 as id_barcode, F564108.IOZ55USR01 as width,
F564108.IOZ55USR03 as length,
F564108.IOZ55USR09 as desc1, F4211.SDVR01, F4211.SDVR02,
F5549110.BLSQOR, F5549110.BLITM, F5549110.BLUOM
FROM (PRODDTA.F5549110 F5549110
LEFT OUTER JOIN PRODDTA.F4211 F4211
ON (F5549110.BLDOCO=F4211.SDDOCO)
AND (F5549110.BLLNID=F4211.SDLNID))
LEFT OUTER JOIN PRODDTA.F564108 F564108
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM))
AND (F5549110.BLLOTN=F564108.IOLOTN)
WHERE F5549110.BLDOCO=?

Mar 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 5 Mar 2007 08:45:44 -0800, "scorpion53061"
<ke***********@gmail.comwrote:
>My Visual Studio 2005 Query Window reports the following error when
this query runs. Any idea what might be causing it? Thanks for any
help. I have tried subsitituing for the parameter a fixed number and
same error. I also have established it does connect and close properly
with my connection string.

[DB2/LINUX] SQL0952N Processing was cancelled due to an interrupt.
SQLSTATE=57014
SELECT F4211.SDITWT as grs_wgt, F5549110.BLDOCO as order_no,
F5549110.BLSRTX as prod_code,
F5549110.BLLOT1 as run_num, F5549110.BLLOTN as skid_num,
F5549110.BLZ55BSWT as bs_wgt,
F564108.IOZ55USR08 as id_barcode, F564108.IOZ55USR01 as width,
F564108.IOZ55USR03 as length,
F564108.IOZ55USR09 as desc1, F4211.SDVR01, F4211.SDVR02,
F5549110.BLSQOR, F5549110.BLITM, F5549110.BLUOM
FROM (PRODDTA.F5549110 F5549110
LEFT OUTER JOIN PRODDTA.F4211 F4211
ON (F5549110.BLDOCO=F4211.SDDOCO)
AND (F5549110.BLLNID=F4211.SDLNID))
LEFT OUTER JOIN PRODDTA.F564108 F564108
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM))
AND (F5549110.BLLOTN=F564108.IOLOTN)
WHERE F5549110.BLDOCO=?

================================================== ====
db2 =? sql952
SQL0952N Processing was cancelled due to an interrupt.

Explanation:

The user may have pressed the interrupt key sequence.

The statement processing is terminated. Some changes may have
been applied to the database, but not committed, before
termination occurred.

Federated system users: this situation can also be detected by
the data source.

User Response:

Continue the application.

If installing the sample database, drop it and install the
sample database again.

sqlcode : -952

sqlstate : 57014
================================================== ====

I'd guess a timeout. An outer join on an outer join may take a few
minutes. If you can, run the query in the CLP first to verify it is
running. If it takes a while, you may need to adjust the timeout value
of you DB connection object.

B.
Mar 5 '07 #2

P: n/a
On Mar 5, 11:00 am, Brian Tkatch <N/Awrote:
On 5 Mar 2007 08:45:44 -0800, "scorpion53061"

<kellyjmart...@gmail.comwrote:
My Visual Studio 2005 Query Window reports the following error when
this query runs. Any idea what might be causing it? Thanks for any
help. I have tried subsitituing for the parameter a fixed number and
same error. I also have established it does connect and close properly
with my connection string.
[DB2/LINUX] SQL0952N Processing was cancelled due to an interrupt.
SQLSTATE=57014
SELECT F4211.SDITWT as grs_wgt, F5549110.BLDOCO as order_no,
F5549110.BLSRTX as prod_code,
F5549110.BLLOT1 as run_num, F5549110.BLLOTN as skid_num,
F5549110.BLZ55BSWT as bs_wgt,
F564108.IOZ55USR08 as id_barcode, F564108.IOZ55USR01 as width,
F564108.IOZ55USR03 as length,
F564108.IOZ55USR09 as desc1, F4211.SDVR01, F4211.SDVR02,
F5549110.BLSQOR, F5549110.BLITM, F5549110.BLUOM
FROM (PRODDTA.F5549110 F5549110
LEFT OUTER JOIN PRODDTA.F4211 F4211
ON (F5549110.BLDOCO=F4211.SDDOCO)
AND (F5549110.BLLNID=F4211.SDLNID))
LEFT OUTER JOIN PRODDTA.F564108 F564108
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM))
AND (F5549110.BLLOTN=F564108.IOLOTN)
WHERE F5549110.BLDOCO=?

================================================== ====
db2 =? sql952

SQL0952N Processing was cancelled due to an interrupt.

Explanation:

The user may have pressed the interrupt key sequence.

The statement processing is terminated. Some changes may have
been applied to the database, but not committed, before
termination occurred.

Federated system users: this situation can also be detected by
the data source.

User Response:

Continue the application.

If installing the sample database, drop it and install the
sample database again.

sqlcode : -952

sqlstate : 57014
================================================== ====

I'd guess a timeout. An outer join on an outer join may take a few
minutes. If you can, run the query in the CLP first to verify it is
running. If it takes a while, you may need to adjust the timeout value
of you DB connection object.

B.- Hide quoted text -

- Show quoted text -
Thank you for yoru help. I ran it with ConnectionTimeout set to 0 in
connections string and same error returned.

Mar 5 '07 #3

P: n/a
Althou, this last part doesn't violate syntax.
.......
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM))
AND (F5549110.BLLOTN=F564108.IOLOTN)
WHERE F5549110.BLDOCO=?

It might be worth to try to rewrite as following.
.......
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM)
AND (F5549110.BLLOTN=F564108.IOLOTN))
WHERE F5549110.BLDOCO=?

Mar 6 '07 #4

P: n/a
On 5 Mar 2007 09:19:23 -0800, "scorpion53061"
<ke***********@gmail.comwrote:
>On Mar 5, 11:00 am, Brian Tkatch <N/Awrote:
>On 5 Mar 2007 08:45:44 -0800, "scorpion53061"

<kellyjmart...@gmail.comwrote:
>My Visual Studio 2005 Query Window reports the following error when
this query runs. Any idea what might be causing it? Thanks for any
help. I have tried subsitituing for the parameter a fixed number and
same error. I also have established it does connect and close properly
with my connection string.
>[DB2/LINUX] SQL0952N Processing was cancelled due to an interrupt.
SQLSTATE=57014
>SELECT F4211.SDITWT as grs_wgt, F5549110.BLDOCO as order_no,
F5549110.BLSRTX as prod_code,
F5549110.BLLOT1 as run_num, F5549110.BLLOTN as skid_num,
F5549110.BLZ55BSWT as bs_wgt,
F564108.IOZ55USR08 as id_barcode, F564108.IOZ55USR01 as width,
F564108.IOZ55USR03 as length,
F564108.IOZ55USR09 as desc1, F4211.SDVR01, F4211.SDVR02,
F5549110.BLSQOR, F5549110.BLITM, F5549110.BLUOM
FROM (PRODDTA.F5549110 F5549110
LEFT OUTER JOIN PRODDTA.F4211 F4211
ON (F5549110.BLDOCO=F4211.SDDOCO)
AND (F5549110.BLLNID=F4211.SDLNID))
LEFT OUTER JOIN PRODDTA.F564108 F564108
ON ((F5549110.BLMCU=F564108.IOMCU)
AND (F5549110.BLITM=F564108.IOITM))
AND (F5549110.BLLOTN=F564108.IOLOTN)
WHERE F5549110.BLDOCO=?

================================================= =====
db2 =? sql952

SQL0952N Processing was cancelled due to an interrupt.

Explanation:

The user may have pressed the interrupt key sequence.

The statement processing is terminated. Some changes may have
been applied to the database, but not committed, before
termination occurred.

Federated system users: this situation can also be detected by
the data source.

User Response:

Continue the application.

If installing the sample database, drop it and install the
sample database again.

sqlcode : -952

sqlstate : 57014
================================================= =====

I'd guess a timeout. An outer join on an outer join may take a few
minutes. If you can, run the query in the CLP first to verify it is
running. If it takes a while, you may need to adjust the timeout value
of you DB connection object.

B.- Hide quoted text -

- Show quoted text -

Thank you for yoru help. I ran it with ConnectionTimeout set to 0 in
connections string and same error returned.
Is it returned at a specific time?

Visual Studio has its own timeout value. It is a property of the
database object. Specifically, set that one.

B.
Mar 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.