SQL0012W Correlation without qualification has occurred for the column "<column>".

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vivek - 08 Jan 2007 06:28 GMT

Hi,

Can someone give an example of a query which produces the following
warning:

SQL0012W Correlation without qualification has occurred for the column
"<column>".

Reply to this Message

Serge Rielau - 08 Jan 2007 13:11 GMT

> SQL0012W Correlation without qualification has occurred for the column
> "<column>".

On which platform are you seeing this? I'm not aware of DB2 for LUW
producing such a warning...
Here is a scenario I would reverse engineer:
SELECT (SELECT x FROM SYSIBM.SYSDUMMY1) AS y FROM SYSDUMMY1 AS T(x)

x is a correlated column. The warning encourages you to use T.x to spell
the correlation out.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

Reply to this Message

Vivek - 09 Jan 2007 04:29 GMT

I don't see this warning. My real purpose is to simulate any warning
that may result out of a select query. I saw this specific code in the
Message reference and was wondering how to simulate it.
The query that you gave does not give any warning on execution. Can you
suggest an alternative ?

> > SQL0012W Correlation without qualification has occurred for the column
> > "<column>".
[quoted text clipped - 16 lines]
> WAIUG Conference
> http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

Reply to this Message

Serge Rielau - 09 Jan 2007 13:16 GMT

> I don't see this warning. My real purpose is to simulate any warning
> that may result out of a select query. I saw this specific code in the
> Message reference and was wondering how to simulate it.
> The query that you gave does not give any warning on execution. Can you
> suggest an alternative ?

No, it may be an old warning or it may be for a platform you don't have
(zOS, iSeries, VM)

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

Reply to this Message