Recursive Inference Functions

Recursive inference is the process of using data already found in a table to infer a relationship with other, related column data (not available in DB2 mode). Recursive inference is frequently used in solving parts assembly problems or the classic "bill-of-materials" problem.

The LEVEL condition is normally used in conjunction with the PREVIOUS function in queries to implement recursive inference. It could be helpful to first read the PREVIOUS function description, before returning to the LEVEL condition description below.

More: