Re: Informix Help Needed

Trang Donguyen (donguyen@bnr.ca) wrote: : I'm trying to implement a table with over 2.5M tuples. I'm currently : having problems defining the fields in my table and its type. Some of : the problems are: : 1. Is there a way to define this type of linked list : (i.e. (parent child1) (parent child2) (parent child3)) in a : table without defining 6 fields: : ---------------------------------------------------- : | parent | child | parent | child | parent | child | : ---------------------------------------------------- Does parent have the same value for all three instances? If so, you can simplify the table to be parent, child1, child2, and child3, and simply select redundantly as needed. : 3. How are enumerated types defined (i.e. A = {red, pink, blue})? We've typically used a linked table to achieve that effect. For example, define table colors consisting of id serial and description char(10). Now you can store the id with your other data records, using "foreign key" to force consistency. This is a bit sketchy, but hopefully this plus the manuals will point you in a direction. : Thanks, : Trang -- Jonathan Crawford Ark Technologies, Inc.