Datatypes

Event Stream Processor has several new datatypes.

New and Renamed Datatypes

  • bigdatetime – a timestamp with microsecond granularity.
  • interval – with microsecond granularity.
  • binary – represents a raw binary buffer. Maximum length of value is platform-dependent; there is no absolute limit. NULL characters are permitted.
  • boolean – true or false. The following values are converted, and are case-insensitive:
    Values Converted To
    1, On/ON, Yes/YES/Y, True/TRUE/T true
    0, Off/OFF, No/NO/N, False/FALSE/F false
For more about supported datatypes, see the CCL Programmers Guide. See the Adapters Guide for datatype mappings for specific adapters.
Note: The names of some existing datatypes have changed. For details, see the Migration Guide.

Money Datatype Enhancements

You can now set the money datatype precision for each use, rather than globally, using the money (n) format, where n can be a value from 1 to 15. The supported range of values depends on the specified precision. For example:
  • money(1): -922337203685477580.8 to 922337203685477580.7
  • money(15): -9223.372036854775808 to 9223.372036854775807

Specify explicit precision for money constants with Dn syntax, wheren represents the precision. For example, 100.1234567D7, 100.12345D5.

The money datatype with global precision is also supported.

For usage and conversion details for money datatypes, see the CCL Programmers Guide.