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
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 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)