The filteritem table in the onpload database

The filteritem table defines the conditions to be applied to load data to filter out records. Each filter item is attached to a particular field of a record in a data file. Use the filter options to modify this table.

Column Type Description
formid INTEGER Filter identifier (foreign key to the filters table)
seq INTEGER Specifies the order in which the filter items (the match expression) are applied
fname CHAR(128) The name of the field that this filter affects
option CHAR(7) Specifies the disposition of a record (discard or keep) when the match criterion is true
match CHAR(60) Match expression that is applied to data field

Copyright© 2018 HCL Technologies Limited