SAP Sybase Event Stream Processor supports integer, float, string, money, long, and timestamp datatypes for all of its components.
Datatype | Description |
---|---|
bigdatetime |
Timestamp with microsecond precision. The default format is YYYY-MM-DDTHH:MM:SS:SSSSSS. All numeric datatypes are implicitly cast to bigdatetime. The rules for conversion vary for some datatypes:
|
bigint | An alias for long. |
binary |
Represents a raw binary buffer. Maximum length of value is platform-dependent, with a size limit of 2 gigabytes. NULL characters are permitted. |
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. |
date | Date with second precision. The default format is YYYY-MM-DDTHH:MM:SS. |
decimal |
Used to represent 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. |
double | An alias for float. |
float | A 64-bit numeric floating point with double precision. The range of allowed values is approximately -10308 through +10308. |
integer |
A signed 32-bit integer. The range of allowed values is -2147483648 to +2147483647 (-231 to 231-1). Constant values that fall outside of this range are automatically processed as long datatypes. To initialize a variable, parameter, or column with a value of -2147483648, specify (-2147483647) -1 to avoid CCL compiler errors. |
interval |
A signed 64-bit integer that represents the number of microseconds between two timestamps. Specify an interval using multiple units in space-separated format, for example, "5 Days 3 hours 15 Minutes". External data that is sent to an interval column is assumed to be in microseconds. Unit specification is not supported for interval values converted to or from string data. When an interval is specified, the given interval must fit in a 64-bit integer (long) when it is converted to the appropriate number of microseconds. For each interval unit, the maximum allowed values that fit in a long when converted to microseconds are:
The values in parentheses are alternate names for an interval unit. When the maximum value for a unit is specified, no other unit can be specified or it causes an overflow. Each unit can be specified only once. |
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. |
money |
A legacy datatype maintained for backward compatibility. It is a signed 64-bit integer that supports 4 digits after the decimal point. Currency symbols and commas are not supported in the input data stream. |
money(n) | A signed 64-bit numerical value that supports varying scale, from 1 to 15 digits after the decimal point. Currency symbols and commas are not supported in the input data stream, however, decimal points are. The supported range of values change, depending on the specified scale. money(1): -922337203685477580.8 to 922337203685477580.7 money(2): -92233720368547758.08 to 92233720368547758.07 money(3): -9223372036854775.808 to 9223372036854775.807 money(4): -922337203685477.5808 to 922337203685477.5807 money(5): -92233720368547.75808 to 92233720368547.75807 money(6): -92233720368547.75808 to 92233720368547.75807 money(7): -922337203685.4775808 to 922337203685.4775807 money(8): -92233720368.54775808 to 92233720368.54775807 money(9): -9223372036.854775808 to 9223372036.854775807 money(10): -922337203.6854775808 to 922337203.6854775807 money(11): -92233720.36854775808 to 92233720.36854775807 money(12): -9223372.036854775808 to 9223,372.036854775807 money(13): -922337.2036854775808 to 922337.2036854775807 money(14): -92233.72036854775808 to 92233.72036854775807 money(15): -9223.372036854775808 to 9223.372036854775807 To initialize a variable, parameter, or column with a value of -92,233.72036854775807, specify (-9...7) -1 to avoid CCL compiler errors. Specify explicit scale for money constants with Dn syntax, where n represents the scale. For example, 100.1234567D7, 100.12345D5. Implicit conversion between money(n) types is not supported because there is a risk of losing range or scale. Perform the cast function to work with money types that have different scale. |
string | Variable-length character string, with byte values encoded in UTF-8. Maximum string length is platform-dependent, with a size limit of 2 gigabytes. This size limit is reduced proportionally by the size of other content in the row, including the header. |
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 | Timestamp with millisecond precision. The default format is YYYY-MM-DDTHH:MM:SS:SSS. |