X2B - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
ft:lastEdition
2024-07-30
ft:lastPublication
2024-07-30T20:19:56.898694

The X2B function converts a hexadecimal to its binary value equivalent. The return length is half of the input length.

Category

String

Syntax

X2B(value)

Parameter and Description

Parameter Description
value This parameter specifies a source datastore field/column or the hexadecimal value that will be converted into binary.

Example

Translate a three (3) byte field, BINARY_FIELD, that contains the binary value F0B1CA into its hexadecimal character representation, the length field contains the value 6. It will map it to target field HEXCHAR.

HEXCHAR = X2B (BINARY_FIELD)

Results in the source binary number being converted to a six (6) byte hex character equivalent of the number ('F0B1CA') being mapped to the six (6) byte field HEXCHAR.