FULLKEY (IMS Fullkey) - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2026
First publish date
2000
ft:lastEdition
2026-03-04
ft:lastPublication
2026-03-04T14:06:44.769231
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

The FULLKEY function returns the fully concatenated key of the current IMS segment. This function is useful for appending key data to child segments prior to writing the data to an output datastore. See also, the PFK_ function.

Note: FULLKEY is only applicable to IMS type datastores.

Category

Specialized

Syntax
FULLKEY()

Parameter and Description

This function has no parameters.

Example

Return the fully concatenated key of an IMS segment and map it to target field IMS_KEY.

IMS_KEY = FULLKEY()

Map the first three (3) bytes of the fully concatenated key to target field IMS_PARTIAL_KEY.

IMS_PARTIAL_KEY = LEFT(FULLKEY(), 3)