Database column filter classes

The database column filter subclasses are used in database queries and filters to define criteria for selecting table rows based on the contents of a column. A column filter is made up of a table, column, value, and operator to be used in querying the database.

The following table lists the IBM Director column filter subclasses to use for the specified column types:

Column filter class  Database column types
  TWGDbDoubleColumnFilter  Double columns
  TWGDbFloatColumnFilter  Real columns
  TWGDbIntegerColumnFilter  Integer columns
  TWGDbLongColumnFilter  Date and DateTime columns
  TWGDbShortColumnFilter  Smallint columns
  TWGDbStringColumnFilter  Char and Varchar columns

Array type values

Use any of these as the data type value for a column:
Array types  Values
STRING_ARRAY_TYPE 0x01
LONG_ARRAY_TYPE 0x03
INTEGER_ARRAY_TYPE 0x05
SHORT_ARRAY_TYPE 0x07
BYTE_ARRAY_TYPE 0x09
BOOLEAN_ARRAY_TYPE 0x0B
DOUBLE_ARRAY_TYPE 0x0E
FLOAT_ARRAY_TYPE 0x10