From: Serge Rielau on
Lennart wrote:
> On Sep 8, 1:49 am, Serge Rielau <srie...(a)ca.ibm.com> wrote:
>> For typed tables DB2 supports that exact syntax for "reference columns".
>
> Do you know if it ever has been discussed for normal tables?
Discussed and prototyped. But never brought forward to ANSI.
This was 13 years ago.
I was a student then working on OO in Datajoiner :-)

Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
From: Lennart on
On 8 Sep, 13:11, Serge Rielau <srie...(a)ca.ibm.com> wrote:
> Lennart wrote:
> > On Sep 8, 1:49 am, Serge Rielau <srie...(a)ca.ibm.com> wrote:
> >> For typed tables DB2 supports that exact syntax for "reference columns".
>
> > Do you know if it ever has been discussed for normal tables?
>
> Discussed and prototyped. But never brought forward to ANSI.

A real pity IMO. It would remove a lot of clutter from the average sql
query, and improve both readability and writability.

> This was 13 years ago.
> I was a student then working on OO in Datajoiner :-)
>

You have come a long way since ;-)


/Lennart