Preface
The Transformation Language
Constants
Operators
Variables
Dates
Functions
- Function Categories
  - Aggregate Functions
  - Aggregate Functions and Nulls
    - Filter Conditions
  - Binary Functions
  - Character Functions
  - Conversion Functions
  - Data Cleansing Functions
  - Date Functions
  - Encoding Functions
  - Financial Functions
  - Numeric Functions
  - Scientific Functions
  - Special Functions
  - String Functions
  - Test Functions
  - Variable Functions
  - Window Functions
- ABORT
- ABS
- ADD_TO_DATE
- AES_DECRYPT
- AES_ENCRYPT
- ASCII
- AVG
- BINARY_COMPARE
- BINARY_CONCAT
- BINARY_LENGTH
- BINARY_SECTION
- CEIL
- CHOOSE
- CHR
- CHRCODE
- COMPRESS
- CONCAT
- CONVERT_BASE
- COS
- COSH
- COUNT
- CRC32
- CUME
- DATE_COMPARE
- DATE_DIFF
- DEC_BASE64
- DEC_HEX
- DECODE
- DECOMPRESS
- EBCDIC_ISO88591
- ENC_BASE64
- ENC_HEX
- ERROR
- EXP
- FIRST
- FLOOR
- FV
- GET_DATE_PART
- GREATEST
- IIF
- IN
- INDEXOF
- INITCAP
- INSTR
- ISNULL
- IS_DATE
- IS_NUMBER
- IS_SPACES
- LAG
- LAST
- LAST_DAY
- LEAD
- LEAST
- LENGTH
- LN
- LOG
- LOOKUP
- LOWER
- LPAD
- LTRIM
- MAKE_DATE_TIME
- MAX (Dates)
- MAX (Numbers)
- MAX (String)
- MD5
- MEDIAN
- METAPHONE
- MIN (Dates)
- MIN (Numbers)
- MIN (String)
- MOD
- MOVINGAVG
- MOVINGSUM
- NPER
- PERCENTILE
- PMT
- POWER
- PV
- RAND
- RATE
- REG_EXTRACT
- REG_MATCH
- REG_REPLACE
- REPLACECHR
- REPLACESTR
- REVERSE
- ROUND (Dates)
- ROUND (Numbers)
- RPAD
- RTRIM
- SETCOUNTVARIABLE
- SET_DATE_PART
- SETMAXVARIABLE
- SETMINVARIABLE
- SETVARIABLE
- SHA256
- SIGN
- SIN
- SINH
- SOUNDEX
- SQRT
- STDDEV
- SUBSTR
- SUM
- SYSTIMESTAMP
- TAN
- TANH
- TIME_RANGE
- TO_BIGINT
- TO_CHAR (Dates)
- TO_CHAR (Numbers)
- TO_DATE
- TO_DECIMAL
- TO_FLOAT
- TO_INTEGER
- TRUNC (Dates)
- TRUNC (Numbers)
- UPPER
- VARIANCE
Creating Custom Functions
Custom Function API Reference

Transformation Language Reference

10.5.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

Transformation Language Reference

Transformation Language Reference

BINARY_CONCAT

BINARY_CONCAT

Syntax

Return Value

Nulls

Example