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 000800345452 1998-08-31 DENVER CO 000800345453 2003-12-25 DENVER CO 000801610627 2004-03-17 DENVER CO 000802420583 1990-03-18 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 18 rows returned
See also: