From: Serge Rielau on 8 Sep 2009 07:11 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 8 Sep 2009 11:43
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 |