The result data type is a VARBYTE string. The size (number of bytes) of the VARBYTE string depends on the data type of the target_arg input argument and the number of bits requested.
For example:
| IF the data type of target_arg is... | THEN the result type is... | AND the result format is the default format for... |
|---|---|---|
| BYTEINT | VARBYTE(1) | VARBYTE(1) |
| SMALLINT | VARBYTE(2) | VARBYTE(2) |
| INTEGER | VARBYTE(4) | VARBYTE(4) |
| BIGINT | VARBYTE(8) | VARBYTE(8) |
| VARBYTE(n) | VARBYTE(m) where m is the smallest number of bytes to accommodate the requested number of bits. |
VARBYTE(m) |
The maximum supported size (n) for VARBYTE is 8192 bytes.
The default title for SUBBITSTR is: SUBBITSTR(target_arg, position_arg, num_bits_arg).