@HIGHVAL | LOWVAL
Use the @HIGHVAL
and @LOWVAL
functions when you need to generate a value, but you want to constrain it within an upper or lower limit. These functions emulate the COBOL functions of the same names.
Use @HIGHVAL
and @LOWVAL
only with string and binary data types. When using them with strings, only @STRNCMP
is valid. Using them with decimal or date data types or with SQLEXEC
operations can cause errors. DOUBLE
data types result in -1
or 0
(Oracle NUMBER
, no precision, no scale).
Syntax
@HIGHVAL ([length]) | @LOWVAL ([length])
Example
The following example assumes that the size of the group_level
column is 5 bytes.
Function statement | Result |
---|---|
group_level = @HIGHVAL () |
{0xFF, 0xFF, 0xFF, 0xFF, 0xFF} |
group_level = @LOWVAL () |
{0x00, 0x00, 0x00, 0x00, 0x00} |
group_level = @HIGHVAL (3) |
{0xFF, 0xFF, 0xFF} |
group_level = @LOWVAL (3) |
{0x00, 0x00, 0x00} |