IT    Universe documentation - Operator

Operator

Contents:

Id Category Description Syntax E/W
< > operator BASIC Use the < > operator (angle brackets) to extract or replace elements of a dynamic array.   variable < field# [,value# [,subvalue#]] >    
Arithmetic Operators BASIC Arithmetic operators combine operands comprising one or more variables, constants, or intrinsic functions. Resulting arithmetic expressions can be combined with other expressions almost indefinitely. The syntax of arithmetic expressions is:      
Assignment Operators BASIC Assignment operators are used in UniVerse BASIC assignment statements to assign values to variables. The following table shows the operators and their uses.      
IF Operator BASIC The IF operator lets you indicate a value conditional upon the truth of another value. The IF operator has the following syntax:      
Logical Operators BASIC Numeric data, string data, and the null value can function as logical data. Numeric and string data can have a logical value of true or false. The numeric value 0 (zero), is false; all other numeric values are true. Character string data other than an empty string is true; an empty string is false. The null value is neither true nor false. It has the special logical value of null.     N  
MATCH operator BASIC Use the MATCH operator or its synonym MATCHES to compare a string expression with a pattern.   string MATCH[ES] pattern    
Pattern Matching Operators BASIC The pattern matching operator, MATCH, and its synonym, MATCHES, compare a string expression to a pattern. The syntax for a pattern match expression is:      
Relational Operators BASIC Relational operators compare numeric, character string, or logical data. The result of the comparison, either true (1) or false (0), can be used to make a decision regarding program flow (see the IF statement). The following table lists the relational operators.     N  
String Operators BASIC The concatenation operator ( : or CAT) links string expressions to form compound string expressions, as follows:      
Substring Operator BASIC A substring is a subset of contiguous characters of a character string. For example, JAMES is a substring of the string JAMES JONES. JAMES JON is also a substring of JAMES JONES.      
[ ] operator BASIC Use the [ ] operator (square brackets) to extract a substring from a character string. The larger bold brackets are part of the syntax and must be typed.   expression [[start,] length]
expression [delimiter, occurrence, fields]  		 E  
Relational Operator SQL The relational operators are as follows:      
UNION Operator SQL The UNION operator combines the results of two SELECT statements into a single result table. A set of SELECT statements joined by UNION operators is called a query expression. You can use query expressions as interactive SQL queries, programmatic SQL queries, and in the CREATE VIEW statement. However, you cannot use a query expression as a subquery or in the INSERT statement.     EN  

All documents copyright by their respective owners.

2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81