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_COMPARE

BINARY_COMPARE

Compares two binary values and returns TRUE (1) if they are the same and FALSE (0) if they are different.
To use
BINARY_COMPARE
function, set the environment variable
INFA_ENABLE_BINARY_FUNCTIONS
to True or Yes.

Syntax

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

Return Value

TRUE (1) if value1 and value2 have equal values.
FALSE (0) if value1 and value 2 have different values.
NULL if any one of the inputs is a null value.

Example

The following examples compare two binary values.
BINARY_COMPARE( SYSID1, SYSID2 )
SYSID1 (Shown in Hex)
SYSID2 (Shown in Hex)
RETURN VALUE
0x000102030405060708
0x000102030405060708
1
0x000102030405060708
0x0405060708090A0B
0
0x000102030405060708
NULL
NULL
NULL
0x000102030405060708
NULL
NULL
NULL
NULL