Table B–7: Miscellaneous Functions
Syntax
|
Input Data
|
Output Data
|
In 4GL
|
CASE ( expression, when-value-a, return-value-a, when-value-b, return-value-b,..., default-return-value )
|
I ...
|
I
|
–
|
DBNAME ( )
|
N/A
|
C
|
|
DLLFUNC ( dll-name, function-name, string )
|
C, C, C
|
C
|
–
|
ENCODE ( expression )
|
C
|
C
|
|
IIF ( condition, true-value, false-value )
|
L, I, I
|
I
|
–
|
IN-LIST ( value, list-value1, ... , list-value-n)
|
I, I, ...
|
N
|
–
|
IN-RANGE ( value, low-value, high-value )
|
I, I, I
|
L
|
–
|
MAXIMUM ( expression , expression [ , expression ] ... )
|
I, I, ...
|
I
|
|
MINIMUM ( expression , expression [ , expression ] ... )
|
I, I, ...
|
I
|
|
OPSYS ( )
|
N/A
|
C
|
|
PREVIOUS ( field-name )
|
F
|
I
|
–
|
RUNTIME ( )
|
N/A
|
L
|
–
|
RUNTIME-PARAMETER (parameter-name)
|
C
|
C
|
–
|