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_CONCAT

BINARY_CONCAT

Concatenates two or more binary values together and returns the concatenated value.
To use the
BINARY_CONCAT
function, set the environment variable
INFA_ENABLE_BINARY_FUNCTIONS
to True or Yes.

Syntax

BINARY_CONCAT(
value1, value2 [, value3] … [, valueN]
)
The following table describes the argument for this command:
Argument
Required/
Optional
Description
value1
Required
Binary datatype
value2
Required
Binary datatype
value3 - valueN
Optional
Binary datatype

Return Value

Binary.
NULL if all the input values are null.

Nulls

If any one of the input values is null then
BINARY_CONCAT
ignores it and returns the concatenated value of the remaining input values.
If all the input values are null then
BINARY_CONCAT
returns null.

Example

The following example concatenates two binary values.
BINARY_CONCAT( SYSID1, SYSID2 )
SYSID1 (Shown in Hex)
SYSID2 (Shown in Hex)
RETURN VALUE (Shown in Hex)
0x000102030405060708
0x000102030405060708
0x000102030405060708000102030405060708
0x000102030405060708
0x0405060708090A0B
0x0001020304050607080405060708090A0B
0x000102030405060708
NULL
0x000102030405060708
NULL
0x000102030405060708
0x000102030405060708
NULL
NULL
NULL