Method, system, program, and data structure for cleaning a database table using a look-up table

摘要

Disclosed is a method, system, program, and data structure for performing a clean operation on an input table. An input data table name indicates the input table. A first column in a table including a plurality of entries and at least one rule definition are processed. Each rule definition indicates a look-up column including a plurality of entries and a clean operation. A determination is made, for each record in the input table column, whether the record matches one entry in the look-up column. If so, the clean operation indicated in the rule definition is performed on each record that matches one entry in the look-up column.