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

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

P: n/a
Hi,

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

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

Jan 8 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Vivek wrote:
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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Jan 8 '07 #2

P: n/a
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 ?

Serge Rielau wrote:
Vivek wrote:
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

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Jan 9 '07 #3

P: n/a
Vivek wrote:
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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Fo...Forum2006.html
Jan 9 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.