This is an old revision of the document!
Omnidex Segments can be referenced as criteria in a future query using the $SEGMENT function. The $SEGMENT function references the object name for any segment previously created in the same connection. Since Omnidex Segments already contain index pointers, they are incorporated into a search with very high performance.
The following example shows several segments that were created in the previous page being referenced in a query using the $SEGMENT function:
> ; Fulfill the query based on the final segment; > select INDIVIDUAL, >> BIRTHDATE, >> CITY, >> STATE >> from INDIVIDUALS >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD >> where INDIVIDUAL in (segment(PART_1), segment(PART_2)) and >> INDIVIDUAL = segment(PART_3); INDIVIDUAL BIRTHDATE CITY ST ------------ ------------ ---------------------------- -- 000400191550 1996-04-26 PHOENIX AZ 000400575367 1996-11-19 PHOENIX AZ 000400575366 1995-09-26 PHOENIX AZ 000400575369 2005-06-29 PHOENIX AZ 000400575368 2004-07-30 PHOENIX AZ 000403467439 1994-08-28 PHOENIX AZ 000403467441 2003-04-19 PHOENIX AZ 000403467440 1997-02-28 PHOENIX AZ 000403490448 1988-07-03 PHOENIX AZ 000403490440 1988-04-14 PHOENIX AZ 000800138400 1980-06-17 DENVER CO 000800345452 1998-08-31 DENVER CO 000800345453 2003-12-25 DENVER CO 000800345451 1982-07-08 DENVER CO 000801610625 1985-10-21 DENVER CO 000801610627 2004-03-17 DENVER CO 000802420583 1990-03-18 DENVER CO 000802420582 1987-06-16 DENVER CO 000802420584 1993-10-06 DENVER CO 000803400688 1990-06-16 DENVER CO 000803400689 1990-10-25 DENVER CO 000803760388 2006-07-30 DENVER CO 000803760386 1995-12-09 DENVER CO 000803760387 1997-09-24 DENVER CO 24 rows returned
See also: