@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>])

<length>

Optional. Specifies the binary output length in bytes. The maximum value of <length> is the length of the target column.

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}