X2C - 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 X2C function converts a data string in hexadecimal format into a character data string. The code page of the hexadecimal translation is determined by the platform in which the X2C function was executed (i.e. EBCDIC for z/OS).

Category

String

Syntax

X2C(data_string)

Parameter and Description

Parameter Description
data_string The source data string in hexadecimal format. The source data string may be a field/column of a datastore, a literal value or the result of another Function.

Example

Convert the z/OS (EBCDIC) hexadecimal value of C1C2C3 into character format. Map the result to target field HEX_TO_CHAR.

HEX_TO_CHAR = X2C ('C1C2C3')

Returns the value 'ABC' and maps the result to the target field.