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 |
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 |