Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

BINARY_LENGTH

BINARY_LENGTH

Returns the length of a binary value.
To use the
BINARY_LENGTH
function, set the environment variable
INFA_ENABLE_BINARY_FUNCTIONS
to True or Yes.

Syntax

BINARY_LENGTH(
value
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value
Required
Binary datatype

Return Value

Integer representing the length of the binary value.
NULL if the input is a null value.

Example

The following examples return the lengths of various binary values.
BINARY_LENGTH( SYSID )
SYSID1 (Shown in Hex)
RETURN VALUE
0x000102030405060708
9
0x00010203040506
7
0x00010203040506070809
10
NULL
NULL