IT Universe documentation - Function
| Id | Category | Description | Syntax | E/W |
|---|---|---|---|---|
| @ function | BASIC | Use the @ function with the PRINT statement to control display attributes, screen display, and cursor postioning. |
@ (column [,row])
@ (-code [,arg]) |
EN |
| ABS function | BASIC | Use the ABS function to return the absolute value of any numeric expression. The absolute value of an expression is its unsigned magnitude. If expression is negative, the value returned is: | ABS (expression) | E |
| ABSS function | BASIC | Use the ABSS function to return the absolute values of all the elements in a dynamic array. If an element in dynamic.array is the null value, null is returned for that element. | ABSS (dynamic.array) | E |
| ACOS function | BASIC | Use the ACOS function to return the trigonometric arc-cosine of expression. expression must be a numeric value. The result is expressed in degrees. If expression evaluates to the null value, null is returned. The ACOS function is the inverse of the COS function. | ACOS (expression) | E |
| ADDS function | BASIC | Use the ADDS function to create a dynamic array of the element-by-element addition of two dynamic arrays. | ADDS (array1, array2) | E |
| ALPHA function | BASIC | Use the ALPHA function to determine whether expression is an alphabetic or nonalphabetic string. If expression contains the characters a through z or A through Z, it evaluates to true and a value of 1 is returned. If expression contains any other character or an empty string, it evaluates to false and a value of 0 is returned. If expression evaluates to the null value, null is returned. | ALPHA (expression) | E |
| ANDS function | BASIC | Use the ANDS function to create a dynamic array of the logical AND of corresponding elements of two dynamic arrays. | ANDS (array1, array2) | E |
| ASCII function | BASIC | Use the ASCII function to convert each character of expression from its EBCDIC representation value to its ASCII representation value. If expression evaluates to the null value, null is returned. | ASCII (expression) | E |
| ASIN function | BASIC | Use the ASIN function to return the trigonometric arc-sine of expression. expression must be a numeric value. The result is expressed in degrees. If expression evaluates to the null value, null is returned. The ASIN function is the inverse of the SIN function. | ASIN (expression) | E |
| ASSIGNED function | BASIC | Use the ASSIGNED function to determine if variable is assigned a value. ASSIGNED returns 1 (true) if variable is assigned a value, including common variables and the null value. It returns 0 (false) if variable is not assigned a value. | ASSIGNED (variable) | E |
| ATAN function | BASIC | Use the ATAN function to return the trigonometric arc-tangent of expression. expression must be a numeric value. The result is expressed in degrees. If expression evaluates to the null value, null is returned. The ATAN function is the inverse of the TAN function. | ATAN (expression) | E |
| BITAND function | BASIC | Use the BITAND function to perform the bitwise AND comparison of two integers specified by numeric expressions. The bitwise AND operation compares two integers bit by bit. It returns a bit of 1 if both bits are 1; otherwise it returns a bit of 0. | BITAND (expression1, expression2) | EN |
| BITNOT function | BASIC | Use the BITNOT function to return the bitwise negation of an integer specified by any numeric expression. | BITNOT (expression [,bit#]) | EN |
| BITOR function | BASIC | Use the BITOR function to perform the bitwise OR comparison of two integers specified by numeric expressions. The bitwise OR operation compares two integers bit by bit. It returns the bit 1 if the bit in either or both numbers is 1; otherwise it returns the bit 0. | BITOR (expression1, expression2) | EN |
| BITRESET function | BASIC | Use the BITRESET function to reset to 0 the bit number of the integer specified by expression. Bits are counted from right to left. The number of the rightmost bit is 0. If the bit is 0, it is left unchanged. | BITRESET (expression, bit#) | E |
| BITSET function | BASIC | Use the BITSET function to set to 1 the bit number of the integer specified by expression. The number of the rightmost bit is 0. If the bit is 1, it is left unchanged. | BITSET (expression, bit#) | E |
| BITTEST function | BASIC | Use the BITTEST function to test the bit number of the integer specified by expression. The function returns 1 if the bit is set; it returns 0 if it is not. Bits are counted from right to left. The number of the rightmost bit is 0. | BITTEST (expression, bit#) | E |
| BITXOR function | BASIC | Use the BITXOR function to perform the bitwise XOR comparison of two integers specified by numeric expressions. The bitwise XOR operation compares two integers bit by bit. It returns a bit 1 if only one of the two bits is 1; otherwise it returns a bit 0. | BITXOR (expression1, expression2) | EN |
| CATS function | BASIC | Use the CATS function to create a dynamic array of the element-by-element concatenation of two dynamic arrays. | CATS (array1, array2) | E |
| CHANGE function | BASIC | Use the CHANGE function to replace a substring in expression with another substring. If you do not specify occurrence, each occurrence of the substring is replaced. |
CHANGE (expression, substring, replacement [,occurrence
[,begin]] ) |
E |
| CHAR function | BASIC | Use the CHAR function to generate an ASCII character from the numeric value of expression. | CHAR (expression) | EN |
| CHARS function | BASIC | Use the CHARS function to generate a dynamic array of ASCII characters from the decimal numeric value of each element of dynamic.array. | CHARS (dynamic.array) | E |
| CHECKSUM function | BASIC | Use the CHECKSUM function to return a cyclical redundancy code (a checksum value). | CHECKSUM (string) | E |
| COL1 function | BASIC | Use the COL1 function after the execution of a FIELD function to return the numeric value for the character position that immediately precedes the selected substring (see the FIELD function). Although the COL1 function takes no arguments, parentheses are required to identify it as a function. | COL1 ( ) | E |
| COL2 function | BASIC | Use the COL2 function after the execution of a FIELD function to return the numeric value for the character position that immediately follows the selected substring (see the FIELD function). Although the COL2 function takes no arguments, parentheses are required to identify it as a function. | COL2 ( ) | E |
| CONTINUE function | BASIC | The CONTINUE statement is a loop-controlling statement. For syntax details, see the FOR statement and the LOOP statement. | ||
| CONVERT function | BASIC | Use the CONVERT function to return a copy of variable with every occurrence of specified characters in variable replaced with other specified characters. Every time a character to be converted appears in variable, it is replaced by the replacement character. | CONVERT (expression1, expression2, variable) | E |
| COS function | BASIC | Use the COS function to return the trigonometric cosine of an angle. expression is an angle expressed as a numeric value in degrees. The COS function is the inverse of the ACOS function. | COS (expression) | E |
| COSH function | BASIC | Use the COSH function to return the hyperbolic cosine of expression. expression must be a numeric value. | COSH (expression) | E |
| COUNT function | BASIC | Use the COUNT function to return the number of times a substring is repeated in a string value. | COUNT (string, substring) | E |
| COUNTS function | BASIC | Use the COUNTS function to count the number of times a substring is repeated in each element of a dynamic array. The result is a new dynamic array whose elements are the counts corresponding to the elements in dynamic.array. | COUNTS (dynamic.array, substring) | E |
| DATE function | BASIC | Use the DATE function to return the numeric value of the internal system date. Although the DATE function takes no arguments, parentheses are required to identify it as a function. | DATE ( ) | E |
| DCOUNT function | BASIC | Use the DCOUNT function to return the number of delimited fields in a data string. | DCOUNT (string, delimiter) | E |
| DELETE function | BASIC | Use the DELETE function to erase the data contents of a specified field, value, or subvalue and its corresponding delimiter from a dynamic array. The DELETE function returns the contents of the dynamic array with the specified data removed without changing the actual value of the dynamic array. | DELETE (dynamic.array, field#[,value#[,subvalue#]] ) | E |
| DIV function | BASIC | Use the DIV function to calculate the value of the quotient after dividend is divided by divisor. | DIV (dividend, divisor) | E |
| DIVS function | BASIC | Use the DIVS function to create a dynamic array containing the result of the element-by-element division of two dynamic arrays. | DIVS (array1, array2) | E |
| DOWNCASE function | BASIC | Use the DOWNCASE function to change all uppercase letters in expression to lowercase. If expression evaluates to the null value, null is returned. | DOWNCASE (expression) | E |
| DQUOTE function | BASIC | Use the DQUOTE function to enclose an expression in double quotation marks. If expression evaluates to the null value, null is returned. | DQUOTE (expression) | E |
| DTX function | BASIC | Use the DTX function to convert a decimal integer to its hexadecimal equivalent. | DTX (number [,size] ) | E |
| EBCDIC function | BASIC | Use the EBCDIC function to convert each character of expression from its ASCII representation value to its EBCDIC representation value. The EBCDIC and ASCII functions perform complementary operations. Data that is not represented in ASCII code produces undefined results. | EBCDIC (expression) | E |
| EOF(ARG.) function | BASIC | Use the EOF(ARG.) function to check if the command line argument pointer is past the last command line argument. ARG. is part of the syntax of the EOF(ARG.) function and must be specified. EOF(ARG.) returns 1 (true) if the pointer is past the last command line argument, otherwise it returns 0 (false). | EOF(ARG.) | |
| EQS function | BASIC | Use the EQS function to test if elements of 1 dynamic array are equal to the elements of another dynamic array. | EQS (array1, array2) | E |
| EREPLACE function | BASIC | Use the EREPLACE function to replace substring in expression with another substring. If you do not specify occurrence, each occurrence of substring is replaced. |
EREPLACE (expression, substring, replacement [,occurrence
[,begin]] ) |
E |
| EXCHANGE function | BASIC | Use the EXCHANGE function to replace one character with another or to delete all occurrences of the specified character. | EXCHANGE (string, xx, yy) | EN |
| EXP function | BASIC | Use the EXP function to return the value of "e" raised to the power designated by expression. The value of "e" is approximately 2.71828. expression must evaluate to a numeric value. | EXP (expression) | E |
| EXTRACT function | BASIC | Use the EXTRACT function to access the data contents of a specified field, value, or subvalue from a dynamic array. You can use either syntax shown to extract data. The first syntax uses the EXTRACT keyword, the second uses angle brackets. | EXTRACT (dynamic.array, field# [,value# [,subvalue#]]) | E |
| FADD function | BASIC | Use the FADD function to perform floating-point addition on two numeric values. If either number evaluates to the null value, null is returned. If either number1 or number2 evaluates to the null value, null is returned. return.array equates to number1 plus number2. | FADD (number1, number2) | E |
| FDIV function | BASIC | Use the FDIV function to perform floating-point division on two numeric values. number1 is divided by number2. return.array equates to number1 divided by number2. If number2 is 0, a run-time error message is produced and a 0 is returned for the function. If either number evaluates to the null value, null is returned. | FDIV (number1, number2) | E |
| FFIX function | BASIC | Use the FFIX function to convert a floating-point number to a numeric string with fixed precision. If number evaluates to the null value, null is returned. | FFIX (number) | |
| FFLT function | BASIC | Use the FFLT function to round a number to a string with a precision of 13. The number also converts to scientific notation when required for precision. If number evaluates to the null value, null is returned. | FFLT (number) | |
| FIELD function | BASIC | Use the FIELD function to return 1 or more substrings located between specified delimiters in string. | FIELD (string, delimiter, occurrence [,num.substr] ) | E |
| FIELDS function | BASIC | Use the FIELDS function to return a dynamic array of substrings located between specified delimiters in each element of dynamic.array. | FIELDS (dynamic.array, delimiter, occurrence [,num.substr] ) | E |
| FIELDSTORE function | BASIC | Use the FIELDSTORE function to modify character strings by inserting, deleting, or replacing fields separated by specified delimiters. | FIELDSTORE (string, delimiter, start, n, new.string) | E |
| FILEINFO function | BASIC | Use the FILEINFO function to return information about the specified file's configuration, such as the specified file's parameters, its modulus and load, its operating system filename, and its VOC name. The information returned depends on the file type and the value of the key. | FILEINFO ( file.variable , key) | EN |
| FIX function | BASIC | Use the FIX function to convert a numeric value to a floating-point number with a specified precision. FIX lets you control the accuracy of computation by eliminating excess or unreliable data from numeric results. For example, a bank application that computes the interest accrual for customer accounts does not need to deal with credits expressed in fractions of cents. An engineering application needs to throw away digits that are beyond the accepted reliability of computations. | FIX (number [,precision [,mode]] ) | E |
| FMT function | BASIC | Use the FMT function or a format expression to format data for output. Any BASIC expression can be formatted for output by following it with a format expression. | FMT (expression, format) | EN |
| FMTDP function | BASIC | In NLS mode, use the FMTDP function to format data for output in display positions rather than character lengths. | FMTDP (expression, format [, mapname] ) | |
| FMTS function | BASIC | Use the FMTS function to format elements of dynamic.array for output. Each element of the array is acted upon independently and is returned as an element in a new dynamic array. | FMTS (dynamic.array, format) | |
| FMTSDP function | BASIC | In NLS mode, use the FMTSDP function to format elements of dynamic.array for output in display positions rather than character lengths. Each element of the array is acted upon independently and is returned as an element in a new dynamic array. | FMTSDP (dynamic.array, format [, mapname] ) | N |
| FMUL function | BASIC | Use the FMUL function to perform floating-point multiplication on two numeric values. If either number evaluates to the null value, null is returned. return.array equates to number1 multiplied by number2. | FMUL (number1, number2) | E |
| FOLD function | BASIC | Use the FOLD function to divide a string into a number of substrings separated by field marks. | FOLD (string, length ) | E |
| FOLDDP function | BASIC | In NLS mode, use the FOLDDP function to divide a string into a number of substrings separated by field marks. The division is in display positions rather than character lengths. | FOLDDP (string, length [, mapname] ) | |
| FSUB function | BASIC | Use the FSUB function to perform floating-point subtraction on two numeric values. number2 is subtracted from number1. If either number evaluates to the null value, null is returned. result equates to number1 minus number2. | FSUB (number1, number2) | E |
| GES function | BASIC | Use the GES function to test if elements of one dynamic array are greater than or equal to corresponding elements of another dynamic array. | GES (array1, array2) | |
| GETLOCALE function | BASIC | In NLS mode, use the GETLOCALE function to display the names of specified categories of the current locale. The GETLOCALE function also displays the details of any saved locale that differs from the current one. | GETLOCALE (categories) | |
| GETREM function | BASIC | Use the GETREM function after the execution of a REMOVE statement, a REMOVE function, or a REVREMOVE statement, to return the numeric value for the character position of the pointer associated with dynamic.array. | GETREM (dynamic.array) | E |
| GROUP function | BASIC | Use the GROUP function to return one or more substrings located between specified delimiters in string. | GROUP (string, delimiter, occurrence [,num.substr] ) | E |
| GTS function | BASIC | Use the GTS function to test if elements of one dynamic array are greater than elements of another dynamic array. | GTS (array1, array2) | |
| ICHECK function | BASIC | Use the ICHECK function to check if data you intend to write to an SQL table violates any SQL integrity constraints. ICHECK verifies that specified data and primary keys satisfy the defined SQL integrity constraints for an SQL table. | ICHECK ( dynamic.array [, file.variable] , key [, column#] ) | |
| ICONV function | BASIC | Use the ICONV function to convert string to a specified internal storage format. string is an expression that evaluates to the string to be converted. | ICONV (string, conversion) | E |
| ICONVS function | BASIC | Use the ICONVS function to convert each element of dynamic.array to a specified internal storage format. | ICONVS (dynamic.array, conversion) | |
| IFS function | BASIC | Use the IFS function to return a dynamic array whose elements are chosen individually from one of two dynamic arrays based on the contents of a third dynamic array. | IFS (dynamic.array, true.array, false.array) | |
| ILPROMPT function | BASIC | Use the ILPROMPT function to evaluate a string containing UniVerse in-line prompts. | ILPROMPT (in.line.prompt) | E |
| INDEX function | BASIC | Use the INDEX function to return the starting character position for the specified occurrence of substring in string. | INDEX (string, substring, occurrence) | E |
| INDEXS function | BASIC | Use the INDEXS function to return a dynamic array of the starting column positions for a specified occurrence of a substring in each element of dynamic.array. | INDEXS (dynamic.array, substring, occurrence) | |
| INDICES function | BASIC | Use the INDICES function to return information about the secondary key indexes in a file. | INDICES (file.variable [,indexname]) | |
| INMAT function | BASIC | Use the INMAT function to return the number of array elements that have been loaded after the execution of a MATREAD, MATREADL, MATREADU, or MATPARSE statement, or to return the modulo of a file after the execution of an OPEN statement. You can also use the INMAT function after a DIM statement to determine whether the DIM statement failed due to lack of available memory. If a preceding DIM statement fails, INMAT returns a value of 1. | INMAT ( [array] ) | E |
| INSERT function | BASIC | Use the INSERT function to return a dynamic array that has a new field, value, or subvalue inserted into the specified dynamic array. | INSERT (dynamic.array, field#, value#, subvalue#, expression) | E |
| INT function | BASIC | Use the INT function to return the integer portion of an expression. | INT (expression) | E |
| ISNULL function | BASIC | Use the ISNULL function to test whether a variable is the null value. If variable is the null value, 1 (true) is returned, otherwise 0 (false) is returned. This is the only way to test for the null value since the null value is not equal to any value, including itself. | ISNULL (variable) | E |
| ISNULLS function | BASIC | Use the ISNULLS function to test whether any element of dynamic.array is the null value. A dynamic array is returned, each of whose elements is either 1 (true) or 0 (false). If an element in dynamic.array is the null value, 1 is returned, otherwise 0 is returned. This is the only way to test for the null value since the null value is not equal to any value, including itself. | ISNULLS (dynamic.array) | E |
| ITYPE function | BASIC | Use the ITYPE function to return the value resulting from the evaluation of an I-descriptor expression in a UniVerse file dictionary. | ITYPE (i.type) | E |
| KEYIN function | BASIC | Use the KEYIN function to read a single character from the input buffer and return it. All UniVerse special character handling (such as case inversion, erase, kill, and so on) is disabled. UNIX special character handling (processing of interrupts, XON/XOFF, conversion of CR to LF, and so on) still takes place. | KEYIN ( ) | |
| LEFT function | BASIC | Use the LEFT function to extract a substring comprising the first n characters of a string, without specifying the starting character position. It is equivalent to the following substring extraction operation: | LEFT (string, n) | E |
| LEN function | BASIC | Use the LEN function to return the number of characters in string. Note that calculations are based on character length rather than display length. | LEN (string) | E |
| LENDP function | BASIC | In NLS mode, use the LENDP function to return the number of display positions occupied by string when using the specified map. Calculations are based on display length rather than character length. | LENDP (string, [,mapname] ) | |
| LENS function | BASIC | Use the LENS function to return a dynamic array of the number of display positions in each element of dynamic.array. Calculations are based on character length rather than display length. | LENS (dynamic.array) | |
| LENSDP function | BASIC | In NLS mode, use the LENSDP function to return a dynamic array of the number of display positions occupied by each element of dynamic.array. Note that calculations are based on display length rather than character length. | LENSDP (dynamic.array, [, mapname] ) | |
| LES function | BASIC | Use the LES function to test if elements of one dynamic array are less than or equal to the elements of another dynamic array. | LES (array1, array2) | |
| LN function | BASIC | Use the LN function to calculate the natural logarithm of the value of an expression, using base "e". The value of "e" is approximately 2.71828. expression must evaluate to a numeric value greater than 0. | LN (expression) | E |
| LOCALEINFO function | BASIC | In NLS mode, use the LOCALEINFO function to retrieve the settings of the current locale. | LOCALEINFO (categories) | E |
| LOWER function | BASIC | Use the LOWER function to return a value equal to expression, except that system delimiters which appear in expression are converted to the next lower-level delimiter: field marks are changed to value marks, value marks are changed to subvalue marks, and so on. If expression evaluates to the null value, null is returned. | LOWER (expression) | E |
| LTS function | BASIC | Use the LTS function to test if elements of one dynamic array are less than elements of another dynamic array. | LTS (array1, array2) | |
| MATCHFIELD function | BASIC | Use the MATCHFIELD function to check a string against a match pattern (see the MATCH operator for information about pattern matching). | MATCHFIELD (string, pattern, field) | E |
| MAXIMUM function | BASIC | Use the MAXIMUM function to return the element with the highest numeric value in dynamic.array. Nonnumeric values, except the null value, are treated as 0. If dynamic.array evaluates to the null value, null is returned. Any element that is the null value is ignored, unless all elements of dynamic.array are null, in which case null is returned. | MAXIMUM (dynamic.array) | E |
| MINIMUM function | BASIC | Use the MINIMUM function to return the element with the lowest numeric value in dynamic.array. Nonnumeric values, except the null value, are treated as 0. If dynamic.array evaluates to the null value, null is returned. Any element that is the null value is ignored, unless all elements of dynamic.array are null, in which case null is returned. | MINIMUM (dynamic.array) | E |
| MOD function | BASIC | Use the MOD function to calculate the value of the remainder after integer division is performed on the dividend expression by the divisor expression. | MOD (dividend, divisor) | E |
| MODS function | BASIC | Use the MODS function to create a dynamic array of the remainder after the integer division of corresponding elements of two dynamic arrays. | MODS (array1, array2) | E |
| MULS function | BASIC | Use the MULS function to create a dynamic array of the element-by-element multiplication of two dynamic arrays. | MULS (array1, array2) | E |
| NEG function | BASIC | Use the NEG function to return the arithmetic inverse of the value of the argument. | NEG (number) | E |
| NEGS function | BASIC | Use the NEGS function to return the negative values of all the elements in a dynamic array. If the value of an element is negative, the returned value is positive. If dynamic.array evaluates to the null value, null is returned. If any element is null, null is returned for that element. | NEGS (dynamic.array) | |
| NES function | BASIC | Use the NES function to test if elements of one dynamic array are equal to the elements of another dynamic array. | NES (array1, array2) | |
| NOT function | BASIC | Use the NOT function to return the logical complement of the value of expression. If the value of expression is true, the NOT function returns a value of false (0). If the value of expression is false, the NOT function returns a value of true (1). | NOT (expression) | E |
| NOTS function | BASIC | Use the NOTS function to return a dynamic array of the logical complements of each element of dynamic.array. If the value of the element is true, the NOTS function returns a value of false (0) in the corresponding element of the returned array. If the value of the element is false, the NOTS function returns a value of true (1) in the corresponding element of the returned array. | NOTS (dynamic.array) | E |
| NUM function | BASIC | Use the NUM function to determine whether expression is a numeric or nonnumeric string. If expression is a number, a numeric string, or an empty string, it evaluates to true and a value of 1 is returned. If expression is a nonnumeric string, it evaluates to false and a value of 0 is returned. | NUM (expression) | E |
| NUMS function | BASIC | Use the NUMS function to determine whether the elements of a dynamic array are numeric or nonnumeric strings. If an element is numeric, a numeric string, or an empty string, it evaluates to true, and a value of 1 is returned to the corresponding element in a new dynamic array. If the element is a nonnumeric string, it evaluates to false, and a value of 0 is returned. | NUMS (dynamic.array) | |
| OCONV function | BASIC | Use the OCONV function to convert string to a specified format for external output. The result is always a string expression. | OCONV (string, conversion) | E |
| OCONVS function | BASIC | Use the OCONVS function to convert the elements of dynamic.array to a specified format for external output. | OCONVS (dynamic.array, conversion) | |
| ORS function | BASIC | Use the ORS function to create a dynamic array of the logical OR of corresponding elements of two dynamic arrays. | ORS (array1, array2) | E |
| PWR function | BASIC | Use the PWR function to return the value of expression raised to the power specified by power. | PWR (expression, power) | E |
| QUOTE function | BASIC | Use the QUOTE function to enclose an expression in double quotation marks. If expression evaluates to the null value, null is returned, without quotation marks. | QUOTE (expression) | E |
| RAISE function | BASIC | Use the RAISE function to return a value equal to expression, except that system delimiters in expression are converted to the next higher-level delimiter: value marks are changed to field marks, subvalue marks are changed to value marks, and so on. If expression evaluates to the null value, null is returned. | RAISE (expression) | E |
| REAL function | BASIC | Use the REAL function to convert number into a floating-point number without loss of accuracy. If number evaluates to the null value, null is returned. | REAL (number) | |
| RECORDLOCKED function | BASIC | Use the RECORDLOCKED function to return the status of a record lock. | RECORDLOCKED (file.variable, record.ID) | E |
| REM function | BASIC | Use the REM function to calculate the remainder after integer division is performed on the dividend expression by the divisor expression. | REM (dividend, divisor) | E |
| REMOVE function | BASIC | Use the REMOVE function to successively extract and return dynamic array elements that are separated by system delimiters, and to indicate which system delimiter was found. When a system delimiter is encountered, the value of the extracted element is returned. The REMOVE function is more efficient than the EXTRACT function for extracting successive fields, values, and so on, for multivalue list processing. | REMOVE (dynamic.array, variable) | E |
| REPLACE function | BASIC | Use the REPLACE function to return a copy of a dynamic array with the specified field, value, or subvalue replaced with new data. |
REPLACE (expression, field#, value#, subvalue# {, | ;}
replacement) |
E |
| REUSE function | BASIC | Use the REUSE function to specify that the value of the last field, value, or subvalue be reused in a dynamic array operation. | REUSE (expression) | E |
| RIGHT function | BASIC | Use the RIGHT function to extract a substring comprising the last n characters of a string. It is equivalent to the following substring extraction operation: | RIGHT (string, n) | E |
| RND function | BASIC | Use the RND function to generate any positive or negative random integer or 0. | RND (expression) | E |
| RPC.CALL function | BASIC | Use the RPC.CALL function to make requests of a connected server. The request is packaged and sent to the server using the C client RPC library. RPC.CALL returns the results of processing the remote request: 1 for success, 0 for failure. |
RPC.CALL (connection.ID, procedure, #args, MAT arg.list,
#values, MAT return.list) |
E |
| RPC.CONNECT function | BASIC | Use the RPC.CONNECT function to establish a connection to a server process. Once the host and server are identified, the local uniVerse/Net daemon tries to connect to the remote server. If the attempt succeeds, RPC.CONNECT returns a connection ID. If it fails, RPC.CONNECT returns 0. The connection ID is a nonzero integer used to refer to the server in subsequent calls to RPC.CALL and RPC.DISCONNECT. | RPC.CONNECT (host, server) | E |
| RPC.DISCONNECT function | BASIC | Use the RPC.DISCONNECT function to end an RPC session. | RPC.DISCONNECT (connection.ID) | E |
| SADD function | BASIC | Use the SADD function to add two string numbers and return the result as a string number. You can use this function in any expression where a string or string number is valid, but not necessarily where a standard number is valid, because string numbers can exceed the range of numbers that standard arithmetic operators can handle. | SADD (string.number.1, string.number.2) | E |
| SCMP function | BASIC | Use the SCMP function to compare two string numbers and return one of the following three numbers: -1 (less than), 0 (equal), or 1 (greater than). If string.number.1 is less than string.number.2, the result is -1. If they are equal, the result is 0. If string.number.1 is greater than string.number.2, the result is 1. You can use this function in any expression where a string or string number is valid. | SCMP (string.number.1, string.number.2) | E |
| SDIV function | BASIC | Use the SDIV function to divide string.number.1 by string.number.2 and return the result as a string number. You can use this function in any expression where a string or string number is valid, but not necessarily where a standard number is valid, because string numbers can exceed the range of numbers which standard arithmetic operators can handle. Either string number can be a valid number or a string number. | SDIV (string.number.1, string.number.2 [,precision]) | E |
| SELECTINFO function | BASIC | Use the SELECTINFO function to determine whether a select list is active, or to determine the number of items it contains. | SELECTINFO (list, key) | E |
| SEND function | BASIC | Use the SEND statement to write a block of data to a device. The SEND statement can be used to write data to a device that has been opened for I/O using the OPENDEV or OPENSEQ statement. |
SEND output.expr [:] TO device
{THEN statements [ELSE statements] | ELSE statements} |
E |
| SENTENCE function | BASIC | Use the SENTENCE function to return the stored sentence that invoked the current process. Although the SENTENCE function uses no arguments, parentheses are required to identify it as a function. The SENTENCE function is a synonym for the @SENTENCE system variable. | SENTENCE ( ) | E |
| SEQ function | BASIC | Use the SEQ function to convert an ASCII character to its numeric string equivalent. | SEQ (expression) | E |
| SEQS function | BASIC | Use the SEQS function to convert a dynamic array of ASCII characters to their numeric string equivalents. | SEQS (dynamic.array) | E |
| SETLOCALE function | BASIC | In NLS mode, use the SETLOCALE function to enable or disable a locale for a specified category or change its setting. | SETLOCALE (category, value) | E |
| SIN function | BASIC | Use the SIN function to return the trigonometric sine of an expression. expression represents the angle expressed in degrees. Numbers greater than 1E17 produce a warning message, and 0 is returned. If expression evaluates to the null value, null is returned. | SIN (expression) | E |
| SINH function | BASIC | Use the SINH function to return the hyperbolic sine of expression. expression must be numeric and represents the angle expressed in degrees. If expression evaluates to the null value, null is returned. | SINH (expression) | E |
| SLEEP function | BASIC | Use the SLEEP statement to suspend execution of a BASIC program, pausing for a specified number of seconds. | SLEEP [seconds] | E |
| SMUL function | BASIC | Use the SMUL function to multiply two string numbers and return the result as a string number. You can use this function in any expression where a string or string number is valid, but not necessarily where a standard number is valid, because string numbers can exceed the range of numbers that standard arithmetic operators can handle. | SMUL (string.number.1, string.number.2) | E |
| SOUNDEX function | BASIC | The SOUNDEX function evaluates expression and returns the most significant letter in the input string followed by a phonetic code. Nonalphabetic characters are ignored. If expression evaluates to the null value, null is returned. | SOUNDEX (expression) | E |
| SPACE function | BASIC | Use the SPACE function to return a string composed of blank spaces. expression specifies the number of spaces in the string. If expression evaluates to the null value, the SPACE function fails and the program terminates with a run-time error message. | SPACE (expression) | E |
| SPACES function | BASIC | Use the SPACES function to return a dynamic array with elements composed of blank spaces. dynamic.array specifies the number of spaces in each element. If dynamic.array or any element of dynamic.array evaluates to the null value, the SPACES function fails and the program terminates with a run- time error message. | SPACES (dynamic.array) | |
| SPLICE function | BASIC | Use the SPLICE function to create a dynamic array of the element-by-element concatenation of two dynamic arrays, separating concatenated elements by the value of expression. | SPLICE (array1, expression, array2) | E |
| SQRT function | BASIC | Use the SQRT function to return the square root of expression. The expression must evaluate to a numeric value that is greater than or equal to 0. If expression evaluates to a negative value, the result of the function is SQRT(-n) and an error message is printed. If expression evaluates to the null value, null is returned. | SQRT (expression) | E |
| SQUOTE function | BASIC | Use the SQUOTE function to enclose an expression in single quotation marks. If expression evaluates to the null value, null is returned, without quotation marks. | SQUOTE (expression ) | E |
| SSUB function | BASIC | Use the SSUB function to subtract string.number.2 from string.number.1 and return the result as a string number. You can use this function in any expression where a string or string number is valid, but not necessarily where a standard number is valid, because string numbers can exceed the range of numbers that standard arithmetic operators can handle. | SSUB (string.number.1, string.number.2) | E |
| STATUS function | BASIC | Use the STATUS function to determine the results of the operations performed by certain statements and functions. | STATUS ( ) | E |
| STR function | BASIC | Use the STR function to produce a specified number of repetitions of a particular character string. | STR (string, repeat) | E |
| STRS function | BASIC | Use the STRS function to produce a dynamic array containing the specified number of repetitions of each element of dynamic.array. | STRS (dynamic.array, repeat) | E |
| SUBR function | BASIC | Use the SUBR function to return the value of an external subroutine. The SUBR function is commonly used in I- descriptors. | SUBR (name, [argument [,argument...]] ) | E |
| SUBS function | BASIC | Use the SUBS function to create a dynamic array of the element-by-element subtraction of two dynamic arrays. | SUBS (array1, array2) | E |
| SUBSTRINGS function | BASIC | Use the SUBSTRINGS function to create a dynamic array each of whose elements are substrings of the corresponding elements of dynamic.array. | SUBSTRINGS (dynamic.array, start, length) | E |
| SUM function | BASIC | Use the SUM function to calculate the sum of numeric data. Only elements at the lowest delimiter level of a dynamic array are summed. The total is returned as a single element at the next highest delimiter level. | SUM (dynamic.array) | E |
| SUMMATION function | BASIC | Use the SUMMATION function to return the sum of all the elements in dynamic.array. Nonnumeric values, except the null value, are treated as 0. | SUMMATION (dynamic.array) | E |
| SYSTEM function | BASIC | Use the SYSTEM function to check on the status of a system function. Use the SYSTEM function to test whether NLS is on when you run a program, and to display information about NLS settings. | SYSTEM (expression) | E |
| TAN function | BASIC | Use the TAN function to return the trigonometric tangent of expression. expression represents an angle expressed in degrees. | TAN (expression) | E |
| TANH function | BASIC | Use the TANH function to return the hyperbolic tangent of expression. expression must be numeric and represents the angle expressed in degrees. If expression evaluates to the null value, null is returned. | TANH (expression) | E |
| TERMINFO function | BASIC | Use the TERMINFO function to access the device-independent terminal handler string defined for the current terminal type. The TERMINFO function returns a dynamic array containing the terminal characteristics for the terminal type set by TERM or SET.TERM.TYPE. | TERMINFO (argument) | E |
| TIME function | BASIC | Use the TIME function to return a string value expressing the internal time of day. The internal time is the number of seconds that have passed since midnight to the nearest thousandth of a second (local time). | TIME ( ) | E |
| TIMEDATE function | BASIC | Use the TIMEDATE function to return the current system time and date in the following format: | TIMEDATE ( ) | E |
| TPARM function | BASIC | Use the TPARM function to evaluate a parameterized terminfo string. |
TPARM (terminfo.string, [arg1], [arg2], [arg3], [arg4],
[arg5], [arg6], [arg7], [arg8] ) |
|
| TRANS function | BASIC | Use the TRANS function to return the contents of a field or a record in a UniVerse file. TRANS opens the file, reads the record, and extracts the specified data. | TRANS ([DICT] filename, record.ID, field#, control.code) | E |
| TRANSACTION ABORT function | BASIC | Use the TRANSACTION ABORT statement to cancel all file I/O changes made during a transaction. | TRANSACTION ABORT | E |
| TRIM function | BASIC | Use the TRIM function to remove unwanted characters in expression. If only expression is specified, multiple occurrences of spaces and tabs are reduced to a single tab or space, and all leading and trailing spaces and tabs are removed. | TRIM (expression [,character [,option]] ) | E |
| TRIMB function | BASIC | Use the TRIMB function to remove all trailing spaces and tabs from expression. All other spaces or tabs in expression are left intact. If expression evaluates to the null value, null is returned. | TRIMB (expression) | E |
| TRIMBS function | BASIC | Use the TRIMBS function to remove all trailing spaces and tabs from each element of dynamic.array. | TRIMBS (dynamic.array) | |
| TRIMF function | BASIC | Use the TRIMF function to remove all leading spaces and tabs from expression. All other spaces or tabs in expression are left intact. If expression evaluates to the null value, null is returned. | TRIMF (expression) | E |
| TRIMFS function | BASIC | Use the TRIMFS function to remove all leading spaces and tabs from each element of dynamic.array. | TRIMFS (dynamic.array) | |
| TRIMS function | BASIC | Use the TRIMS function to remove unwanted spaces and tabs from each element of dynamic.array. | TRIMS (dynamic.array) | |
| UNASSIGNED function | BASIC | Use the UNASSIGNED function to determine if variable is unassigned. UNASSIGNED returns 1 (true) if variable is unassigned. It returns 0 (false) if variable is assigned a value, including the null value. | UNASSIGNED (variable) | E |
| UNICHAR function | BASIC | Use the UNICHAR function to generate a single character from a Unicode value. | UNICHAR (unicode) | N |
| UPCASE function | BASIC | Use the UPCASE function to change all lowercase letters in expression to uppercase. If expression evaluates to the null value, null is returned. | UPCASE (expression) | E |
| XLATE function | BASIC | Use the XLATE function to return the contents of a field or a record in a UniVerse file. XLATE opens the file, reads the record, and extracts the specified data. | XLATE ([DICT] filename, record.ID, field#, control.code) | E |
| XTD function | BASIC | Use the XTD function to convert a string of hexadecimal characters to an integer. If string evaluates to the null value, null is returned. | XTD (string) | E |
| Set Function | SQL | Use set function syntax when you see set_function in a syntax line. You can use set functions in the following clauses of the SELECT statement: |
COUNT( * )
{AVG | MAX | MIN | SUM | COUNT} (DISTINCT column) {AVG | MAX | MIN | SUM | COUNT} ( [ALL] select_expression) |
All documents copyright by their respective owners.