Re: trees, WITH operator, and traversal

in a thread in this group, the notion of having one table with codes and values,
as proposed here, was called that. the notion was treated negatively by the correspondents. i have managed (with a suggestion from an ibm'er) to get it almost worked out. does require some db2 specific syntax, however. said syntax (the WITH...), is part of sql-99; but not 92.

if it works out, then users will be able to define arbitrary keyComponents and Values so that context specific html select lists can be generated. that's the goal. current implementation is the 5NF structure shown in SfS, page 444ff. while the users have accepted the notion of a fixed set of keys (levels), they're not thrilled with such a solution. and future support will require the dropping of that restriction.

toodles,
robert

jraustin1_at_hotmail.com (James) wrote in message news:<a6e74506.0112311213.d607b6d_at_posting.google.com>...
> > the context is the (in)famous One True Lookup Table problem
>
> What is the infamous One True Lookup Table problem?
Received on Wed Jan 02 2002 - 18:00:26 CET