SUBBITSTR Result Type and Attributes - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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:

target_arg Type Result Type Result Format is Default Format for This Type
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).