Re: What is a "code table"?
Date: Fri, 20 Jun 2003 22:51:35 -0400
Message-ID: <QKPIa.505$BC3.133659_at_news20.bellglobal.com>
"Gene Wirchenko" <genew_at_mail.ocis.net> wrote in message
news:3eea5b2d.22528854_at_news.ocis.net...
> "Bob" <roberth_at_nospam.com> wrote:
>
> >I've seen this term used many times, but never defined. Any searches for
a
> >definition only finds use of the term in passing.
> >
> >Do "code tables" contain actual uncompiled programming code , or other
SQL?
> >Is this good design? How do you change control if the guts of an
> >application can be so easily changed? Any examples?
>
> a.k.a. "lookup table", as in:
> create table colours (colcode n(3), coldesc c(20));
> insert into colours (colcode,coldesc) values (1,"Black");
> insert into colours (colcode,coldesc) values (2,"Brown");
> insert into colours (colcode,coldesc) values (3,"Red");
>
That's just an ordinary dimension table (as in facts and dimensions re: star
schema). Aww, what a let-down. I thought it was must more interesting than
that.
Thanks though for your answer.
Jarson
Received on Sat Jun 21 2003 - 04:51:35 CEST