Other Functions
Reference list for all functions that are neither aggregate nor scalar type functions.
- cacheSize()
Returns the size of the current bucket in the event cache.
- deleteCache()
Deletes a row at a particular location (specified by index) in the event cache.
- firstnonnull()
Returns the first non-NULL expression from a list of expressions. coalesce() and ifnull() are aliases.
- get*columnbyindex()
Returns the value of a column identified by an index.
- get*columnbyname()
Returns the value of a column identified by an expression evaluated at runtime.
- getCache()
Returns the row specified by a given index from the current bucket in the event cache.
- getData()
Provides a way of interacting with databases: extracts data, calls stored procedures, and inserts data.
- getdecimalcolumnbyindex()
Get the decimal value in a column that you specify using the column index.
- getdecimalcolumnbyname()
Get the decimal value in a column that you specify using the column name.
- getmoneycolumnbyindex()
Returns the value of a column identified by an index.
- getmoneycolumnbyname()
Returns the value of a column identified by an expression evaluated at runtime as a money type.
- getrowid()
Returns the sequence number, or ROWID, of a given row in the window or stream as a 64-bit integer.
- rank()
Returns the position of the row in the current group (only used in GROUP HAVING expression).
- sequence()
Combines two or more expressions to be evaluated in order.
- uniqueId()
Returns a unique identifier.
Created December 18, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com