Ascii Summary The Ascii function returns the ASCII code value of the leftmost character of the string as an integer. Syntax Ascii(<string_exp>) Return Type Integer Details   Examples eval Ascii(‘A’); 97 […]

SeqNum Numeric Summary The SeqNum function returns an increasing number beginning from an optional start number. Syntax SeqNum([start]) Return Type   Details The function restarts the count for each query submitted. The […]

NextNum Numeric Summary The NextNum function returns an increasing number starting from 1. Syntax NextNum() Return Type   Details The function restarts the numbering at 1 when the JVM is restarted Examples […]

FormatNumber Summary The FormatNumber function formats decimal numbers. Syntax FormatNumber(<any numeric>) Return Type String Details The FormatNumber function use the Java 8 DecimalFormat class, which lists the available formatting masks. The function uses RoundingMode.HALF_EVEN (also known as Banker’s […]

UUID Summary The UUID function returns a random universally unique identifier (UUID) value. Syntax UUID() Return Type String Details The UUID function uses the standard Java UUID class to return the random value. The returned […]

SeqNum Summary The SeqNum function returns an increasing value each time it is called. Syntax SeqNum([start expression]) Return Type Long Details The returned value starts at 1 for each query. A new […]

NVL Summary The Nvl function returns the first non-NULL value from the two input parameters passed to the function. Syntax Nvl(<expression_1>, <expression_2>) Return Type Nvl’s return value is the data type of the […]

NextNum Summary The NextNum function returns a number larger than the last time the function was called within the JVM. Syntax NextNum() Return Type Long Details The NextNum function is typically used for testing purposes. […]

Empty Summary The Empty function returns a virtual or dummy table containing n number of rows and columns. XSQL returns a new table result set each time Empty is called. […]

Sqrt Summary The Sqrt function returns the square root of the input expression. Syntax Sqrt(<double_exp>) Return Type Double Details   Examples eval Sqrt(0); 0 select Sqrt(1) from Empty(rows=1); 1 eval Sqrt(100); […]