Adapter Parameter Datatypes

A comprehensive list of datatypes you can use with adapters supplied by Event Stream Processor, or any custom internal or external adapters you create.

Some exceptions for custom external adapters are noted in the datatype descriptions.
Note: This table includes all the adapter-related datatypes that are supported by Event Stream Processor. For more information about the specific datatypes that are supported by each adapter, as well as for its datatype mapping descriptions, see the section on that adapter.
Datatype Description
bigdatetime

Stores the time of day (in microsecond precision) and the date. The default format is YYYY-MM-DD HH:MM:SS.SSSSS.
bigint An alias for long.
boolean

Value is true or false. The format for values outside of the allowed range for boolean is 0/1/false/true/y/n/on/off/yes/no, which is case-insensitive.
choice

A list of custom values from which a user selects one value.
configFilename

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but can be no more than 65535 bytes.
date Stores the date.
decimal

Numbers that contain decimal points. Accepts two mandatory parameters, precision and scale, which determine the range of values that can be stored in a decimal field. precision specifies the total number (from 1 to 34) of digits that can be stored. scale specifies the number of digits (from 0 to precision) that can be stored to the right of the decimal point.
directory

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but can be no more than 65535 bytes.
double An alias for float.
filename

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but can be no more than 65535 bytes.
float

Floating point value. The range of allowed values is 2.22507e-308 to 1.79769e+308
int

A signed 32-bit integer value. The range of allowed values is -2147483648 to +2147483647 (-23^1 to 2^31-1). Constant values that fall outside of this range are automatically processed as long datatypes.

To initialize a variable, parameter, or column with the lowest negative value, specify (-2...7) -1 instead to avoid CCL compiler errors. For example, specify (-2147483647) -1 to initialize a variable, parameter, or column with a value of -2147483648.
long

A signed 64-bit integer. The range of allowed values is -9223372036854775808 to +9223372036854775807 (-263 to 263-1).

To initialize a variable, parameter, or column with a value of -9223372036854775808, specify (-9223372036854775807) -1 to avoid CCL compiler errors.
password

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but can be no more than 65535 bytes.

While entering a value for this field, user sees '*' for every character.
permutation

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but can be no more than 65535 bytes.

This datatype is not supported for custom external adapters.
query

A string value that Studio creates from the table name.

This datatype is not supported for custom external adapters.
range
An integer value for which user can define lower and upper limits. For example, 
<Parameter id="port" label="KDB Port" descr="IP port of the database listener"
      type="range" rangeLow="0" rangeHigh="65535" default="5001"
      use="required"
    />
runtimeDirectory

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but no less than 65535 bytes.

This datatype is not supported for custom external adapters.
runtimeFilename

Runtime file name, if different from discovery time file name.

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but no more than 65535 bytes.

This datatype is not supported for custom external adapters.
string

Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, but no more than 65535 bytes.
tables

List of choices returned by the getTables() that are defined in the adapter.
text

A value capable of storing multiline text.

This datatype is not supported for custom external adapters.
time

Stores the time of day as a two-byte field having a range of 00:00:00 to 23:59:59. The default format is HH24:MM:SS.
timestamp

Stores the date and the time of day (in millisecond precision). The default format is YYYY-MM-DD HH:MM:SS.SSS.
uint

Positive integer value. The range of allowed values is 0 to 0xffffffff.