On 5 Mar 2007 08:45:44 -0800, "scorpion53061"
<kellyjmartens@gmail.comwrote:
Quote:
>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.
