Connect CDC SQData

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 Descriptions

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)