Operators and Functions by Category

Following are quick lookup tables for each category of operators and functions:

• Arithmetical Operators and Functions
  
• Scientific Functions
  
• Character Operators and Functions
  
• Date Operators and Functions
  
• Logical Operators and Functions
  
• Multi-Occurrence Operators and Functions
  
• Relational Operators
  
• Time Operators
  

In these lookup tables operands and parameters may have the following data types:

C Mixed case character (ASCII collate)
D Date
H Unsigned 16 bit integer (range 0 to 65535)
I 16 bit integer (range −32767 to 32767)
J Unsigned 8 bit integer (range 0 to 255)
K Signed 8 bit integer (range -128 to 127)
L 32 bit integer
M Mixed case character (Database collate)
N Number (for very large or non integer numbers)
P Pseudo numeric (Digit only character fields)
S System character (for DP4 Names)
T Time
U Upper case character with Database collate
Y Boolean (Yes/No)

To simplify the lookup tables note the following:

• where N is indicated, H, I, J, K and L may also be used
• where C is indicated, M, P, S and U may be used