Re: multi-valued field?

From: Pablo Sanchez <pablo_at_mew.corp.sgi.com>
Date: 1997/01/07
Message-ID: <5atra5$130@mew.corp.sgi.com>#1/1

In article <32d24e53.997438_at_n5.gbso.net>, chuckh_at_dvol.com writes:
> >> Kevin Kane wrote:
> >> >
> >> > Hi. Is there such a thing in DB2 as a multi-valued field? By this I mean
> >> > that I have a column called, say, AUTOMOBILES. If a person has 2
> >> > cars, then I would like the AUTOMOBILES field of his record to contain
> >> > 2 entries, one for each car.
> >> >
> >> > So, can DB2 handle this, or am I just going to have to cat the
> >> > individual values together into a character string with some kind of
> >> > delimiter?
>
> You aren't coming from a PICK environment are you?
>
> It can be done in a SQL database. The way to do it is to create a 2nd
> table for AUTOMOBILES (and all associated fields). This is called

Picking nits... it should be AUTOMOBILE... not that it's incorrect the other way but by convention entities should be singular not plural.

--
Pablo Sanchez              | Ph # (415) 933.3812        Fax # (415) 933.2821
pablo_at_sgi.com              | Pg # (800) 930.5635  -or-  pablo_p_at_corp.sgi.com
===============================================================================
I am accountable for my actions.   http://reality.sgi.com/pablo [ /Sybase_FAQ ]

Received on Tue Jan 07 1997 - 00:00:00 CST