| Subject | computed column with max(value) of referening rows out of a child table |
|---|---|
| Author | burghard_w_v_britzke |
| Post date | 2004-07-09T09:51:55Z |
I want to
ALTER TABLE <PARENTS>
ADD <OLDESTCHILD> COMPUTED BY
(SELECT MAX (<BIRTHDATE>) FROM <CHILDREN> WHERE <PARENTS_ID> = PARENTS.ID;
but I get a
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 3, char 3
-select
what did I wrong?
ALTER TABLE <PARENTS>
ADD <OLDESTCHILD> COMPUTED BY
(SELECT MAX (<BIRTHDATE>) FROM <CHILDREN> WHERE <PARENTS_ID> = PARENTS.ID;
but I get a
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 3, char 3
-select
what did I wrong?