https://www.omnidex.com/docs/v51/ 2026-04-23T09:17:58+0000 https://www.omnidex.com/docs/v51/ https://www.omnidex.com/docs/v51/lib/tpl/simple/images/favicon.ico text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:abs&rev=1351263435&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: ABS Description The ABS function returns the absolute value of column. This function returns the same datatype as the passed parameter. Syntax ABS( numeric_expression ) numeric_expression Required. Any expression that returns a numeric-class datatype. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:calc_date&rev=1351263435&do=diff Development: Omnidex SQL SQL Functions: $CALC_DATE Description The $CALC_DATE function performs arithmetic on a date expression, returning a new date value. The arithmetic is performed using the units declared in the function, or using DAYS if not specified. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:case&rev=1351263435&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CASE Description The CASE function performs simple IF ... THEN ... ELSE ... END logic within a function. Typically this is used to set a value based on a set of different conditions. The conditions are evaluated in the order they appear in the function until a condition proves TRUE, at which point the THEN expression is executed. If none of the conditions prove TRUE, then the final ELSE expression is executed. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:cast&rev=1351263435&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CAST Description The CAST function converts an expression to the requested datatype. This function returns the datatype requested in the function. Syntax CAST(expression AS datatype) expression Required. An expression using SQL language that produces a value. A scalar expression is generally equivalent to a select item in the SQL SELECT statement, and can be a character expression, numeric expression or date expression. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:ceiling&rev=1351263435&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CEIL[ING] Description Rounds a non-integer value upwards to the next greatest integer. This function returns a BIGINT datatype. Syntax CEILING( numeric_expression ) CEIL( numeric_expression ) numeric_expression Required. Any expression that returns a numeric-class datatype. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:char_length&rev=1351263435&do=diff Omnidex SQL Function: CHARCTER_LENGTH QuickLinks Statements Functions OdxSQL Description Syntax Example Example 1 text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:character_length&rev=1351263435&do=diff Development: Omnidex SQL SQL Functions: CHARACTER_LENGTH Description The CHARACTER_LENGTH function returns the number of characters in a string. The abbreviation, CHAR_LENGTH, is supported as a synonym for CHARACTER_LENGTH. CHARACTER_LENGTH should not be confused with $DATA_LENGTH and $COLUMN_LENGTH. $DATA_LENGTH returns the number of characters plus the null-terminator for STRING datatypes. $COLUMN_LENGTH returns the length of the column as declared in the table. text/html 2012-10-26T14:57:15+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:chr&rev=1351263435&do=diff Omnidex SQL Function: CHR QuickLinks Statements Functions OdxSQL See Also: CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER Description The CHR function returns the character with the specified ascii value and the return data type as a STRING size of 1 character. This function is only available when the CREATE ENVIRONMENT statement contains the SQL_SYNTAX ORACLE clause or the SET SQL_SYNTAX ORACLE setting is set progr… text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:coalesce&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: COALESCE Description The COALESCE function returns the first non-NULL expression among its arguments. This function returns the same datatype as the passed parameter. If all passed parameters are NULL, then this function returns a NULL. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:col_length&rev=1351263436&do=diff Omnidex SQL Function: CASE QuickLinks Statements Functions OdxSQL Description The $COL_LEN and $COLUMN_LENGTH functions return the defined length of a column. The return data type is a 4-byte INTEGER. Both functions are identical. These functions differ from the CHAR_LENGTH and CHARACTER_LENGTH functions: text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:column_length&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $COLUMN_LENGTH Description The $COLUMN_LENGTH function returns the number of the column in bytes. $COLUMN_LENGTH should not be confused with $DATA_LENGTH and CHARACTER_LENGTH. CHARACTER_LENGTH returns the number of character in a string column, not including trailing spaces. $DATA_LENGTH returns the number of characters plus the null-terminator for STRING datatypes. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:compare_dates&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $COMPARE_DATES Description The $COMPARE_DATES function compares two date expression and returns the difference. The arithmetic is performed using the units declared in the function, or using days if not specified. This function returns an INTEGER datatype. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:concatenation&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: || (Concatenation) Description The concatenation operator - || (two vertical bars) - returns a single concatenated character string made up of two or more character expressions. All blanks are preserved during concatenation. Use the TRIM function to eliminate blanks if desired. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:convert&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $CONVERT Description The CONVERT function converts an expression to the requested datatype. This is similar to the CAST function, but allows a wider variety of options. This function returns the datatype requested in the function. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:current_date&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CURRENT_DATE Description The CURRENT_DATE function returns the current date from the server's time-of-day clock. The function is processed once at the beginning of the execution of the SQL statement. A new value is not obtained with each reference or with each fetched row. In a client-server or Omnidex Grid application, the date returned is from the individual server processing the query. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:current_row&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $CURRENT_ROW Description The $CURRENT_ROW function return the current row number for the result set. The first row returned from a SELECT statement is given a value of 1, and each successive row is incremented by one. This is done as the last step of a statement, and so $CURRENT_ROW can only be used as a select-item. It cannot be used in the WHERE, GROUP BY, ORDER BY or HAVING clauses. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:current_time&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CURRENT_TIME Description The CURRENT_TIME function returns the current time from the server's time-of-day clock. The function is processed once at the beginning of the execution of the SQL statement. A new value is not obtained with each reference or with each fetched row. In a client-server or Omnidex Grid application, the time returned is from the individual server processing the query. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:current_timestamp&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CURRENT_TIMESTAMP Description The CURRENT_TIMESTAMP function returns the current timestamp from the server's time-of-day clock. The function is processed once at the beginning of the execution of the SQL statement. A new value is not obtained with each reference or with each fetched row. In a client-server or Omnidex Grid application, the timestamp returned is from the individual server processing the query. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:current_user&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: CURRENT_USER Description The USER, CURRENT_USER and SESSION_USER functions return the current user of Omnidex. Omnidex does not provide a user security layer, and so these functions always return a value of “DEFAULT text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:data_length&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $DATA_LENGTH Description The $DATA_LENGTH function returns the number of characters in a column, plus a terminating null for STRING datatypes. The $DATA_LENGTH function does not trim trailing spaces, unlike the CHAR_LENGTH function. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:distance&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $DISTANCE Description The $DISTANCE function calculates the distance between one set of geographic coordinates and one or more other geographic coordinates. This is used for performing geographic radius searches, such as finding all rows within five miles of a given location. This can also be used to simply calculate the distance between two points. The following text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:extract&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: EXTRACT Description The EXTRACT function extracts one or more portions of a date, such as a day, month or year. This is useful for performing logic on portions of a date, such as performing certain actions in certain months. This is also useful for assembling a date string in a specific format. text/html 2012-10-26T14:57:16+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:floor&rev=1351263436&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: FLOOR Description Rounds a non-integer value downward to the next lower integer. This function returns a BIGINT datatype. Syntax FLOOR( numeric_expression ) numeric_expression Required. Any expression that returns a numeric-class datatype. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:home&rev=1351263437&do=diff Omnidex Supports standard, extended, and RDBMS specific functions as follows: * Standard SQL Functions * Extended SQL Functions * Oracle SQL Functions * String Functions * Math Functions * Extended Text Functions Omnidex SQL Functions Quick Reference Omnidex SQL Functions text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:ifnull&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $IFNULL Description The $IFNULL function tests to see if the first expression produces a NULL, and if so, returns the second expression. This function returns the same datatype as the passed parameter. If all passed parameters are NULL, then this function returns a NULL. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:instr&rev=1351263437&do=diff Omnidex SQL Function: INSTR QuickLinks Statements Functions OdxSQL See Also: CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER Description The INSTR function returns an integer value representing the starting position of a string within the search string. This function is only available when the CREATE ENVIRONMENT statement contains the SQL_SYNTAX ORACLE clause or the SET SQL_SYNTAX ORACLE setting is set programmatically… text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:lj&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $LJ Description Left-justify the character expression. This function return a STRING datatype. Syntax $LJ( character_expression ) character_expression Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:lower&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: LOWER Description Converts a string to all lower case characters. This function returns the same datatype as the passed parameter. Syntax LOWER( character_expression ) character_expression Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:lpad&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $LPAD Description Pad the string on the left with spaces or the named character. If the string is already padded, as happens with a CHARACTER datatype, the string must first be trimmed using the TRIM function. This function returns a STRING datatype. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:mod&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: MOD Description Returns “x modulus y”. This is the integral remainder of x divided by y. This function returns an INTEGER datatype. Syntax MOD( integral_expression, divisor_integral_expression ) integral_expression % divisor_integral_expression text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:new_time&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: NEW_TIME See Also: CHR | INSTR | NEW_TIME | NVL | SUBSTR | SYS_EXTRACT_UTC | SYSDATE | SYSTIMESTAMP | TO_DATE | TO_NUMBER Description Returns the date and time adjusted to time_zone2. The function is helpful when trying to show a time stored in the database as a standard time such as Greenish Mean Time (GMT) as a local time. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:nullif&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: NULLIF Description The NULLIF function tests to see if the first expression is equal to the second expression, and returns the first expression if they are not equal and NULL if they are equal. This function returns the same datatype as the first expression, or NULL if the two expressions are equal. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:nvl&rev=1351263437&do=diff Omnidex SQL Function: NVL QuickLinks Statements Functions OdxSQL See Also: CHR INSTR NEW_TIME NVL SUBSTR SYS_EXTRACT_UTC SYSDATE SYSTIMESTAMP TO_DATE TO_NUMBER Description The NVL function Returns expression2 if expression1 is NULL. The return datatype is the same as expression1. Syntax NVL(expression1, expression2) text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:position&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: POSITION Description The POSITION function finds the position of a search_string in a target_string. If the target_string is of length zero, the result is 1. If the search_string occurs as a substring within the target_string, the character position where the search_string first occurs is returned. If neither of these conditions is true, the result is 0. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:power&rev=1351263437&do=diff Omnidex SQL Function: POWER QuickLinks Statements Functions OdxSQL Description Syntax Example Example 1 text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:proper&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $PROPER Description Converts a string to proper case, meaning that the first character of each word in made upper case and the remaining characters are lower case. This function returns the same datatype as the passed parameter. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:random&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $RANDOM Description Returns a pseudo-random number. The term “pseudo-random” is used since randomization is done using the POSIX rand and srand functions. While these routines do provide satisfactory randomization for most applications, the numbers generated are not entirely random. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:retrieve_file&rev=1351263437&do=diff Development: Omnidex SQL SQL Functions: $RETRIEVE_FILE Description The $RETRIEVE_FILE functions opens an external textual file and returns the contents. This function is most commonly used in Omnidex Text applications to index and query a catalog of external textual files. This function can also be used to simply retrieve the contents of any textual file using an Omnidex SQL statement. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:rj&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $RJ Description Right-justify the character expression. This function returns a STRING datatype. Syntax $RJ( character_expression ) character_expression Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:round&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: ROUND Description The ROUND function returns a numeric expression rounded to a specified number of decimal places. If the value specified by n is positive and longer than the digits after the decimal point, 0 is added after the fraction digits. If the value specified by n is negative and larger than or equal to the digits before the decimal point, 0.00 is returned. text/html 2012-10-26T14:57:17+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:rpad&rev=1351263437&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: $RPAD Description Pad the string on the right with spaces or the named character. If the string is already padded, as happens with a CHARACTER datatype, the string must first be trimmed using the TRIM function. This function returns a STRING datatype. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:score&rev=1351263438&do=diff Omnidex SQL Function: $SCORE QuickLinks Statements Functions OdxSQL Description The $SCORE function returns the “score” used to determine rank and relevancy of qualified text. Most textual applications are designed to qualify a large selection of rows and then present them in order of relevancy. A scoring algorithm ranks qualified text according to occurrence frequency, proximity, and several other factors, depending on the qualification criteria. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_dates&rev=1351263438&do=diff * Function Summary * Date Functions * EXTRACT * $CALC_DATE * $COMPARE_DATES text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_logic&rev=1351263438&do=diff * Function Summary * Logic Functions * CASE * COALESCE * NULLIF * $IFNULL text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_math&rev=1351263438&do=diff * Function Summary * Math Functions * ABS * CEIL[ING] * FLOOR * MOD * ROUND * TRUNC * $RANDOM text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_string&rev=1351263438&do=diff * Function Summary * String Functions * CHARACTER_LENGTH * LOWER * POSITION * SUBSTRING * TRIM * UPPER * || (Concatenation) * $LJ * $LPAD * text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_utility&rev=1351263438&do=diff * Function Summary * Utility and Data Conversion Functions * CAST * $COLUMN_LENGTH * $CONVERT * $DATA_LENGTH * $DISTANCE text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:see_also_variables&rev=1351263438&do=diff * Function Summary * Variables * CURRENT_DATE * CURRENT_TIME * CURRENT_TIMESTAMP * CURRENT_USER * SESSION_USER * SYSTEM_USER * USER * $CURRENT_ROW text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:session_user&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: SESSION_USER Description The USER, CURRENT_USER and SESSION_USER functions return the current user of Omnidex. Omnidex does not provide a user security layer, and so these functions always return a value of “DEFAULT text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:soundex&rev=1351263438&do=diff Omnidex SQL Function: $SOUNDEX QuickLinks Statements Functions OdxSQL Description Returns the Soundex equivalent to a character string (“string” may be a CHARACTER or STRING column, or a string literal). The algorithm used by this function is identical to that applied to keywords in MDK index using the ;SX option. The routine only pays attention to the first 24 characters of the input; the return value is STRING length 25. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:substring&rev=1351263438&do=diff Development: Omnidex SQL SQL Functions: SUBSTRING Description The SUBSTRING function returns a new character string that is a portion of another character expression. The new string begins at the specified starting point in the original expression and extends the number of characters specified in the length parameter. If the length parameter is omitted, the new string extends to the end of the original string. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:system_user&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: SYSTEM_USER Description The SYSTEM_USER function returns the system login from the operating system. This function returns an ANSI TIME datatype. Syntax SYSTEM_USER Examples Example 1: Column > select system_user from $omnidex; SYSTEM_USER ------------- DOCUMENTATION text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:trim&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: TRIM Description The TRIM function removes any leading and/or trailing pad characters from a string. The pad character is a single character and defaults to a space character. This function returns a STRING datatype. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:trunc&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: TRUNC Description The TRUNC function returns a numeric expression truncated to a specified number of digits to the right of the decimal point. If the specified number of digits is positive and longer than the digits after the decimal point, 0 is added after the fraction digits. If the specified number of digits is negative and larger than or equal to the digits before the decimal point, 0 is returned. When a numeric expre… text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:upper&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: UPPER Description Converts a string to all upper case characters. This function returns the same datatype as the passed parameter. Syntax UPPER( character_expression ) character_expression Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype. text/html 2012-10-26T14:57:18+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v51/doku.php?id=dev:sql:functions:user&rev=1351263438&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Function: USER Description The USER, CURRENT_USER and SESSION_USER functions return the current user of Omnidex. Omnidex does not provide a user security layer, and so these functions always return a value of “DEFAULT”.