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.
- coalesce()
Other. Returns the first non-NULL expression from a list of expressions.
- concat()
Scalar. Returns the concatenation of two given binary values OR one or more string values.
- deleteCache()
Deletes a row at a particular location (specified by index) in the event cache.
- firstnonnull()
Other. Returns the first non-NULL expression from a list of expressions.
- 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()
This function takes a database query, gets rows from an external database table and returns them in a vector of records.
- 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()
Other. Returns the sequence number of a given row in the window.
- rank()
Other. 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.
Created August 28, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com