SEO

#1 (**permalink**) 02-26-2008, 05:56 PM

Running a simple SQL statement trying to use renamed columns:

Select rrn( columns ) AS Counter,
Counter - 1000 AS Ordinal
FROM
SYSIBM.COLUMNS COLUMNS

I get an error that column "Counter" not in specified tables.

#2 (**permalink**) 02-26-2008, 05:56 PM

Dan

Is "COUNTER" a column in SYSIBM.COLUMNS?
You cannot reuse a column correlation name in the same select list.

What you should be able to do is this:
Select counter, counter - 1000 as ordinal
from (
Select rrn( columns ) AS Counter,
FROM
SYSIBM.COLUMNS COLUMNS) AS X

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 As Clause question