Functions
The following are the functions supported by the system:
Functions | Description |
|---|---|
Arithmetic Operations | |
ABS | Absolute value of a REAL value |
EXPT, POW | Exponent, power calculation of REAL values |
LOG | Logarithm of a REAL value |
MOD | Modulo |
SQRT | Square root of a REAL value |
RAND | Random value |
TRUNC | Truncate decimal part of a REAL value |
ACOS, ASIN, COS | Arc cosine, Arc sine, Arc tangent of a REAL value |
COS, SIN, TAN | Cosine, Sine, Tangent of a REAL value |
Binary Operations | |
AND_MASK | Integer bit-to-bit AND mask |
OR_MASK | Integer bit-to-bit OR mask |
XOR_MASK | Integer bit-to-bit Exclusive OR mask |
NOT_MASK | Integer bit-to-bit negation |
ROL, ROR | Rotate Left, Rotate Right an integer value |
SHL, SHR | Shift Left, Shift Right an integer value |
Boolean Operations | |
ODD | Odd parity |
Data Manipulation | |
MIN, MAX, LIMIT | Minimum, Maximum, Limit |
MUX4, MUX8 | Multiplexer (4 or 8 entries) |
SEL | Binary selector |
String Manipulation | |
ASCII | Character -> ASCII code |
COS | ASCII code -> Character |
MLEN | Get string length |
DELETE, INSERT | Delete sub-string, Insert string |
FIND, REPLACE | Find sub-string, Replace sub-string |
LEFT, MID, RIGHT | Extract left, middle or right of a string |
Time Operations | |
CURRENT_ISA_DATE | Gets the current date |
SUB_DATE_DATE | Compares two dates and provides the difference in TIME format |
Provide Feedback